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 926: FND_GLOBAL.login_id,

922: NVL(l_ip_category_id_tbl(i), -2),
923: NVL(l_item_id_tbl(i), -2),
924: PO_PDOI_PARAMS.g_request.org_id,
925: l_lead_time_tbl(i), -- Bug7039409: LEAD_TIME
926: FND_GLOBAL.login_id,
927: FND_GLOBAL.user_id,
928: sysdate,
929: FND_GLOBAL.user_id,
930: sysdate,

Line 927: FND_GLOBAL.user_id,

923: NVL(l_item_id_tbl(i), -2),
924: PO_PDOI_PARAMS.g_request.org_id,
925: l_lead_time_tbl(i), -- Bug7039409: LEAD_TIME
926: FND_GLOBAL.login_id,
927: FND_GLOBAL.user_id,
928: sysdate,
929: FND_GLOBAL.user_id,
930: sysdate,
931: FND_GLOBAL.conc_request_id,

Line 929: FND_GLOBAL.user_id,

925: l_lead_time_tbl(i), -- Bug7039409: LEAD_TIME
926: FND_GLOBAL.login_id,
927: FND_GLOBAL.user_id,
928: sysdate,
929: FND_GLOBAL.user_id,
930: sysdate,
931: FND_GLOBAL.conc_request_id,
932: FND_GLOBAL.prog_appl_id,
933: FND_GLOBAL.conc_program_id,

Line 931: FND_GLOBAL.conc_request_id,

927: FND_GLOBAL.user_id,
928: sysdate,
929: FND_GLOBAL.user_id,
930: sysdate,
931: FND_GLOBAL.conc_request_id,
932: FND_GLOBAL.prog_appl_id,
933: FND_GLOBAL.conc_program_id,
934: sysdate
935: );

Line 932: FND_GLOBAL.prog_appl_id,

928: sysdate,
929: FND_GLOBAL.user_id,
930: sysdate,
931: FND_GLOBAL.conc_request_id,
932: FND_GLOBAL.prog_appl_id,
933: FND_GLOBAL.conc_program_id,
934: sysdate
935: );
936:

Line 933: FND_GLOBAL.conc_program_id,

929: FND_GLOBAL.user_id,
930: sysdate,
931: FND_GLOBAL.conc_request_id,
932: FND_GLOBAL.prog_appl_id,
933: FND_GLOBAL.conc_program_id,
934: sysdate
935: );
936:
937: d_position := 20;

Line 975: FND_GLOBAL.login_id,

971: NVL(l_item_id_tbl(i), -2),
972: PO_PDOI_PARAMS.g_request.org_id,
973: l_created_lang_tbl(i),
974: l_item_desc_tbl(i),
975: FND_GLOBAL.login_id,
976: FND_GLOBAL.user_id,
977: sysdate,
978: FND_GLOBAL.user_id,
979: sysdate,

Line 976: FND_GLOBAL.user_id,

972: PO_PDOI_PARAMS.g_request.org_id,
973: l_created_lang_tbl(i),
974: l_item_desc_tbl(i),
975: FND_GLOBAL.login_id,
976: FND_GLOBAL.user_id,
977: sysdate,
978: FND_GLOBAL.user_id,
979: sysdate,
980: FND_GLOBAL.conc_request_id,

Line 978: FND_GLOBAL.user_id,

974: l_item_desc_tbl(i),
975: FND_GLOBAL.login_id,
976: FND_GLOBAL.user_id,
977: sysdate,
978: FND_GLOBAL.user_id,
979: sysdate,
980: FND_GLOBAL.conc_request_id,
981: FND_GLOBAL.prog_appl_id,
982: FND_GLOBAL.conc_program_id,

Line 980: FND_GLOBAL.conc_request_id,

976: FND_GLOBAL.user_id,
977: sysdate,
978: FND_GLOBAL.user_id,
979: sysdate,
980: FND_GLOBAL.conc_request_id,
981: FND_GLOBAL.prog_appl_id,
982: FND_GLOBAL.conc_program_id,
983: sysdate
984: );

Line 981: FND_GLOBAL.prog_appl_id,

977: sysdate,
978: FND_GLOBAL.user_id,
979: sysdate,
980: FND_GLOBAL.conc_request_id,
981: FND_GLOBAL.prog_appl_id,
982: FND_GLOBAL.conc_program_id,
983: sysdate
984: );
985:

Line 982: FND_GLOBAL.conc_program_id,

978: FND_GLOBAL.user_id,
979: sysdate,
980: FND_GLOBAL.conc_request_id,
981: FND_GLOBAL.prog_appl_id,
982: FND_GLOBAL.conc_program_id,
983: sysdate
984: );
985:
986: d_position := 30;

Line 1001: AND pavd.request_id = fnd_global.conc_request_id

997: FROM mtl_mfg_part_numbers_all_v mmpn2,
998: po_attribute_values_draft pavd
999: WHERE pavd.inventory_item_id = mmpn2.inventory_item_id
1000: AND mmpn2.organization_id = l_master_org_id
1001: AND pavd.request_id = fnd_global.conc_request_id
1002: AND pavd.program_application_id = fnd_global.prog_appl_id
1003: AND pavd.program_id = fnd_global.conc_program_id
1004: GROUP BY pavd.inventory_item_id);
1005:

Line 1002: AND pavd.program_application_id = fnd_global.prog_appl_id

998: po_attribute_values_draft pavd
999: WHERE pavd.inventory_item_id = mmpn2.inventory_item_id
1000: AND mmpn2.organization_id = l_master_org_id
1001: AND pavd.request_id = fnd_global.conc_request_id
1002: AND pavd.program_application_id = fnd_global.prog_appl_id
1003: AND pavd.program_id = fnd_global.conc_program_id
1004: GROUP BY pavd.inventory_item_id);
1005:
1006: IF (PO_LOG.d_stmt) THEN

