M_OBJECT_NAME

M_OBJECT_NAME          CONSTANT VARCHAR2(16)  := 'SHIP_TO_LOCATION';

M_CODE

M_CODE                 CONSTANT VARCHAR2(12)  := 'FTVSHIP_CODE';

M_EFF_DATE

M_EFF_DATE             CONSTANT VARCHAR2(16)  := 'FTVSHIP_EFF_DATE';

M_ACTIVITY_DATE

M_ACTIVITY_DATE        CONSTANT VARCHAR2(21)  := 'FTVSHIP_ACTIVITY_DATE';

M_USER_ID

M_USER_ID              CONSTANT VARCHAR2(15)  := 'FTVSHIP_USER_ID';

M_NCHG_DATE

M_NCHG_DATE            CONSTANT VARCHAR2(17)  := 'FTVSHIP_NCHG_DATE';

M_TERM_DATE

M_TERM_DATE            CONSTANT VARCHAR2(17)  := 'FTVSHIP_TERM_DATE';

M_ADDR_LINE1

M_ADDR_LINE1           CONSTANT VARCHAR2(18) := 'FTVSHIP_ADDR_LINE1';

M_ADDR_LINE2

M_ADDR_LINE2           CONSTANT VARCHAR2(18) := 'FTVSHIP_ADDR_LINE2';

M_BUILDING

M_BUILDING             CONSTANT VARCHAR2(16)  := 'FTVSHIP_BUILDING';

M_FLOOR

M_FLOOR                CONSTANT VARCHAR2(13)  := 'FTVSHIP_FLOOR';

M_CITY

M_CITY                 CONSTANT VARCHAR2(12)  := 'FTVSHIP_CITY';

M_STATE

M_STATE                CONSTANT VARCHAR2(13)  := 'FTVSHIP_STATE';

M_ZIP_CODE

M_ZIP_CODE             CONSTANT VARCHAR2(16)  := 'FTVSHIP_ZIP_CODE';

M_CONTACT

M_CONTACT              CONSTANT VARCHAR2(15)  := 'FTVSHIP_CONTACT';

M_PHONE_AREA

M_PHONE_AREA           CONSTANT VARCHAR2(18) := 'FTVSHIP_PHONE_AREA';

M_PHONE_NUM

M_PHONE_NUM            CONSTANT VARCHAR2(17)  := 'FTVSHIP_PHONE_NUM';

M_PHONE_EXT

M_PHONE_EXT            CONSTANT VARCHAR2(17)  := 'FTVSHIP_PHONE_EXT';

M_COAS_CODE

M_COAS_CODE            CONSTANT VARCHAR2(17)  := 'FTVSHIP_COAS_CODE';

M_ORGN_CODE

M_ORGN_CODE            CONSTANT VARCHAR2(17)  := 'FTVSHIP_ORGN_CODE';

M_ROUTE_CODE

M_ROUTE_CODE           CONSTANT VARCHAR2(18) := 'FTVSHIP_ROUTE_CODE';

M_TGRP_CODE

M_TGRP_CODE            CONSTANT VARCHAR2(17)  := 'FTVSHIP_TGRP_CODE';

M_FUND_CODE_INVTRY

M_FUND_CODE_INVTRY     CONSTANT VARCHAR2(24) := 'FTVSHIP_FUND_CODE_INVTRY';

M_ACCT_CODE_INVTRY

M_ACCT_CODE_INVTRY     CONSTANT VARCHAR2(24) := 'FTVSHIP_ACCT_CODE_INVTRY';

M_ORGN_CODE_WARE

M_ORGN_CODE_WARE       CONSTANT VARCHAR2(22) := 'FTVSHIP_ORGN_CODE_WARE';

M_PROFIT_CENTER_IND

M_PROFIT_CENTER_IND    CONSTANT VARCHAR2(25) := 'FTVSHIP_PROFIT_CENTER_IND';

M_LOCN_TYPE_CODE

M_LOCN_TYPE_CODE       CONSTANT VARCHAR2(22) := 'FTVSHIP_LOCN_TYPE_CODE';

M_DELIVERY_POINT

M_DELIVERY_POINT       CONSTANT VARCHAR2(22) := 'FTVSHIP_DELIVERY_POINT';

M_CORRECTION_DIGIT

M_CORRECTION_DIGIT     CONSTANT VARCHAR2(24) := 'FTVSHIP_CORRECTION_DIGIT';

M_CARRIER_ROUTE

