APPS.FTE_TRACKING_WRAPPER dependencies on FTE_SHIPMENT_STATUS_EXCEPTIONS

Line 613: INSERT INTO FTE_SHIPMENT_STATUS_EXCEPTIONS

609:
610: END ;
611:
612: BEGIN
613: INSERT INTO FTE_SHIPMENT_STATUS_EXCEPTIONS
614: (
615: DETAIL_ID ,
616: EXCEPTION_ID ,
617: EXCEPTION_DATE ,

Line 643: FROM FTE_SHIPMENT_STATUS_EXCEPTIONS

639: LAST_UPDATE_LOGIN ,
640: LADING_QUANTITY ,
641: LADING_QUANTITY_UOM ,
642: l_transaction_id_s
643: FROM FTE_SHIPMENT_STATUS_EXCEPTIONS
644: WHERE TRANSACTION_ID = P_TRANSACTION_ID ;
645:
646: select fte_tracking_status_s.currval into l_content_exceptions_id from dual;
647: EXCEPTION

Line 688: 'FTE_SHIPMENT_STATUS_EXCEPTIONS',l_content_exceptions_id,

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 ,
691: DESCRIPTION ,
692: FILETYPE ,

Line 1774: delete from fte_shipment_status_exceptions

1770: FETCH c2 into
1771: l_shipment_detail_id;
1772:
1773:
1774: delete from fte_shipment_status_exceptions
1775: where detail_id = l_shipment_detail_id;
1776:
1777:
1778: EXIT when c2%NOTFOUND;

Line 1834: delete from fte_shipment_status_exceptions

1830: FETCH c2 into
1831: l_shipment_detail_id;
1832:
1833:
1834: delete from fte_shipment_status_exceptions
1835: where detail_id = l_shipment_detail_id;
1836:
1837:
1838: EXIT when c2%NOTFOUND;