Line 1003: AND pavd.program_id = fnd_global.conc_program_id

999: WHERE pavd.inventory_item_id = mmpn2.inventory_item_id
1000: AND mmpn2.organization_id = l_master_org_id
1001: AND pavd.request_id = fnd_global.conc_request_id
1002: AND pavd.program_application_id = fnd_global.prog_appl_id
1003: AND pavd.program_id = fnd_global.conc_program_id
1004: GROUP BY pavd.inventory_item_id);
1005:
1006: IF (PO_LOG.d_stmt) THEN
1007: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl2', l_item_id_tbl2);

Line 1018: AND request_id = fnd_global.conc_request_id

1014: UPDATE po_attribute_values_draft
1015: SET manufacturer_part_num = l_mfg_part_num_tbl(i)
1016: WHERE inventory_item_id = l_item_id_tbl2(i)
1017: AND org_id = l_master_org_id
1018: AND request_id = fnd_global.conc_request_id
1019: AND program_application_id = fnd_global.prog_appl_id
1020: AND program_id = fnd_global.conc_program_id;
1021:
1022: -- Bug7039409: update po_attribute_values_tlp_draft.manufacturer

Line 1019: AND program_application_id = fnd_global.prog_appl_id

1015: SET manufacturer_part_num = l_mfg_part_num_tbl(i)
1016: WHERE inventory_item_id = l_item_id_tbl2(i)
1017: AND org_id = l_master_org_id
1018: AND request_id = fnd_global.conc_request_id
1019: AND program_application_id = fnd_global.prog_appl_id
1020: AND program_id = fnd_global.conc_program_id;
1021:
1022: -- Bug7039409: update po_attribute_values_tlp_draft.manufacturer
1023: FORALL i IN 1..l_item_id_tbl2.COUNT

Line 1020: AND program_id = fnd_global.conc_program_id;

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

Line 1028: AND request_id = fnd_global.conc_request_id

1024: UPDATE po_attribute_values_tlp_draft
1025: SET manufacturer = l_mfg_name_tbl(i)
1026: WHERE inventory_item_id = l_item_id_tbl2(i)
1027: AND org_id = l_master_org_id
1028: AND request_id = fnd_global.conc_request_id
1029: AND program_application_id = fnd_global.prog_appl_id
1030: AND program_id = fnd_global.conc_program_id;
1031:
1032: -- Bug7039409: update po_attribute_values_tlp_draft.long_description

Line 1029: AND program_application_id = fnd_global.prog_appl_id

1025: SET manufacturer = l_mfg_name_tbl(i)
1026: WHERE inventory_item_id = l_item_id_tbl2(i)
1027: AND org_id = l_master_org_id
1028: AND request_id = fnd_global.conc_request_id
1029: AND program_application_id = fnd_global.prog_appl_id
1030: AND program_id = fnd_global.conc_program_id;
1031:
1032: -- Bug7039409: update po_attribute_values_tlp_draft.long_description
1033: -- Bug7722053: Added the condition to check the long desc value

Line 1030: AND program_id = fnd_global.conc_program_id;

1026: WHERE inventory_item_id = l_item_id_tbl2(i)
1027: AND org_id = l_master_org_id
1028: AND request_id = fnd_global.conc_request_id
1029: AND program_application_id = fnd_global.prog_appl_id
1030: AND program_id = fnd_global.conc_program_id;
1031:
1032: -- Bug7039409: update po_attribute_values_tlp_draft.long_description
1033: -- Bug7722053: Added the condition to check the long desc value
1034: UPDATE po_attribute_values_tlp_draft pavd_tlp

Line 1042: WHERE pavd_tlp.request_id = fnd_global.conc_request_id

1038: WHERE msi_tl.inventory_item_id = pavd_tlp.inventory_item_id
1039: AND msi_tl.organization_id = l_master_org_id
1040: AND msi_tl.language = NVL(pavd_tlp.language,lang.language_code)
1041: AND lang.installed_flag = 'B')
1042: WHERE pavd_tlp.request_id = fnd_global.conc_request_id
1043: AND pavd_tlp.program_application_id = fnd_global.prog_appl_id
1044: AND pavd_tlp.program_id = fnd_global.conc_program_id
1045: AND pavd_tlp.long_description IS NULL;
1046:

Line 1043: AND pavd_tlp.program_application_id = fnd_global.prog_appl_id

1039: AND msi_tl.organization_id = l_master_org_id
1040: AND msi_tl.language = NVL(pavd_tlp.language,lang.language_code)
1041: AND lang.installed_flag = 'B')
1042: WHERE pavd_tlp.request_id = fnd_global.conc_request_id
1043: AND pavd_tlp.program_application_id = fnd_global.prog_appl_id
1044: AND pavd_tlp.program_id = fnd_global.conc_program_id
1045: AND pavd_tlp.long_description IS NULL;
1046:
1047: IF (PO_LOG.d_proc) THEN

Line 1044: AND pavd_tlp.program_id = fnd_global.conc_program_id

1040: AND msi_tl.language = NVL(pavd_tlp.language,lang.language_code)
1041: AND lang.installed_flag = 'B')
1042: WHERE pavd_tlp.request_id = fnd_global.conc_request_id
1043: AND pavd_tlp.program_application_id = fnd_global.prog_appl_id
1044: AND pavd_tlp.program_id = fnd_global.conc_program_id
1045: AND pavd_tlp.long_description IS NULL;
1046:
1047: IF (PO_LOG.d_proc) THEN
1048: PO_LOG.proc_end (d_module);