M_CARRIER_ROUTE        CONSTANT VARCHAR2(21) := 'FTVSHIP_CARRIER_ROUTE';

M_PROG_CODE_WARE

M_PROG_CODE_WARE       CONSTANT VARCHAR2(22) := 'FTVSHIP_PROG_CODE_WARE';

M_ADDR_LINE3

M_ADDR_LINE3           CONSTANT VARCHAR2(18) := 'FTVSHIP_ADDR_LINE3';

M_NATN_CODE

M_NATN_CODE            CONSTANT VARCHAR2(17)  := 'FTVSHIP_NATN_CODE';

M_CTRY_CODE_PHONE

M_CTRY_CODE_PHONE      CONSTANT VARCHAR2(30)  := 'FTVSHIP_CTRY_CODE_PHONE';

M_HOUSE_NUMBER

M_HOUSE_NUMBER         CONSTANT VARCHAR2(30)  := 'FTVSHIP_HOUSE_NUMBER';

M_ADDR_LINE4

M_ADDR_LINE4           CONSTANT VARCHAR2(30)  := 'FTVSHIP_ADDR_LINE4';

p_publish_synch

Procedure p_publish_synch(p_operation_type   VARCHAR2,
                          p_code             FTVSHIP.FTVSHIP_CODE%TYPE,
                          p_eff_date         FTVSHIP.FTVSHIP_EFF_DATE%TYPE DEFAULT SYSDATE,
                          p_nchg_date        FTVSHIP.FTVSHIP_NCHG_DATE%TYPE DEFAULT SYSDATE,
                          p_addr_line1       FTVSHIP.FTVSHIP_ADDR_LINE1%TYPE DEFAULT NULL,
                          p_addr_line2       FTVSHIP.FTVSHIP_ADDR_LINE2%TYPE DEFAULT NULL,
                          p_building         FTVSHIP.FTVSHIP_BUILDING%TYPE DEFAULT NULL,
                          p_floor            FTVSHIP.FTVSHIP_FLOOR%TYPE DEFAULT NULL,
                          p_city             FTVSHIP.FTVSHIP_CITY%TYPE DEFAULT NULL,
                          p_state            FTVSHIP.FTVSHIP_STATE%TYPE DEFAULT NULL,
                          p_zip_code         FTVSHIP.FTVSHIP_ZIP_CODE%TYPE DEFAULT NULL,
                          p_contact          FTVSHIP.FTVSHIP_CONTACT%TYPE DEFAULT NULL,
                          p_phone_area       FTVSHIP.FTVSHIP_PHONE_AREA%TYPE DEFAULT NULL,
                          p_phone_num        FTVSHIP.FTVSHIP_PHONE_NUM%TYPE DEFAULT NULL,
                          p_phone_ext        FTVSHIP.FTVSHIP_PHONE_EXT%TYPE DEFAULT NULL,
                          p_addr_line3       FTVSHIP.FTVSHIP_ADDR_LINE3%TYPE DEFAULT NULL,
                          p_natn_code        FTVSHIP.FTVSHIP_NATN_CODE%TYPE DEFAULT NULL,
                          p_term_date        FTVSHIP.FTVSHIP_TERM_DATE%TYPE DEFAULT NULL,
                          p_route_code       FTVSHIP.FTVSHIP_ROUTE_CODE%TYPE DEFAULT NULL,
                          p_delivery_point   FTVSHIP.FTVSHIP_DELIVERY_POINT%TYPE DEFAULT NULL,
                          p_correction_digit FTVSHIP.FTVSHIP_CORRECTION_DIGIT%TYPE DEFAULT NULL,
                          p_carrier_route    FTVSHIP.FTVSHIP_CARRIER_ROUTE%TYPE DEFAULT NULL,
                          p_ctry_code_phone  FTVSHIP.FTVSHIP_CTRY_CODE_PHONE%TYPE DEFAULT NULL,
                          p_house_number     FTVSHIP.FTVSHIP_HOUSE_NUMBER%TYPE DEFAULT NULL,
                          p_addr_line4       FTVSHIP.FTVSHIP_ADDR_LINE4%TYPE DEFAULT NULL,
                          p_message_exists   OUT VARCHAR2)

Procedure to publish the synchronized data to the message cache.

p_register_entity

