APPS.PO_PDOI_ATTR_PROCESS_PVT dependencies on PO_ATTRIBUTE_VALUES_TLP_DRAFT

Line 634: FROM po_attribute_values_tlp_draft

630: SELECT l_key,
631: x_processing_row_tbl(i),
632: attribute_values_tlp_id,
633: 'DRAFT'
634: FROM po_attribute_values_tlp_draft
635: WHERE draft_id = x_attr_values_tlp.draft_id_tbl(i)
636: AND po_line_id = x_attr_values_tlp.ln_po_line_id_tbl(i)
637: AND language = x_attr_values_tlp.language_tbl(i)
638: AND org_id = x_attr_values_tlp.org_id_tbl(i);

Line 933: INSERT INTO po_attribute_values_tlp_draft

929: d_position := 20;
930:
931: -- create default attr_tlp rows in document created languages
932: FORALL i IN 1..l_draft_id_tbl.COUNT
933: INSERT INTO po_attribute_values_tlp_draft
934: (
935: ATTRIBUTE_VALUES_TLP_ID,
936: DRAFT_ID,
937: PO_LINE_ID,

Line 1014: -- Bug7039409: update po_attribute_values_tlp_draft.manufacturer

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
1017: SET manufacturer = l_mfg_name_tbl(i)
1018: WHERE inventory_item_id = l_item_id_tbl2(i)

Line 1016: UPDATE po_attribute_values_tlp_draft

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
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

Line 1024: -- Bug7039409: update po_attribute_values_tlp_draft.long_description

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
1027: FROM mtl_system_items_tl msi_tl,
1028: fnd_languages lang

Line 1025: UPDATE po_attribute_values_tlp_draft pavd_tlp

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
1027: FROM mtl_system_items_tl msi_tl,
1028: fnd_languages lang
1029: WHERE msi_tl.inventory_item_id = pavd_tlp.inventory_item_id