APPS.FTE_TRACKING_WRAPPER dependencies on FTE_SHIPMENT_STATUS_HEADERS

Line 108: insert into fte_shipment_status_headers(

104: (l_activity_id_s, l_delivery_leg_id, sysdate, 'TRACKING',
105: sysdate, p_carrier_id, sysdate, p_carrier_id);
106: begin
107: --Insert into Headers table
108: insert into fte_shipment_status_headers(
109: TRANSACTION_ID, delivery_leg_id, delivery_id, MESSAGE_TYPE, SHIPMENT_STATUS_ID,
110: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,
111: CARRIER_NAME, GENERATION_DATE , STATUS , TRACKING_ID, TRACKING_ID_TYPE,
112: BILL_OF_LADING , CARRIER_SERVICE_LEVEL, CONTAINER_ID , CONTAINER_SEAL ,

Line 146: from fte_shipment_status_headers where transaction_id = p_transaction_id;

142: STOP_NUMBER, SHIPPING_METHOD, SHIP_FROM_PARTNER, SHIP_TO_PARTNER,
143: CARRIER_PARTNER, BILL_TO_PARTNER, NOTIFY_PARTNER, HOLD_AT_PARTNER, RETURN_TO_PARTNER, MARK_FOR_PARTNER,
144: IMPORTER_PARTNER, EXPORTER_PARTNER, DELIVERY_DETAIL_ID, LICENSE_PLATE_NUMBER, REASON_CODE,
145: l_activity_id_s
146: from fte_shipment_status_headers where transaction_id = p_transaction_id;
147: EXCEPTION
148: WHEN OTHERS THEN
149: null;
150:

Line 972: FROM fte_shipment_status_headers

968: INTO l_tracking_id, l_tracking_id_type, l_carrier_name, l_shipment_status,
969: l_arrival_date, l_departure_date, l_estimated_arrival_date, l_estimated_departure_date,
970: l_end_loading_date, l_begin_loading_date, l_end_unloading_date, l_begin_unloading_date,
971: l_notes, l_description
972: FROM fte_shipment_status_headers
973: WHERE transaction_id = p_transaction_id;
974:
975:
976:

Line 978: FROM fte_shipment_status_headers WHERE transaction_id = p_transaction_id;

974:
975:
976:
977: SELECT carrier_name INTO l_carrier_name
978: FROM fte_shipment_status_headers WHERE transaction_id = p_transaction_id;
979:
980: -- Select the carrier id for the carrier name passed through the XML
981: -- inner exception handling
982: BEGIN

Line 1023: UPDATE fte_shipment_status_headers

1019:
1020:
1021:
1022:
1023: UPDATE fte_shipment_status_headers
1024: SET delivery_id = l_delivery_id,
1025: delivery_leg_id = l_delivery_leg_id,
1026: message_type = 'DELIVERY',
1027: creation_date = sysdate,

Line 1115: update fte_shipment_status_headers

1111: sysdate, l_carrier_id, sysdate, l_carrier_id);
1112:
1113:
1114:
1115: update fte_shipment_status_headers
1116: set delivery_id = l_delivery_id,
1117: delivery_leg_id = l_delivery_leg_id,
1118: message_type = 'DELIVERY',
1119: creation_date = sysdate,

Line 1204: update fte_shipment_status_headers

1200: sysdate, l_carrier_id, sysdate, l_carrier_id);
1201:
1202:
1203:
1204: update fte_shipment_status_headers
1205: set delivery_id = l_delivery_id,
1206: delivery_leg_id = l_delivery_leg_id,
1207: message_type = 'DELIVERY',
1208: creation_date = sysdate,

Line 1303: update fte_shipment_status_headers

1299: sysdate, l_carrier_id, sysdate, l_carrier_id);
1300:
1301:
1302:
1303: update fte_shipment_status_headers
1304: set delivery_id = l_delivery_id,
1305: delivery_leg_id = l_delivery_leg_id,
1306: delivery_detail_id = l_delivery_detail_id,
1307: license_plate_number = l_container_name,

Line 1384: update fte_shipment_status_headers

1380:
1381: end;
1382:
1383:
1384: update fte_shipment_status_headers
1385: set delivery_id = l_delivery_id,
1386: delivery_leg_id = l_delivery_leg_id,
1387: delivery_detail_id = l_delivery_detail_id,
1388: container_seal = l_seal_code,

Line 1460: update fte_shipment_status_headers

1456: raise no_license_plate;
1457: end;
1458:
1459:
1460: update fte_shipment_status_headers
1461: set delivery_id = l_delivery_id,
1462: delivery_leg_id = l_delivery_leg_id,
1463: delivery_detail_id = l_delivery_detail_id,
1464: message_type = 'CONTAINER',

Line 1701: from fte_shipment_status_headers

1697:
1698: CURSOR c1 is
1699:
1700: select delivery_leg_id, creation_date
1701: from fte_shipment_status_headers
1702: where transaction_id = p_transaction_id;
1703:
1704: Cursor c_get_prev (c_transaction_id number, c_delivery_leg_id number) is
1705: SELECT

Line 1708: fte_shipment_status_headers fh,

1704: Cursor c_get_prev (c_transaction_id number, c_delivery_leg_id number) is
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

Line 1718: fte_shipment_status_headers fh,

1714: UNION
1715: SELECT
1716: fp.transaction_id
1717: FROM
1718: fte_shipment_status_headers fh,
1719: fte_delivery_proof fp
1720: WHERE
1721: fh.transaction_id = fp.transaction_id and
1722: fh.transaction_id <> c_transaction_id and

Line 1730: from fte_shipment_status_headers

1726:
1727: begin
1728: select tracking_id, message_type
1729: into l_tracking_id, l_message_type
1730: from fte_shipment_status_headers
1731: where transaction_id = p_transaction_id;
1732:
1733: exception
1734: when others then

Line 1804: from fte_shipment_status_headers

1800: elsif (upper(l_message_type) = 'CONTAINER')
1801: then
1802: select tracking_id, message_type
1803: into l_tracking_id, l_message_type
1804: from fte_shipment_status_headers
1805: where transaction_id = p_transaction_id;
1806:
1807: OPEN c_get_prev(p_transaction_id, l_delivery_leg_id);
1808: FETCH c_get_prev into l_previous_transaction_id;