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.AHL_FMP_MR_REVISION_PVT dependencies on FND_GLOBAL

Line 861: X_CREATED_BY =>fnd_global.user_id,

857: -- defaulting to Yes for these attributes when new revision is created
858: X_COPY_INIT_ACCOMPL_FLAG =>'Y',
859: X_COPY_DEFERRALS_FLAG =>'Y',
860: X_CREATION_DATE =>sysdate,
861: X_CREATED_BY =>fnd_global.user_id,
862: X_LAST_UPDATE_DATE =>sysdate,
863: X_LAST_UPDATED_BY =>fnd_global.user_id,
864: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
865: end loop;

Line 863: X_LAST_UPDATED_BY =>fnd_global.user_id,

859: X_COPY_DEFERRALS_FLAG =>'Y',
860: X_CREATION_DATE =>sysdate,
861: X_CREATED_BY =>fnd_global.user_id,
862: X_LAST_UPDATE_DATE =>sysdate,
863: X_LAST_UPDATED_BY =>fnd_global.user_id,
864: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
865: end loop;
866:
867:

Line 864: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);

860: X_CREATION_DATE =>sysdate,
861: X_CREATED_BY =>fnd_global.user_id,
862: X_LAST_UPDATE_DATE =>sysdate,
863: X_LAST_UPDATED_BY =>fnd_global.user_id,
864: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
865: end loop;
866:
867:
868: for l_association_rec in CurGetDocTitledet

Line 909: X_CREATED_BY =>fnd_global.user_id,

905: X_FIGURE =>l_association_rec.figure,
906: X_PAGE =>l_association_rec.page,
907: X_NOTE =>l_association_rec.note,
908: X_CREATION_DATE =>sysdate,
909: X_CREATED_BY =>fnd_global.user_id,
910: X_LAST_UPDATE_DATE =>sysdate,
911: X_LAST_UPDATED_BY =>fnd_global.user_id,
912: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
913:

Line 911: X_LAST_UPDATED_BY =>fnd_global.user_id,

907: X_NOTE =>l_association_rec.note,
908: X_CREATION_DATE =>sysdate,
909: X_CREATED_BY =>fnd_global.user_id,
910: X_LAST_UPDATE_DATE =>sysdate,
911: X_LAST_UPDATED_BY =>fnd_global.user_id,
912: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
913:
914: end loop;
915:

Line 912: X_LAST_UPDATE_LOGIN => fnd_global.login_id);

908: X_CREATION_DATE =>sysdate,
909: X_CREATED_BY =>fnd_global.user_id,
910: X_LAST_UPDATE_DATE =>sysdate,
911: X_LAST_UPDATED_BY =>fnd_global.user_id,
912: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
913:
914: end loop;
915:
916: for l_mr_route_rec in CurGetRoutedet

Line 947: X_CREATED_BY =>fnd_global.user_id,

943: X_ATTRIBUTE13 =>l_mr_route_Rec.ATTRIBUTE14,
944: X_ATTRIBUTE14 =>l_mr_route_Rec.ATTRIBUTE15,
945: X_ATTRIBUTE15 =>l_mr_route_Rec.ATTRIBUTE15,
946: X_CREATION_DATE =>sysdate,
947: X_CREATED_BY =>fnd_global.user_id,
948: X_LAST_UPDATE_DATE =>sysdate,
949: X_LAST_UPDATED_BY =>fnd_global.user_id,
950: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
951: L_MR_ROUTE_INDEX:=L_MR_ROUTE_INDEX+1;

Line 949: X_LAST_UPDATED_BY =>fnd_global.user_id,

945: X_ATTRIBUTE15 =>l_mr_route_Rec.ATTRIBUTE15,
946: X_CREATION_DATE =>sysdate,
947: X_CREATED_BY =>fnd_global.user_id,
948: X_LAST_UPDATE_DATE =>sysdate,
949: X_LAST_UPDATED_BY =>fnd_global.user_id,
950: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
951: L_MR_ROUTE_INDEX:=L_MR_ROUTE_INDEX+1;
952: l_temp_mr_route_tbl(L_MR_ROUTE_INDEX).OLD_MR_ROUTE_ID:=l_old_mr_route_id;
953: l_temp_mr_route_tbl(L_MR_ROUTE_INDEX).NEW_MR_ROUTE_ID:=l_new_mr_ROUTE_ID;

Line 950: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);

