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

Line 918: FND_GLOBAL.login_id,

914: NVL(l_ip_category_id_tbl(i), -2),
915: NVL(l_item_id_tbl(i), -2),
916: PO_PDOI_PARAMS.g_request.org_id,
917: l_lead_time_tbl(i), -- Bug7039409: LEAD_TIME
918: FND_GLOBAL.login_id,
919: FND_GLOBAL.user_id,
920: sysdate,
921: FND_GLOBAL.user_id,
922: sysdate,

Line 919: FND_GLOBAL.user_id,

915: NVL(l_item_id_tbl(i), -2),
916: PO_PDOI_PARAMS.g_request.org_id,
917: l_lead_time_tbl(i), -- Bug7039409: LEAD_TIME
918: FND_GLOBAL.login_id,
919: FND_GLOBAL.user_id,
920: sysdate,
921: FND_GLOBAL.user_id,
922: sysdate,
923: FND_GLOBAL.conc_request_id,

Line 921: FND_GLOBAL.user_id,

917: l_lead_time_tbl(i), -- Bug7039409: LEAD_TIME
918: FND_GLOBAL.login_id,
919: FND_GLOBAL.user_id,
920: sysdate,
921: FND_GLOBAL.user_id,
922: sysdate,
923: FND_GLOBAL.conc_request_id,
924: FND_GLOBAL.prog_appl_id,
925: FND_GLOBAL.conc_program_id,

Line 923: FND_GLOBAL.conc_request_id,

919: FND_GLOBAL.user_id,
920: sysdate,
921: FND_GLOBAL.user_id,
922: sysdate,
923: FND_GLOBAL.conc_request_id,
924: FND_GLOBAL.prog_appl_id,
925: FND_GLOBAL.conc_program_id,
926: sysdate
927: );

Line 924: FND_GLOBAL.prog_appl_id,

920: sysdate,
921: FND_GLOBAL.user_id,
922: sysdate,
923: FND_GLOBAL.conc_request_id,
924: FND_GLOBAL.prog_appl_id,
925: FND_GLOBAL.conc_program_id,
926: sysdate
927: );
928:

Line 925: FND_GLOBAL.conc_program_id,

921: FND_GLOBAL.user_id,
922: sysdate,
923: FND_GLOBAL.conc_request_id,
924: FND_GLOBAL.prog_appl_id,
925: FND_GLOBAL.conc_program_id,
926: sysdate
927: );
928:
929: d_position := 20;

Line 967: FND_GLOBAL.login_id,

963: NVL(l_item_id_tbl(i), -2),
964: PO_PDOI_PARAMS.g_request.org_id,
965: l_created_lang_tbl(i),
966: l_item_desc_tbl(i),
967: FND_GLOBAL.login_id,
968: FND_GLOBAL.user_id,
969: sysdate,
970: FND_GLOBAL.user_id,
971: sysdate,

Line 968: FND_GLOBAL.user_id,

964: PO_PDOI_PARAMS.g_request.org_id,
965: l_created_lang_tbl(i),
966: l_item_desc_tbl(i),
967: FND_GLOBAL.login_id,
968: FND_GLOBAL.user_id,
969: sysdate,
970: FND_GLOBAL.user_id,
971: sysdate,
972: FND_GLOBAL.conc_request_id,

Line 970: FND_GLOBAL.user_id,

966: l_item_desc_tbl(i),
967: FND_GLOBAL.login_id,
968: FND_GLOBAL.user_id,
969: sysdate,
970: FND_GLOBAL.user_id,
971: sysdate,
972: FND_GLOBAL.conc_request_id,
973: FND_GLOBAL.prog_appl_id,
974: FND_GLOBAL.conc_program_id,

Line 972: FND_GLOBAL.conc_request_id,

968: FND_GLOBAL.user_id,
969: sysdate,
970: FND_GLOBAL.user_id,
971: sysdate,
972: FND_GLOBAL.conc_request_id,
973: FND_GLOBAL.prog_appl_id,
974: FND_GLOBAL.conc_program_id,
975: sysdate
976: );

Line 973: FND_GLOBAL.prog_appl_id,

969: sysdate,
970: FND_GLOBAL.user_id,
971: sysdate,
972: FND_GLOBAL.conc_request_id,
973: FND_GLOBAL.prog_appl_id,
974: FND_GLOBAL.conc_program_id,
975: sysdate
976: );
977:

Line 974: FND_GLOBAL.conc_program_id,

970: FND_GLOBAL.user_id,
971: sysdate,
972: FND_GLOBAL.conc_request_id,
973: FND_GLOBAL.prog_appl_id,
974: FND_GLOBAL.conc_program_id,
975: sysdate
976: );
977:
978: d_position := 30;

Line 993: AND pavd.request_id = fnd_global.conc_request_id

989: FROM mtl_mfg_part_numbers_all_v mmpn2,
990: po_attribute_values_draft pavd
991: WHERE pavd.inventory_item_id = mmpn2.inventory_item_id
992: AND mmpn2.organization_id = l_master_org_id
993: AND pavd.request_id = fnd_global.conc_request_id
994: AND pavd.program_application_id = fnd_global.prog_appl_id
995: AND pavd.program_id = fnd_global.conc_program_id
996: GROUP BY pavd.inventory_item_id);
997:

Line 994: AND pavd.program_application_id = fnd_global.prog_appl_id

990: po_attribute_values_draft pavd
991: WHERE pavd.inventory_item_id = mmpn2.inventory_item_id
992: AND mmpn2.organization_id = l_master_org_id
993: AND pavd.request_id = fnd_global.conc_request_id
994: AND pavd.program_application_id = fnd_global.prog_appl_id
995: AND pavd.program_id = fnd_global.conc_program_id
996: GROUP BY pavd.inventory_item_id);
997:
998: IF (PO_LOG.d_stmt) THEN

Line 995: AND pavd.program_id = fnd_global.conc_program_id

991: WHERE pavd.inventory_item_id = mmpn2.inventory_item_id
992: AND mmpn2.organization_id = l_master_org_id
993: AND pavd.request_id = fnd_global.conc_request_id
994: AND pavd.program_application_id = fnd_global.prog_appl_id
995: AND pavd.program_id = fnd_global.conc_program_id
996: GROUP BY pavd.inventory_item_id);
997:
998: IF (PO_LOG.d_stmt) THEN
999: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl2', l_item_id_tbl2);

Line 1010: AND request_id = fnd_global.conc_request_id

1006: UPDATE po_attribute_values_draft
1007: SET manufacturer_part_num = l_mfg_part_num_tbl(i)
1008: WHERE inventory_item_id = l_item_id_tbl2(i)
1009: AND org_id = l_master_org_id
1010: AND request_id = fnd_global.conc_request_id
1011: AND program_application_id = fnd_global.prog_appl_id
1012: AND program_id = fnd_global.conc_program_id;
1013:
1014: -- Bug7039409: update po_attribute_values_tlp_draft.manufacturer

Line 1011: AND program_application_id = fnd_global.prog_appl_id

1007: SET manufacturer_part_num = l_mfg_part_num_tbl(i)
1008: WHERE inventory_item_id = l_item_id_tbl2(i)
1009: AND org_id = l_master_org_id
1010: AND request_id = fnd_global.conc_request_id
1011: AND program_application_id = fnd_global.prog_appl_id
1012: AND program_id = fnd_global.conc_program_id;
1013:
1014: -- Bug7039409: update po_attribute_values_tlp_draft.manufacturer
1015: FORALL i IN 1..l_item_id_tbl2.COUNT

Line 1012: AND program_id = fnd_global.conc_program_id;

