APPS.FTE_TRACKING_WRAPPER dependencies on FTE_MESSAGE_PARTNER

Line 268: --Inserting into fte_message partner as per FTEFSSI XGM to content

264: NULL; --No records in FTE_DELIVERY_PROOF table
265: END ;
266:
267:
268: --Inserting into fte_message partner as per FTEFSSI XGM to content
269: BEGIN
270:
271: select fte_tracking_status_s.nextval into l_address_to_id from dual;
272: INSERT INTO

Line 273: FTE_MESSAGE_PARTNER (

269: BEGIN
270:
271: select fte_tracking_status_s.nextval into l_address_to_id from dual;
272: INSERT INTO
273: FTE_MESSAGE_PARTNER (
274: ID,
275: NAME1 ,
276: NAME2 ,
277: NAME3 ,

Line 341: fte_message_partner WHERE TRANSACTION_ID = l_transaction_id_s ;

337: LAST_UPDATE_DATE,
338: LAST_UPDATE_LOGIN ,
339: SHIPPER_ACCOUNT_NUMBER,
340: l_transaction_id_s from
341: fte_message_partner WHERE TRANSACTION_ID = l_transaction_id_s ;
342:
343:
344: BEGIN
345: INSERT INTO

Line 550: decode (ADDRESS_TO_TABLE,'FTE_MESSAGE_PARTNER',

546: LAST_UPDATED_BY ,
547: LAST_UPDATE_DATE ,
548: LAST_UPDATE_LOGIN )
549: SELECT
550: decode (ADDRESS_TO_TABLE,'FTE_MESSAGE_PARTNER',
551: l_address_to_id,
552: (select id from fte_message_location where
553: location_to_table =( SELECT fl.location_to_table
554: FROM fte_message_location fl WHERE fl.id= fa.address_to_id

Line 686: DECODE(ATTACH_TO_TABLE,'FTE_MESSAGE_PARTNER',l_address_to_id,

682: TRANSACTION_ID
683: )
684: SELECT
685: fte_tracking_status_s.nextval ,
686: DECODE(ATTACH_TO_TABLE,'FTE_MESSAGE_PARTNER',l_address_to_id,
687: 'FTE_SHIPMENT_STATUS_DETAILS',l_content_details_id,
688: 'FTE_SHIPMENT_STATUS_EXCEPTIONS',l_content_exceptions_id,
689: l_content_pod_id),
690: ATTACH_TO_TABLE ,