946: X_CREATION_DATE =>sysdate,
947: X_CREATED_BY =>fnd_global.user_id,
948: X_LAST_UPDATE_DATE =>sysdate,
949: X_LAST_UPDATED_BY =>fnd_global.user_id,
950: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
951: L_MR_ROUTE_INDEX:=L_MR_ROUTE_INDEX+1;
952: l_temp_mr_route_tbl(L_MR_ROUTE_INDEX).OLD_MR_ROUTE_ID:=l_old_mr_route_id;
953: l_temp_mr_route_tbl(L_MR_ROUTE_INDEX).NEW_MR_ROUTE_ID:=l_new_mr_ROUTE_ID;
954: End loop;

Line 1003: X_CREATED_BY =>fnd_global.user_id,

999: X_ATTRIBUTE13 =>l_mr_route_seq_rec.ATTRIBUTE13,
1000: X_ATTRIBUTE14 =>l_mr_route_seq_rec.ATTRIBUTE14,
1001: X_ATTRIBUTE15 =>l_mr_route_seq_rec.ATTRIBUTE15,
1002: X_CREATION_DATE =>sysdate,
1003: X_CREATED_BY =>fnd_global.user_id,
1004: X_LAST_UPDATE_DATE =>sysdate,
1005: X_LAST_UPDATED_BY =>fnd_global.user_id,
1006: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
1007: end loop;

Line 1005: X_LAST_UPDATED_BY =>fnd_global.user_id,

1001: X_ATTRIBUTE15 =>l_mr_route_seq_rec.ATTRIBUTE15,
1002: X_CREATION_DATE =>sysdate,
1003: X_CREATED_BY =>fnd_global.user_id,
1004: X_LAST_UPDATE_DATE =>sysdate,
1005: X_LAST_UPDATED_BY =>fnd_global.user_id,
1006: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
1007: end loop;
1008: CLOSE CurGetRouteSeqDet;
1009:

Line 1006: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);

1002: X_CREATION_DATE =>sysdate,
1003: X_CREATED_BY =>fnd_global.user_id,
1004: X_LAST_UPDATE_DATE =>sysdate,
1005: X_LAST_UPDATED_BY =>fnd_global.user_id,
1006: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
1007: end loop;
1008: CLOSE CurGetRouteSeqDet;
1009:
1010: END LOOP;

Line 1055: fnd_global.user_id,

