eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FTE_TRACKING_WRAPPER dependencies on FTE_SHIPMENT_STATUS_DETAILS

Line 156: insert into fte_shipment_status_details(

152: -- Insert into details table
153: BEGIN
154:
155: select fte_tracking_status_s.nextval into l_content_details_id from dual;
156: insert into fte_shipment_status_details(
157: SHIPMENT_STATUS_DETAIL_ID,
158: DELIVERY_LEG_ID,
159: TRANSACTION_ID,
160: REPORT_DATE,

Line 190: FROM fte_shipment_status_details WHERE transaction_id = p_transaction_id;

186: SHIP_UNIT_SEQ,
187: SHIP_UNIT_TOTAL,
188: TRACKING_ID,
189: TRACKING_ID_TYPE
190: FROM fte_shipment_status_details WHERE transaction_id = p_transaction_id;
191:
192: EXCEPTION
193: WHEN OTHERS THEN
194: NULL; --No records in FTE_SHIPMENT_STATUS_DETAILS

Line 194: NULL; --No records in FTE_SHIPMENT_STATUS_DETAILS

190: FROM fte_shipment_status_details WHERE transaction_id = p_transaction_id;
191:
192: EXCEPTION
193: WHEN OTHERS THEN
194: NULL; --No records in FTE_SHIPMENT_STATUS_DETAILS
195: END ;
196: -- Insert into delivery proof table
197: BEGIN
198: select fte_tracking_status_s.nextval into l_content_pod_id from dual;

Line 687: 'FTE_SHIPMENT_STATUS_DETAILS',l_content_details_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 ,
691: DESCRIPTION ,

Line 994: ---- Update fte_shipment_status_header,fte_shipment_status_details and fte_delivery_proof

990: RAISE invalid_carrier;
991: END;
992:
993:
994: ---- Update fte_shipment_status_header,fte_shipment_status_details and fte_delivery_proof
995: -- Based on the tracking id type
996: IF (UPPER(l_tracking_id_type) = 'WAYBILL') THEN
997:
998:

Line 1036: UPDATE fte_shipment_status_details

1032: activity_id = WSH_DELIVERY_LEG_ACTIVITIES_S.CURRVAL
1033: WHERE transaction_id = p_transaction_id;
1034:
1035: BEGIN
1036: UPDATE fte_shipment_status_details
1037: SET delivery_leg_id = l_delivery_leg_id,
1038: creation_date = sysdate,
1039: created_by = FND_GLOBAL.USER_ID,
1040: last_update_date = sysdate,

Line 1128: update fte_shipment_status_details

1124: activity_id = WSH_DELIVERY_LEG_ACTIVITIES_S.currval
1125: where transaction_id = p_transaction_id;
1126:
1127: BEGIN
1128: update fte_shipment_status_details
1129: set delivery_leg_id = l_delivery_leg_id,
1130: creation_date = sysdate,
1131: created_by =FND_GLOBAL.USER_ID,
1132: last_update_date= sysdate,

Line 1217: update fte_shipment_status_details

1213: activity_id = WSH_DELIVERY_LEG_ACTIVITIES_S.currval
1214: where transaction_id = p_transaction_id;
1215:
1216: BEGIN
1217: update fte_shipment_status_details
1218: set delivery_leg_id = l_delivery_leg_id,
1219: creation_date = sysdate,
1220: created_by = FND_GLOBAL.USER_ID,
1221: last_update_date= sysdate,

Line 1314: update fte_shipment_status_details

1310: activity_id = WSH_DELIVERY_LEG_ACTIVITIES_S.currval
1311: where transaction_id = p_transaction_id;
1312:
1313: BEGIN
1314: update fte_shipment_status_details
1315: set delivery_leg_id = l_delivery_leg_id,
1316: creation_date = sysdate
1317: where transaction_id = p_transaction_id;
1318: EXCEPTION

Line 1396: update fte_shipment_status_details

1392: license_plate_number = l_container_name
1393: where transaction_id = p_transaction_id;
1394:
1395: BEGIN
1396: update fte_shipment_status_details
1397: set delivery_leg_id = l_delivery_leg_id,
1398: creation_date = sysdate
1399: where transaction_id = p_transaction_id;
1400: EXCEPTION

Line 1471: update fte_shipment_status_details

1467: license_plate_number = l_container_name
1468: where transaction_id = p_transaction_id;
1469:
1470: BEGIN
1471: update fte_shipment_status_details
1472: set delivery_leg_id = l_delivery_leg_id,
1473: creation_date = sysdate
1474: where transaction_id = p_transaction_id;
1475: EXCEPTION

Line 1709: fte_shipment_status_details fs

1705: SELECT
1706: fh.transaction_id
1707: FROM
1708: fte_shipment_status_headers fh,
1709: fte_shipment_status_details fs
1710: WHERE
1711: fh.transaction_id = fs.transaction_id and
1712: fh.transaction_id <> c_transaction_id and
1713: fh.delivery_leg_id = c_delivery_leg_id

Line 1763: from fte_shipment_status_details

1759:
1760: CURSOR c2 is
1761:
1762: select shipment_status_detail_id
1763: from fte_shipment_status_details
1764: where delivery_leg_id = l_delivery_leg_id
1765: and transaction_id <> p_transaction_id;
1766:
1767: BEGIN

Line 1786: from fte_shipment_status_details

1782: END;
1783:
1784: select count (*)
1785: into l_rows
1786: from fte_shipment_status_details
1787: where transaction_id = l_previous_transaction_id;
1788:
1789:
1790: delete

Line 1791: from fte_shipment_status_details

1787: where transaction_id = l_previous_transaction_id;
1788:
1789:
1790: delete
1791: from fte_shipment_status_details
1792: where transaction_id = l_previous_transaction_id;
1793:
1794:
1795: delete

Line 1813: from fte_shipment_status_details

1809: CLOSE c_get_prev;
1810:
1811: select count (*)
1812: into l_rows
1813: from fte_shipment_status_details
1814: where transaction_id = l_previous_transaction_id;
1815:
1816:
1817: DECLARE

Line 1823: from fte_shipment_status_details

1819:
1820: CURSOR c2 is
1821:
1822: select shipment_status_detail_id
1823: from fte_shipment_status_details
1824: where delivery_leg_id = l_delivery_leg_id
1825: and transaction_id = l_previous_transaction_id;
1826:
1827: BEGIN

Line 1846: from fte_shipment_status_details

1842: END;
1843:
1844:
1845: delete
1846: from fte_shipment_status_details
1847: where transaction_id = l_previous_transaction_id;
1848:
1849:
1850: