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 FND_GLOBAL

Line 1028: created_by = FND_GLOBAL.USER_ID,

1024: SET delivery_id = l_delivery_id,
1025: delivery_leg_id = l_delivery_leg_id,
1026: message_type = 'DELIVERY',
1027: creation_date = sysdate,
1028: created_by = FND_GLOBAL.USER_ID,
1029: last_update_date= sysdate,
1030: last_updated_by =FND_GLOBAL.USER_ID,
1031: last_update_login=FND_GLOBAL.USER_ID,
1032: activity_id = WSH_DELIVERY_LEG_ACTIVITIES_S.CURRVAL

Line 1030: last_updated_by =FND_GLOBAL.USER_ID,

1026: message_type = 'DELIVERY',
1027: creation_date = sysdate,
1028: created_by = FND_GLOBAL.USER_ID,
1029: last_update_date= sysdate,
1030: last_updated_by =FND_GLOBAL.USER_ID,
1031: last_update_login=FND_GLOBAL.USER_ID,
1032: activity_id = WSH_DELIVERY_LEG_ACTIVITIES_S.CURRVAL
1033: WHERE transaction_id = p_transaction_id;
1034:

Line 1031: last_update_login=FND_GLOBAL.USER_ID,

1027: creation_date = sysdate,
1028: created_by = FND_GLOBAL.USER_ID,
1029: last_update_date= sysdate,
1030: last_updated_by =FND_GLOBAL.USER_ID,
1031: last_update_login=FND_GLOBAL.USER_ID,
1032: activity_id = WSH_DELIVERY_LEG_ACTIVITIES_S.CURRVAL
1033: WHERE transaction_id = p_transaction_id;
1034:
1035: BEGIN

Line 1039: created_by = FND_GLOBAL.USER_ID,

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,
1041: last_updated_by = FND_GLOBAL.USER_ID,
1042: last_update_login=FND_GLOBAL.USER_ID
1043: WHERE transaction_id = p_transaction_id;

Line 1041: last_updated_by = FND_GLOBAL.USER_ID,

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,
1041: last_updated_by = FND_GLOBAL.USER_ID,
1042: last_update_login=FND_GLOBAL.USER_ID
1043: WHERE transaction_id = p_transaction_id;
1044: EXCEPTION
1045: WHEN OTHERS THEN

Line 1042: last_update_login=FND_GLOBAL.USER_ID

1038: creation_date = sysdate,
1039: created_by = FND_GLOBAL.USER_ID,
1040: last_update_date = sysdate,
1041: last_updated_by = FND_GLOBAL.USER_ID,
1042: last_update_login=FND_GLOBAL.USER_ID
1043: WHERE transaction_id = p_transaction_id;
1044: EXCEPTION
1045: WHEN OTHERS THEN
1046: NULL; --No records in FTE_DELIVERY_PROOF table

Line 1061: created_by =FND_GLOBAL.USER_ID,

1057:
1058: -- Update the POD information
1059: UPDATE fte_delivery_proof
1060: SET creation_date = sysdate,
1061: created_by =FND_GLOBAL.USER_ID,
1062: last_update_date=sysdate,
1063: last_updated_by =FND_GLOBAL.USER_ID,
1064: last_update_login=FND_GLOBAL.USER_ID,
1065: location =l_address

Line 1063: last_updated_by =FND_GLOBAL.USER_ID,

1059: UPDATE fte_delivery_proof
1060: SET creation_date = sysdate,
1061: created_by =FND_GLOBAL.USER_ID,
1062: last_update_date=sysdate,
1063: last_updated_by =FND_GLOBAL.USER_ID,
1064: last_update_login=FND_GLOBAL.USER_ID,
1065: location =l_address
1066: WHERE transaction_id= p_transaction_id;
1067:

Line 1064: last_update_login=FND_GLOBAL.USER_ID,

1060: SET creation_date = sysdate,
1061: created_by =FND_GLOBAL.USER_ID,
1062: last_update_date=sysdate,
1063: last_updated_by =FND_GLOBAL.USER_ID,
1064: last_update_login=FND_GLOBAL.USER_ID,
1065: location =l_address
1066: WHERE transaction_id= p_transaction_id;
1067:
1068: EXCEPTION

Line 1120: created_by =FND_GLOBAL.USER_ID,

1116: set delivery_id = l_delivery_id,
1117: delivery_leg_id = l_delivery_leg_id,
1118: message_type = 'DELIVERY',
1119: creation_date = sysdate,
1120: created_by =FND_GLOBAL.USER_ID,
1121: last_update_date=sysdate,
1122: last_updated_by = FND_GLOBAL.USER_ID,
1123: last_update_login=FND_GLOBAL.USER_ID,
1124: activity_id = WSH_DELIVERY_LEG_ACTIVITIES_S.currval

Line 1122: last_updated_by = FND_GLOBAL.USER_ID,

1118: message_type = 'DELIVERY',
1119: creation_date = sysdate,
1120: created_by =FND_GLOBAL.USER_ID,
1121: last_update_date=sysdate,
1122: last_updated_by = FND_GLOBAL.USER_ID,
1123: last_update_login=FND_GLOBAL.USER_ID,
1124: activity_id = WSH_DELIVERY_LEG_ACTIVITIES_S.currval
1125: where transaction_id = p_transaction_id;
1126:

Line 1123: last_update_login=FND_GLOBAL.USER_ID,

1119: creation_date = sysdate,
1120: created_by =FND_GLOBAL.USER_ID,
1121: last_update_date=sysdate,
1122: last_updated_by = FND_GLOBAL.USER_ID,
1123: last_update_login=FND_GLOBAL.USER_ID,
1124: activity_id = WSH_DELIVERY_LEG_ACTIVITIES_S.currval
1125: where transaction_id = p_transaction_id;
1126:
1127: BEGIN

Line 1131: created_by =FND_GLOBAL.USER_ID,

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,
1133: last_updated_by = FND_GLOBAL.USER_ID,
1134: last_update_login=FND_GLOBAL.USER_ID
1135: where transaction_id = p_transaction_id;

Line 1133: last_updated_by = FND_GLOBAL.USER_ID,

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,
1133: last_updated_by = FND_GLOBAL.USER_ID,
1134: last_update_login=FND_GLOBAL.USER_ID
1135: where transaction_id = p_transaction_id;
1136: EXCEPTION
1137: WHEN OTHERS THEN

Line 1134: last_update_login=FND_GLOBAL.USER_ID

1130: creation_date = sysdate,
1131: created_by =FND_GLOBAL.USER_ID,
1132: last_update_date= sysdate,
1133: last_updated_by = FND_GLOBAL.USER_ID,
1134: last_update_login=FND_GLOBAL.USER_ID
1135: where transaction_id = p_transaction_id;
1136: EXCEPTION
1137: WHEN OTHERS THEN
1138: NULL; --No records in FTE_DELIVERY_PROOF table

Line 1155: created_by =FND_GLOBAL.USER_ID,

1151:
1152: -- Update the POD information
1153: update fte_delivery_proof
1154: set creation_date=sysdate,
1155: created_by =FND_GLOBAL.USER_ID,
1156: last_update_date=sysdate,
1157: last_updated_by=FND_GLOBAL.USER_ID,
1158: last_update_login=FND_GLOBAL.USER_ID,
1159: location = l_address

Line 1157: last_updated_by=FND_GLOBAL.USER_ID,

1153: update fte_delivery_proof
1154: set creation_date=sysdate,
1155: created_by =FND_GLOBAL.USER_ID,
1156: last_update_date=sysdate,
1157: last_updated_by=FND_GLOBAL.USER_ID,
1158: last_update_login=FND_GLOBAL.USER_ID,
1159: location = l_address
1160: where transaction_id= p_transaction_id;
1161: EXCEPTION

Line 1158: last_update_login=FND_GLOBAL.USER_ID,

1154: set creation_date=sysdate,
1155: created_by =FND_GLOBAL.USER_ID,
1156: last_update_date=sysdate,
1157: last_updated_by=FND_GLOBAL.USER_ID,
1158: last_update_login=FND_GLOBAL.USER_ID,
1159: location = l_address
1160: where transaction_id= p_transaction_id;
1161: EXCEPTION
1162: WHEN OTHERS THEN

Line 1209: created_by = FND_GLOBAL.USER_ID,

1205: set delivery_id = l_delivery_id,
1206: delivery_leg_id = l_delivery_leg_id,
1207: message_type = 'DELIVERY',
1208: creation_date = sysdate,
1209: created_by = FND_GLOBAL.USER_ID,
1210: last_update_date= sysdate,
1211: last_updated_by = FND_GLOBAL.USER_ID,
1212: last_update_login=FND_GLOBAL.USER_ID,
1213: activity_id = WSH_DELIVERY_LEG_ACTIVITIES_S.currval

Line 1211: last_updated_by = FND_GLOBAL.USER_ID,

1207: message_type = 'DELIVERY',
1208: creation_date = sysdate,
1209: created_by = FND_GLOBAL.USER_ID,
1210: last_update_date= sysdate,
1211: last_updated_by = FND_GLOBAL.USER_ID,
1212: last_update_login=FND_GLOBAL.USER_ID,
1213: activity_id = WSH_DELIVERY_LEG_ACTIVITIES_S.currval
1214: where transaction_id = p_transaction_id;
1215:

Line 1212: last_update_login=FND_GLOBAL.USER_ID,

1208: creation_date = sysdate,
1209: created_by = FND_GLOBAL.USER_ID,
1210: last_update_date= sysdate,
1211: last_updated_by = FND_GLOBAL.USER_ID,
1212: last_update_login=FND_GLOBAL.USER_ID,
1213: activity_id = WSH_DELIVERY_LEG_ACTIVITIES_S.currval
1214: where transaction_id = p_transaction_id;
1215:
1216: BEGIN

Line 1220: created_by = FND_GLOBAL.USER_ID,

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,
1222: last_updated_by = FND_GLOBAL.USER_ID,
1223: last_update_login=FND_GLOBAL.USER_ID
1224: where transaction_id = p_transaction_id;

Line 1222: last_updated_by = FND_GLOBAL.USER_ID,

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,
1222: last_updated_by = FND_GLOBAL.USER_ID,
1223: last_update_login=FND_GLOBAL.USER_ID
1224: where transaction_id = p_transaction_id;
1225: EXCEPTION
1226: WHEN OTHERS THEN

Line 1223: last_update_login=FND_GLOBAL.USER_ID

1219: creation_date = sysdate,
1220: created_by = FND_GLOBAL.USER_ID,
1221: last_update_date= sysdate,
1222: last_updated_by = FND_GLOBAL.USER_ID,
1223: last_update_login=FND_GLOBAL.USER_ID
1224: where transaction_id = p_transaction_id;
1225: EXCEPTION
1226: WHEN OTHERS THEN
1227: NULL; --No records in FTE_DELIVERY_PROOF table

Line 1245: created_by = FND_GLOBAL.USER_ID,

1241: -- Update the POD information
1242:
1243: update fte_delivery_proof
1244: set creation_date = sysdate,
1245: created_by = FND_GLOBAL.USER_ID,
1246: last_update_date=sysdate,
1247: last_updated_by=FND_GLOBAL.USER_ID,
1248: last_update_login=FND_GLOBAL.USER_ID,
1249: location = l_address

Line 1247: last_updated_by=FND_GLOBAL.USER_ID,

1243: update fte_delivery_proof
1244: set creation_date = sysdate,
1245: created_by = FND_GLOBAL.USER_ID,
1246: last_update_date=sysdate,
1247: last_updated_by=FND_GLOBAL.USER_ID,
1248: last_update_login=FND_GLOBAL.USER_ID,
1249: location = l_address
1250: where transaction_id= p_transaction_id;
1251: EXCEPTION

Line 1248: last_update_login=FND_GLOBAL.USER_ID,

1244: set creation_date = sysdate,
1245: created_by = FND_GLOBAL.USER_ID,
1246: last_update_date=sysdate,
1247: last_updated_by=FND_GLOBAL.USER_ID,
1248: last_update_login=FND_GLOBAL.USER_ID,
1249: location = l_address
1250: where transaction_id= p_transaction_id;
1251: EXCEPTION
1252: WHEN OTHERS THEN

Line 1495: created_by = FND_GLOBAL.USER_ID,

1491: -- Update the POD information
1492:
1493: update fte_delivery_proof
1494: set creation_date = sysdate,
1495: created_by = FND_GLOBAL.USER_ID,
1496: last_update_date=sysdate,
1497: last_updated_by=FND_GLOBAL.USER_ID,
1498: last_update_login=FND_GLOBAL.USER_ID,
1499: location = l_address

Line 1497: last_updated_by=FND_GLOBAL.USER_ID,

1493: update fte_delivery_proof
1494: set creation_date = sysdate,
1495: created_by = FND_GLOBAL.USER_ID,
1496: last_update_date=sysdate,
1497: last_updated_by=FND_GLOBAL.USER_ID,
1498: last_update_login=FND_GLOBAL.USER_ID,
1499: location = l_address
1500: where transaction_id= p_transaction_id;
1501: EXCEPTION

Line 1498: last_update_login=FND_GLOBAL.USER_ID,

1494: set creation_date = sysdate,
1495: created_by = FND_GLOBAL.USER_ID,
1496: last_update_date=sysdate,
1497: last_updated_by=FND_GLOBAL.USER_ID,
1498: last_update_login=FND_GLOBAL.USER_ID,
1499: location = l_address
1500: where transaction_id= p_transaction_id;
1501: EXCEPTION
1502: WHEN OTHERS THEN