1051: (
1052: AHL_MR_EFFECTIVITIES_S.NEXTVAL,
1053: 1,
1054: SYSDATE,
1055: fnd_global.user_id,
1056: SYSDATE,
1057: fnd_global.user_id,
1058: fnd_global.user_id,
1059: x_new_mr_header_id,

Line 1057: fnd_global.user_id,

1053: 1,
1054: SYSDATE,
1055: fnd_global.user_id,
1056: SYSDATE,
1057: fnd_global.user_id,
1058: fnd_global.user_id,
1059: x_new_mr_header_id,
1060: l_mr_eff_rec.NAME,
1061: l_mr_eff_rec.THRESHOLD_DATE,

Line 1058: fnd_global.user_id,

1054: SYSDATE,
1055: fnd_global.user_id,
1056: SYSDATE,
1057: fnd_global.user_id,
1058: fnd_global.user_id,
1059: x_new_mr_header_id,
1060: l_mr_eff_rec.NAME,
1061: l_mr_eff_rec.THRESHOLD_DATE,
1062: l_mr_eff_rec.INVENTORY_ITEM_ID,

Line 1138: fnd_global.user_id,

1134: (
1135: AHL_MR_INTERVALS_S.NEXTVAL,
1136: l_interval_rec.OBJECT_VERSION_NUMBER,
1137: sysdate,
1138: fnd_global.user_id,
1139: sysdate,
1140: fnd_global.user_id,
1141: fnd_global.user_id,
1142: l_new_mr_effectivity_id,

Line 1140: fnd_global.user_id,

1136: l_interval_rec.OBJECT_VERSION_NUMBER,
1137: sysdate,
1138: fnd_global.user_id,
1139: sysdate,
1140: fnd_global.user_id,
1141: fnd_global.user_id,
1142: l_new_mr_effectivity_id,
1143: l_interval_rec.COUNTER_ID,
1144: l_interval_rec.INTERVAL_VALUE,

Line 1141: fnd_global.user_id,

1137: sysdate,
1138: fnd_global.user_id,
1139: sysdate,
1140: fnd_global.user_id,
1141: fnd_global.user_id,
1142: l_new_mr_effectivity_id,
1143: l_interval_rec.COUNTER_ID,
1144: l_interval_rec.INTERVAL_VALUE,
1145: l_interval_rec.EARLIEST_DUE_VALUE,

Line 1233: fnd_global.user_id,

1229: l_mr_effect_dtls_rec.MANUFACTURE_DATE_FROM,
1230: l_mr_effect_dtls_rec.MANUFACTURE_DATE_TO,
1231: 1,
1232: SYSDATE,
1233: fnd_global.user_id,
1234: SYSDATE,
1235: fnd_global.user_id,
1236: fnd_global.user_id,
1237: l_mr_effect_dtls_rec.ATTRIBUTE_CATEGORY,

Line 1235: fnd_global.user_id,

1231: 1,
1232: SYSDATE,
1233: fnd_global.user_id,
1234: SYSDATE,
1235: fnd_global.user_id,
1236: fnd_global.user_id,
1237: l_mr_effect_dtls_rec.ATTRIBUTE_CATEGORY,
1238: l_mr_effect_dtls_rec.ATTRIBUTE1,
1239: l_mr_effect_dtls_rec.ATTRIBUTE2,

Line 1236: fnd_global.user_id,

1232: SYSDATE,
1233: fnd_global.user_id,
1234: SYSDATE,
1235: fnd_global.user_id,
1236: fnd_global.user_id,
1237: l_mr_effect_dtls_rec.ATTRIBUTE_CATEGORY,
1238: l_mr_effect_dtls_rec.ATTRIBUTE1,
1239: l_mr_effect_dtls_rec.ATTRIBUTE2,
1240: l_mr_effect_dtls_rec.ATTRIBUTE3,

Line 1312: fnd_global.user_id,

1308: l_mr_effect_ext_dtls_rec.CSI_EXT_ATTRIBUTE_CODE,
1309: l_mr_effect_ext_dtls_rec.CSI_EXT_ATTRIBUTE_VALUE,
1310: 1,
1311: SYSDATE,
1312: fnd_global.user_id,
1313: SYSDATE,
1314: fnd_global.user_id,
1315: fnd_global.user_id,
1316: l_mr_effect_ext_dtls_rec.ATTRIBUTE_CATEGORY,

Line 1314: fnd_global.user_id,

1310: 1,
1311: SYSDATE,
1312: fnd_global.user_id,
1313: SYSDATE,
1314: fnd_global.user_id,
1315: fnd_global.user_id,
1316: l_mr_effect_ext_dtls_rec.ATTRIBUTE_CATEGORY,
1317: l_mr_effect_ext_dtls_rec.ATTRIBUTE1,
1318: l_mr_effect_ext_dtls_rec.ATTRIBUTE2,

Line 1315: fnd_global.user_id,

1311: SYSDATE,
1312: fnd_global.user_id,
1313: SYSDATE,
1314: fnd_global.user_id,
1315: fnd_global.user_id,
1316: l_mr_effect_ext_dtls_rec.ATTRIBUTE_CATEGORY,
1317: l_mr_effect_ext_dtls_rec.ATTRIBUTE1,
1318: l_mr_effect_ext_dtls_rec.ATTRIBUTE2,
1319: l_mr_effect_ext_dtls_rec.ATTRIBUTE3,

Line 1386: fnd_global.user_id,

1382: values(
1383: AHL_MR_RELATIONSHIPS_S.NEXTVAL,
1384: 1,
1385: SYSDATE,
1386: fnd_global.user_id,
1387: SYSDATE,
1388: fnd_global.user_id,
1389: fnd_global.user_id,
1390: l_rel_Rec.MR_HEADER_ID,

Line 1388: fnd_global.user_id,

1384: 1,
1385: SYSDATE,
1386: fnd_global.user_id,
1387: SYSDATE,
1388: fnd_global.user_id,
1389: fnd_global.user_id,
1390: l_rel_Rec.MR_HEADER_ID,
1391: l_rel_Rec.RELATED_MR_HEADER_ID,
1392: l_mr_relation_Rec.RELATIONSHIP_CODE,

Line 1389: fnd_global.user_id,

1385: SYSDATE,
1386: fnd_global.user_id,
1387: SYSDATE,
1388: fnd_global.user_id,
1389: fnd_global.user_id,
1390: l_rel_Rec.MR_HEADER_ID,
1391: l_rel_Rec.RELATED_MR_HEADER_ID,
1392: l_mr_relation_Rec.RELATIONSHIP_CODE,
1393: l_mr_relation_Rec.ATTRIBUTE_CATEGORY,

Line 1448: fnd_global.user_id,

1444: (
1445: AHL_MR_VISIT_TYPES_S.NEXTVAL,
1446: 1,
1447: SYSDATE,
1448: fnd_global.user_id,
1449: SYSDATE,
1450: fnd_global.user_id,
1451: fnd_global.user_id,
1452: x_new_MR_HEADER_ID,

Line 1450: fnd_global.user_id,

1446: 1,
1447: SYSDATE,
1448: fnd_global.user_id,
1449: SYSDATE,
1450: fnd_global.user_id,
1451: fnd_global.user_id,
1452: x_new_MR_HEADER_ID,
1453: l_mrvisttype_rec.SECURITY_GROUP_ID,
1454: l_mrvisttype_rec.ATTRIBUTE_CATEGORY,

Line 1451: fnd_global.user_id,

1447: SYSDATE,
1448: fnd_global.user_id,
1449: SYSDATE,
1450: fnd_global.user_id,
1451: fnd_global.user_id,
1452: x_new_MR_HEADER_ID,
1453: l_mrvisttype_rec.SECURITY_GROUP_ID,
1454: l_mrvisttype_rec.ATTRIBUTE_CATEGORY,
1455: l_mrvisttype_rec.ATTRIBUTE1,

Line 1544: fnd_global.user_id,

1540: values(
1541: l_mr_loop_chain_rel_id,
1542: 1,
1543: SYSDATE,
1544: fnd_global.user_id,
1545: SYSDATE,
1546: fnd_global.user_id,
1547: fnd_global.user_id,
1548: l_start_loop_chain_rel_rec.MR_HEADER_ID,

Line 1546: fnd_global.user_id,

1542: 1,
1543: SYSDATE,
1544: fnd_global.user_id,
1545: SYSDATE,
1546: fnd_global.user_id,
1547: fnd_global.user_id,
1548: l_start_loop_chain_rel_rec.MR_HEADER_ID,
1549: l_start_mr_rel_id,
1550: l_start_loop_chain_rel_rec.SEQUENCE_NUMBER,

Line 1547: fnd_global.user_id,

1543: SYSDATE,
1544: fnd_global.user_id,
1545: SYSDATE,
1546: fnd_global.user_id,
1547: fnd_global.user_id,
1548: l_start_loop_chain_rel_rec.MR_HEADER_ID,
1549: l_start_mr_rel_id,
1550: l_start_loop_chain_rel_rec.SEQUENCE_NUMBER,
1551: l_start_loop_chain_rel_rec.RELATIONSHIP_CODE,

Line 1605: fnd_global.user_id,

1601: values(
1602: AHL_MR_LOOP_CHAIN_RELNS_S.NEXTVAL,
1603: 1,
1604: SYSDATE,
1605: fnd_global.user_id,
1606: SYSDATE,
1607: fnd_global.user_id,
1608: fnd_global.user_id,
1609: l_loop_chain_rel_rec.MR_HEADER_ID,

Line 1607: fnd_global.user_id,

1603: 1,
1604: SYSDATE,
1605: fnd_global.user_id,
1606: SYSDATE,
1607: fnd_global.user_id,
1608: fnd_global.user_id,
1609: l_loop_chain_rel_rec.MR_HEADER_ID,
1610: l_loop_chain_rel_rec.start_mr_relationship_id,
1611: l_loop_chain_rel_rec.SEQUENCE_NUMBER,

Line 1608: fnd_global.user_id,

1604: SYSDATE,
1605: fnd_global.user_id,
1606: SYSDATE,
1607: fnd_global.user_id,
1608: fnd_global.user_id,
1609: l_loop_chain_rel_rec.MR_HEADER_ID,
1610: l_loop_chain_rel_rec.start_mr_relationship_id,
1611: l_loop_chain_rel_rec.SEQUENCE_NUMBER,
1612: l_loop_chain_rel_rec.RELATIONSHIP_CODE,

Line 2037: P_REQUESTER_USERID =>fnd_global.user_id,

2033: P_ORIG_STATUS_CODE =>'ACTIVE',
2034: -- P_NEW_STATUS_CODE =>'APPROVED',
2035: P_NEW_STATUS_CODE => l_approved_status_code,
2036: P_REJECT_STATUS_CODE =>'REJECTED',
2037: P_REQUESTER_USERID =>fnd_global.user_id,
2038: P_NOTES_FROM_REQUESTER =>'',
2039: P_WORKFLOWPROCESS =>'AHL_GEN_APPROVAL',
2040: P_ITEM_TYPE =>'AHLGAPP',
2041: p_application_usg_code =>G_APPLN_USAGE