1008: WHERE inventory_item_id = l_item_id_tbl2(i)
1009: AND org_id = l_master_org_id
1010: AND request_id = fnd_global.conc_request_id
1011: AND program_application_id = fnd_global.prog_appl_id
1012: AND program_id = fnd_global.conc_program_id;
1013:
1014: -- Bug7039409: update po_attribute_values_tlp_draft.manufacturer
1015: FORALL i IN 1..l_item_id_tbl2.COUNT
1016: UPDATE po_attribute_values_tlp_draft

Line 1020: AND request_id = fnd_global.conc_request_id

1016: UPDATE po_attribute_values_tlp_draft
1017: SET manufacturer = l_mfg_name_tbl(i)
1018: WHERE inventory_item_id = l_item_id_tbl2(i)
1019: AND org_id = l_master_org_id
1020: AND request_id = fnd_global.conc_request_id
1021: AND program_application_id = fnd_global.prog_appl_id
1022: AND program_id = fnd_global.conc_program_id;
1023:
1024: -- Bug7039409: update po_attribute_values_tlp_draft.long_description

Line 1021: AND program_application_id = fnd_global.prog_appl_id

1017: SET manufacturer = l_mfg_name_tbl(i)
1018: WHERE inventory_item_id = l_item_id_tbl2(i)
1019: AND org_id = l_master_org_id
1020: AND request_id = fnd_global.conc_request_id
1021: AND program_application_id = fnd_global.prog_appl_id
1022: AND program_id = fnd_global.conc_program_id;
1023:
1024: -- Bug7039409: update po_attribute_values_tlp_draft.long_description
1025: UPDATE po_attribute_values_tlp_draft pavd_tlp

Line 1022: AND program_id = fnd_global.conc_program_id;

1018: WHERE inventory_item_id = l_item_id_tbl2(i)
1019: AND org_id = l_master_org_id
1020: AND request_id = fnd_global.conc_request_id
1021: AND program_application_id = fnd_global.prog_appl_id
1022: AND program_id = fnd_global.conc_program_id;
1023:
1024: -- Bug7039409: update po_attribute_values_tlp_draft.long_description
1025: UPDATE po_attribute_values_tlp_draft pavd_tlp
1026: SET long_description = (SELECT long_description

Line 1033: WHERE pavd_tlp.request_id = fnd_global.conc_request_id

1029: WHERE msi_tl.inventory_item_id = pavd_tlp.inventory_item_id
1030: AND msi_tl.organization_id = l_master_org_id
1031: AND msi_tl.language = NVL(pavd_tlp.language,lang.language_code)
1032: AND lang.installed_flag = 'B')
1033: WHERE pavd_tlp.request_id = fnd_global.conc_request_id
1034: AND pavd_tlp.program_application_id = fnd_global.prog_appl_id
1035: AND pavd_tlp.program_id = fnd_global.conc_program_id;
1036:
1037: IF (PO_LOG.d_proc) THEN

Line 1034: AND pavd_tlp.program_application_id = fnd_global.prog_appl_id

1030: AND msi_tl.organization_id = l_master_org_id
1031: AND msi_tl.language = NVL(pavd_tlp.language,lang.language_code)
1032: AND lang.installed_flag = 'B')
1033: WHERE pavd_tlp.request_id = fnd_global.conc_request_id
1034: AND pavd_tlp.program_application_id = fnd_global.prog_appl_id
1035: AND pavd_tlp.program_id = fnd_global.conc_program_id;
1036:
1037: IF (PO_LOG.d_proc) THEN
1038: PO_LOG.proc_end (d_module);

Line 1035: AND pavd_tlp.program_id = fnd_global.conc_program_id;

1031: AND msi_tl.language = NVL(pavd_tlp.language,lang.language_code)
1032: AND lang.installed_flag = 'B')
1033: WHERE pavd_tlp.request_id = fnd_global.conc_request_id
1034: AND pavd_tlp.program_application_id = fnd_global.prog_appl_id
1035: AND pavd_tlp.program_id = fnd_global.conc_program_id;
1036:
1037: IF (PO_LOG.d_proc) THEN
1038: PO_LOG.proc_end (d_module);
1039: END IF;