Procedure p_register_entity(p_operation_type    NUMBER,
                            p_code              FTVSHIP.FTVSHIP_CODE%TYPE,
                            p_eff_date          FTVSHIP.FTVSHIP_EFF_DATE%TYPE DEFAULT SYSDATE,
                            p_nchg_date         FTVSHIP.FTVSHIP_NCHG_DATE%TYPE DEFAULT SYSDATE,
                            p_addr_line1        FTVSHIP.FTVSHIP_ADDR_LINE1%TYPE DEFAULT NULL,
                            p_addr_line2        FTVSHIP.FTVSHIP_ADDR_LINE2%TYPE DEFAULT NULL,
                            p_addr_line3        FTVSHIP.FTVSHIP_ADDR_LINE3%TYPE DEFAULT NULL,
                            p_building          FTVSHIP.FTVSHIP_BUILDING%TYPE DEFAULT NULL,
                            p_floor             FTVSHIP.FTVSHIP_FLOOR%TYPE DEFAULT NULL,
                            p_city              FTVSHIP.FTVSHIP_CITY%TYPE DEFAULT NULL,
                            p_state             FTVSHIP.FTVSHIP_STATE%TYPE DEFAULT NULL,
                            p_zip_code          FTVSHIP.FTVSHIP_ZIP_CODE%TYPE DEFAULT NULL,
                            p_contact           FTVSHIP.FTVSHIP_CONTACT%TYPE DEFAULT NULL,
                            p_phone_area        FTVSHIP.FTVSHIP_PHONE_AREA%TYPE DEFAULT NULL,
                            p_phone_num         FTVSHIP.FTVSHIP_PHONE_NUM%TYPE DEFAULT NULL,
                            p_phone_ext         FTVSHIP.FTVSHIP_PHONE_EXT%TYPE DEFAULT NULL,
                            p_natn_code         FTVSHIP.FTVSHIP_NATN_CODE%TYPE DEFAULT NULL,
                            p_term_date         FTVSHIP.FTVSHIP_TERM_DATE%TYPE DEFAULT NULL,
                            p_coas_code         FTVSHIP.FTVSHIP_COAS_CODE%TYPE DEFAULT NULL,
                            p_orgn_code         FTVSHIP.FTVSHIP_ORGN_CODE%TYPE DEFAULT NULL,
                            p_route_code        FTVSHIP.FTVSHIP_ROUTE_CODE%TYPE DEFAULT NULL,
                            p_tgrp_code         FTVSHIP.FTVSHIP_TGRP_CODE%TYPE DEFAULT NULL,
                            p_fund_code_invtry  FTVSHIP.FTVSHIP_FUND_CODE_INVTRY%TYPE DEFAULT NULL,
                            p_acct_code_invtry  FTVSHIP.FTVSHIP_ACCT_CODE_INVTRY%TYPE DEFAULT NULL,
                            p_orgn_code_ware    FTVSHIP.FTVSHIP_ORGN_CODE_WARE%TYPE DEFAULT NULL,
                            p_profit_center_ind FTVSHIP.FTVSHIP_PROFIT_CENTER_IND%TYPE DEFAULT NULL,
                            p_locn_type_code    FTVSHIP.FTVSHIP_LOCN_TYPE_CODE%TYPE DEFAULT NULL,
                            p_delivery_point    FTVSHIP.FTVSHIP_DELIVERY_POINT%TYPE DEFAULT NULL,
                            p_correction_digit  FTVSHIP.FTVSHIP_CORRECTION_DIGIT%TYPE DEFAULT NULL,
                            p_carrier_route     FTVSHIP.FTVSHIP_CARRIER_ROUTE%TYPE DEFAULT NULL,
                            p_prog_code_ware    FTVSHIP.FTVSHIP_PROG_CODE_WARE%TYPE DEFAULT NULL,
                            p_user_id           FTVSHIP.FTVSHIP_USER_ID%TYPE DEFAULT NULL,
                            p_activty_date      FTVSHIP.FTVSHIP_ACTIVITY_DATE%TYPE DEFAULT NULL,
                            p_ctry_code_phone   FTVSHIP.FTVSHIP_CTRY_CODE_PHONE%TYPE DEFAULT NULL,
                            p_house_number      FTVSHIP.FTVSHIP_HOUSE_NUMBER%TYPE DEFAULT NULL,
                            p_addr_line4        FTVSHIP.FTVSHIP_ADDR_LINE4%TYPE DEFAULT NULL)

Registers the ship attribute value pairs to the message cache.

p_validate

Procedure p_validate(p_natn_code FTVSHIP.FTVSHIP_NATN_CODE%TYPE DEFAULT NULL)

Currently only validates nation code.