APPS.PO_PDOI_ATTR_PROCESS_PVT dependencies on PO_ATTRIBUTE_VALUES_TLP

Line 639: FROM po_attribute_values_tlp_draft

635: SELECT l_key,
636: x_processing_row_tbl(i),
637: attribute_values_tlp_id,
638: 'DRAFT'
639: FROM po_attribute_values_tlp_draft
640: WHERE draft_id = x_attr_values_tlp.draft_id_tbl(i)
641: AND po_line_id = x_attr_values_tlp.ln_po_line_id_tbl(i)
642: AND language = x_attr_values_tlp.language_tbl(i)
643: AND org_id = x_attr_values_tlp.org_id_tbl(i);

Line 659: FROM po_attribute_values_tlp

655: SELECT l_key,
656: x_processing_row_tbl(i),
657: attribute_values_tlp_id,
658: 'TXN'
659: FROM po_attribute_values_tlp
660: WHERE po_line_id = x_attr_values_tlp.ln_po_line_id_tbl(i)
661: AND language = x_attr_values_tlp.language_tbl(i)
662: AND org_id = x_attr_values_tlp.org_id_tbl(i);
663: END IF;

Line 941: INSERT INTO po_attribute_values_tlp_draft

937: d_position := 20;
938:
939: -- create default attr_tlp rows in document created languages
940: FORALL i IN 1..l_draft_id_tbl.COUNT
941: INSERT INTO po_attribute_values_tlp_draft
942: (
943: ATTRIBUTE_VALUES_TLP_ID,
944: DRAFT_ID,
945: PO_LINE_ID,

Line 965: PO_ATTRIBUTE_VALUES_TLP_S.nextval,

961: PROGRAM_UPDATE_DATE
962: )
963: VALUES
964: (
965: PO_ATTRIBUTE_VALUES_TLP_S.nextval,
966: l_draft_id_tbl(i),
967: l_po_line_id_tbl(i),
968: '-2', -- REQ_TEMPLATE_NAME
969: -2, --REQ_TEMPLATE_LINE_NUM

Line 1022: -- Bug7039409: update po_attribute_values_tlp_draft.manufacturer

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

Line 1024: UPDATE po_attribute_values_tlp_draft

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

Line 1032: -- Bug7039409: update po_attribute_values_tlp_draft.long_description

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
1035: SET long_description = (SELECT long_description
1036: FROM mtl_system_items_tl msi_tl,

Line 1034: UPDATE po_attribute_values_tlp_draft pavd_tlp

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
1035: SET long_description = (SELECT long_description
1036: FROM mtl_system_items_tl msi_tl,
1037: fnd_languages lang
1038: WHERE msi_tl.inventory_item_id = pavd_tlp.inventory_item_id