APPS.FTE_TRACKING_WRAPPER dependencies on FTE_MESSAGE_ADDRESS

Line 503: FTE_MESSAGE_ADDRESS(

499:
500:
501: BEGIN
502: INSERT INTO
503: FTE_MESSAGE_ADDRESS(
504: ADDRESS_TO_ID,ID ,
505: TRANSACTION_ID ,
506: ADDRESS_TO_TABLE ,
507: ADDR_LINE1 ,

Line 604: from fte_message_address fa

600: CREATION_DATE ,
601: LAST_UPDATED_BY ,
602: LAST_UPDATE_DATE ,
603: LAST_UPDATE_LOGIN
604: from fte_message_address fa
605: where transaction_id =p_transaction_id ;
606: EXCEPTION
607: WHEN OTHERS THEN
608: l_exception_message := substr(SQLERRM,1,100);

Line 833: -- fte_message_address and populate the location cloumn of

829: --========================================================================
830: -- PROCEDURE : Get Location FTE Tracking wrapper
831: --
832: -- COMMENT : Get the city,state and country information from the
833: -- fte_message_address and populate the location cloumn of
834: -- fte_delivery_proof table using address_to_id as the foreign
835: -- key for fte_message_location .
836: --========================================================================
837:

Line 850: FTE_MESSAGE_ADDRESS

846: SELECT ADDR_CITY,
847: ADDR_STATE,
848: ADDR_COUNTRY
849: FROM
850: FTE_MESSAGE_ADDRESS
851: WHERE
852: ADDRESS_TO_ID=P_LOC_ID;
853: BEGIN
854:

Line 855: --GET VALLUES FROM FTE_MESSAGE_ADDRESS

851: WHERE
852: ADDRESS_TO_ID=P_LOC_ID;
853: BEGIN
854:
855: --GET VALLUES FROM FTE_MESSAGE_ADDRESS
856: OPEN C_GET_CSC(p_location_id);
857: FETCH C_GET_CSC INTO L_addr_CITY,L_addr_STATE,L_addr_COUNTRY;
858: CLOSE C_GET_CSC;
859:

Line 1050: --Get the location inforamtion for the POD from the fte_message_address for the location id

1046: NULL; --No records in FTE_DELIVERY_PROOF table
1047: END ;
1048:
1049: BEGIN
1050: --Get the location inforamtion for the POD from the fte_message_address for the location id
1051: SELECT id INTO l_location_id
1052: FROM fte_message_location
1053: WHERE transaction_id=p_transaction_id
1054: and location_to_table = 'FTE_DELIVERY_PROOF';

Line 1142: --Get the location inforamtion for the POD from the fte_message_address for the location id

1138: NULL; --No records in FTE_DELIVERY_PROOF table
1139: END ;
1140:
1141: BEGIN
1142: --Get the location inforamtion for the POD from the fte_message_address for the location id
1143: select id into l_location_id
1144: from fte_message_location
1145: where transaction_id=p_transaction_id
1146: and location_to_table = 'FTE_DELIVERY_PROOF';

Line 1230: --Get the location inforamtion for the POD from the fte_message_address for the location id

1226: WHEN OTHERS THEN
1227: NULL; --No records in FTE_DELIVERY_PROOF table
1228: END ;
1229:
1230: --Get the location inforamtion for the POD from the fte_message_address for the location id
1231:
1232: BEGIN
1233: select id into l_location_id
1234: from fte_message_location

Line 1480: --Get the location inforamtion for the POD from the fte_message_address for the location id

1476: WHEN OTHERS THEN
1477: NULL; --No records in FTE_DELIVERY_PROOF table
1478: END ;
1479:
1480: --Get the location inforamtion for the POD from the fte_message_address for the location id
1481:
1482: BEGIN
1483: select id into l_location_id
1484: from fte_message_location