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_MULTI_MOD_PVT dependencies on PO_HEADERS_ALL

Line 72: FROM po_headers_all

68: WHERE multi_mod_request_id = p_multi_mod_request_id
69: AND ((change_type = 'VENDOR_SITE_CONTACT'
70: AND (org_id, old_vendor_site_id) NOT IN
71: (SELECT DISTINCT org_id, vendor_site_id
72: FROM po_headers_all
73: WHERE po_header_id IN
74: (SELECT document_id
75: FROM po_multi_mod_docs
76: WHERE multi_mod_request_id = p_multi_mod_request_id)

Line 87: FROM po_headers_all_ext_b rmt_ofc,

83: WHERE multi_mod_request_id = p_multi_mod_request_id)))
84: OR (change_type = 'VENDOR_REMIT_ADDRESS'
85: AND (org_id,old_remit_to_addr) NOT IN
86: (SELECT DISTINCT rmt_ofc.n_ext_attr3 org_id, rmt_ofc.n_ext_attr2 remit_to_office
87: FROM po_headers_all_ext_b rmt_ofc,
88: ego_attr_groups_v v_ag
89: WHERE v_ag.attr_group_type = 'PO_HEADER_EXT_ATTRS'
90: AND v_ag.attr_group_name = 'SUPPLIER_DTLS'
91: AND v_ag.attr_group_id = rmt_ofc.attr_group_id

Line 226: FROM po_headers_all

222: BEGIN
223:
224: SELECT 'PURCHASING', TYPE_LOOKUP_CODE, STYLE_ID
225: INTO l_functional_area_code, l_document_type_code, l_document_style_id
226: FROM po_headers_all
227: WHERE PO_HEADER_ID = p_po_header_id;
228:
229: d_position := 0;
230: debug(d_module, d_position, 'Before Check_Uda_Enabled');

Line 435: l_standard_form po_headers_all.clm_standard_form%TYPE;

431:
432: l_record_already_exists VARCHAR2(1);
433: l_clm_source_document_id NUMBER;
434: l_doc_number po_drafts.modification_number%TYPE;
435: l_standard_form po_headers_all.clm_standard_form%TYPE;
436: l_document_format po_headers_all.clm_document_format%TYPE;
437: l_ame_transaction_type po_headers_all.ame_transaction_type%TYPE;
438: l_ame_approval_id po_headers_all.ame_approval_id%TYPE;
439: l_clm_default_dist VARCHAR2(1);

Line 436: l_document_format po_headers_all.clm_document_format%TYPE;

432: l_record_already_exists VARCHAR2(1);
433: l_clm_source_document_id NUMBER;
434: l_doc_number po_drafts.modification_number%TYPE;
435: l_standard_form po_headers_all.clm_standard_form%TYPE;
436: l_document_format po_headers_all.clm_document_format%TYPE;
437: l_ame_transaction_type po_headers_all.ame_transaction_type%TYPE;
438: l_ame_approval_id po_headers_all.ame_approval_id%TYPE;
439: l_clm_default_dist VARCHAR2(1);
440: BEGIN

Line 437: l_ame_transaction_type po_headers_all.ame_transaction_type%TYPE;

433: l_clm_source_document_id NUMBER;
434: l_doc_number po_drafts.modification_number%TYPE;
435: l_standard_form po_headers_all.clm_standard_form%TYPE;
436: l_document_format po_headers_all.clm_document_format%TYPE;
437: l_ame_transaction_type po_headers_all.ame_transaction_type%TYPE;
438: l_ame_approval_id po_headers_all.ame_approval_id%TYPE;
439: l_clm_default_dist VARCHAR2(1);
440: BEGIN
441:

Line 438: l_ame_approval_id po_headers_all.ame_approval_id%TYPE;

434: l_doc_number po_drafts.modification_number%TYPE;
435: l_standard_form po_headers_all.clm_standard_form%TYPE;
436: l_document_format po_headers_all.clm_document_format%TYPE;
437: l_ame_transaction_type po_headers_all.ame_transaction_type%TYPE;
438: l_ame_approval_id po_headers_all.ame_approval_id%TYPE;
439: l_clm_default_dist VARCHAR2(1);
440: BEGIN
441:
442: d_position := 0;

Line 457: po_headers_all pha

453: BEGIN
454: SELECT phda.clm_source_document_id
455: INTO l_clm_source_document_id
456: FROM po_headers_draft_all phda,
457: po_headers_all pha
458: WHERE phda.po_header_id = p_po_header_id
459: AND phda.draft_id = p_draft_id
460: AND pha.po_header_id = phda.clm_source_document_id
461: AND pha.clm_award_type IS NOT NULL;

Line 482: FROM po_headers_all_ext_b phaeb,

478:
479: BEGIN
480: SELECT distinct ags.ATTR_GROUP_NAME
481: INTO l_doc_num_ag_name
482: FROM po_headers_all_ext_b phaeb,
483: po_uda_ag_template_usages usages,
484: ego_attr_groups_v ags
485: WHERE phaeb.po_header_id = p_po_header_id
486: AND phaeb.draft_id = -1

Line 552: UPDATE po_headers_all_ext_b

548: should be PO_UDA_ADDRESS_TYPES. When modification is created from BWC, award related address fields
549: have value PO_UDA_ADDRESS_TYPES.
550: */
551:
552: UPDATE po_headers_all_ext_b
553: SET c_ext_attr40 = 'PO_UDA_ADDRESS_TYPES'
554: WHERE po_header_id = p_po_header_id
555: AND draft_id = p_draft_id
556: AND c_ext_attr39 NOT IN ('MOD_ADMIN_OFFICE', 'MOD_ISSUING_OFFICE');

Line 781: FROM po_headers_all_ext_b

777:
778: -- Cursor for fetching the extension id's against 'MOD_ISSUING_OFFICE','MOD_ADMIN_OFFICE'
779: CURSOR po_headers_ext_cursor(p_addr_attr_group_id NUMBER) IS
780: SELECT extension_id, EGO_EXTFWK_S.NEXTVAL
781: FROM po_headers_all_ext_b
782: WHERE po_header_id = p_uda_key_po_header_id
783: AND draft_id = p_uda_key_draft_id
784: AND attr_group_id = p_addr_attr_group_id
785: AND c_ext_attr39 IN ('MOD_ISSUING_OFFICE','MOD_ADMIN_OFFICE');

Line 818: -- Start Insert into PO_HEADERS_ALL_EXT_B

814: OPEN po_headers_ext_cursor(l_addr_attr_group_id);
815: FETCH po_headers_ext_cursor BULK COLLECT INTO l_old_hdr_ext_id_tbl, l_new_hdr_ext_id_tbl;
816: CLOSE po_headers_ext_cursor;
817:
818: -- Start Insert into PO_HEADERS_ALL_EXT_B
819: d_position := 30;
820: debug(d_module, d_position, 'Insert into Address Ext B');
821:
822: FORALL i IN 1..l_old_hdr_ext_id_tbl.Count

Line 823: INSERT INTO PO_HEADERS_ALL_EXT_B

819: d_position := 30;
820: debug(d_module, d_position, 'Insert into Address Ext B');
821:
822: FORALL i IN 1..l_old_hdr_ext_id_tbl.Count
823: INSERT INTO PO_HEADERS_ALL_EXT_B
824: (EXTENSION_ID
825: ,ATTR_GROUP_ID
826: ,PO_HEADER_ID
827: ,DATA_LEVEL_ID

Line 1038: FROM PO_HEADERS_ALL_EXT_B

1034: ,D_EXT_ATTR9
1035: ,D_EXT_ATTR10
1036: ,UDA_TEMPLATE_ID
1037: ,p_draft_id
1038: FROM PO_HEADERS_ALL_EXT_B
1039: WHERE extension_id = l_old_hdr_ext_id_tbl(i);
1040: -- End PO_HEADERS_ALL_EXT_B
1041:
1042: -- Start PO_HEADERS_ALL_EXT_TL

Line 1040: -- End PO_HEADERS_ALL_EXT_B

1036: ,UDA_TEMPLATE_ID
1037: ,p_draft_id
1038: FROM PO_HEADERS_ALL_EXT_B
1039: WHERE extension_id = l_old_hdr_ext_id_tbl(i);
1040: -- End PO_HEADERS_ALL_EXT_B
1041:
1042: -- Start PO_HEADERS_ALL_EXT_TL
1043: d_position := 40;
1044: debug(d_module, d_position, 'Insert into Address Ext TL');

Line 1042: -- Start PO_HEADERS_ALL_EXT_TL

1038: FROM PO_HEADERS_ALL_EXT_B
1039: WHERE extension_id = l_old_hdr_ext_id_tbl(i);
1040: -- End PO_HEADERS_ALL_EXT_B
1041:
1042: -- Start PO_HEADERS_ALL_EXT_TL
1043: d_position := 40;
1044: debug(d_module, d_position, 'Insert into Address Ext TL');
1045:
1046: FORALL i IN 1..l_old_hdr_ext_id_tbl.Count

Line 1047: INSERT INTO PO_HEADERS_ALL_EXT_TL

1043: d_position := 40;
1044: debug(d_module, d_position, 'Insert into Address Ext TL');
1045:
1046: FORALL i IN 1..l_old_hdr_ext_id_tbl.Count
1047: INSERT INTO PO_HEADERS_ALL_EXT_TL
1048: (EXTENSION_ID
1049: ,ATTR_GROUP_ID
1050: ,PO_HEADER_ID
1051: ,DATA_LEVEL_ID

Line 1166: FROM PO_HEADERS_ALL_EXT_TL

1162: ,TL_EXT_ATTR39
1163: ,TL_EXT_ATTR40
1164: ,UDA_TEMPLATE_ID
1165: ,p_draft_id
1166: FROM PO_HEADERS_ALL_EXT_TL
1167: WHERE extension_id = l_old_hdr_ext_id_tbl(i);
1168: --AND language = userenv('LANG');
1169: -- End PO_HEADERS_ALL_EXT_TL
1170:

Line 1169: -- End PO_HEADERS_ALL_EXT_TL

1165: ,p_draft_id
1166: FROM PO_HEADERS_ALL_EXT_TL
1167: WHERE extension_id = l_old_hdr_ext_id_tbl(i);
1168: --AND language = userenv('LANG');
1169: -- End PO_HEADERS_ALL_EXT_TL
1170:
1171: -- Merge the Multi-Mod Addresses only if there exists at least one address change on the Multi-Mod
1172: IF (p_addr_change_flag = 'Y') THEN
1173:

Line 1181: UPDATE po_headers_all_ext_b PHA1

1177: d_position := 60;
1178: debug(d_module, d_position, 'Merge records in Address B Table');
1179: -- Update Headers Ext Table with addresses from the Multi-Mod (stored against
1180: -- uda_key_po_header_id, uda_key_draft_id) if not null
1181: UPDATE po_headers_all_ext_b PHA1
1182: SET(
1183: C_EXT_ATTR1
1184: ,C_EXT_ATTR2
1185: ,C_EXT_ATTR3

Line 1365: FROM po_headers_all_ext_b PHA2

1361: ,Nvl(PHA2.D_EXT_ATTR7, PHA1.D_EXT_ATTR7)
1362: ,Nvl(PHA2.D_EXT_ATTR8, PHA1.D_EXT_ATTR8)
1363: ,Nvl(PHA2.D_EXT_ATTR9, PHA1.D_EXT_ATTR9)
1364: ,Nvl(PHA2.D_EXT_ATTR10, PHA1.D_EXT_ATTR10)
1365: FROM po_headers_all_ext_b PHA2
1366: WHERE PHA2.po_header_id = p_uda_key_po_header_id
1367: AND PHA2.draft_id = p_uda_key_draft_id
1368: AND PHA2.attr_group_id = l_addr_attr_group_id
1369: AND PHA1.attr_group_id = PHA2.attr_group_id

Line 1378: UPDATE po_headers_all_ext_tl PHAT1

1374:
1375: d_position := 60;
1376: debug(d_module, d_position, 'Merge records in Address TL Table');
1377:
1378: UPDATE po_headers_all_ext_tl PHAT1
1379: SET(
1380: TL_EXT_ATTR1
1381: ,TL_EXT_ATTR2
1382: ,TL_EXT_ATTR3

Line 1462: FROM po_headers_all_ext_tl PHAT2

1458: ,Nvl(PHAT2.TL_EXT_ATTR37, PHAT1.TL_EXT_ATTR37)
1459: ,Nvl(PHAT2.TL_EXT_ATTR38, PHAT1.TL_EXT_ATTR38)
1460: ,Nvl(PHAT2.TL_EXT_ATTR39, PHAT1.TL_EXT_ATTR39)
1461: ,Nvl(PHAT2.TL_EXT_ATTR40, PHAT1.TL_EXT_ATTR40)
1462: FROM po_headers_all_ext_tl PHAT2
1463: WHERE PHAT2.po_header_id = p_uda_key_po_header_id
1464: AND PHAT2.draft_id = p_uda_key_draft_id
1465: AND PHAT2.attr_group_id = l_addr_attr_group_id
1466: AND PHAT1.attr_group_id = PHAT2.attr_group_id

Line 2072: l_doc_subtype po_headers_all.type_lookup_code%TYPE;

2068: l_change_type_vendor_name CONSTANT VARCHAR2(30) := 'VENDOR_NAME_CHANGE';
2069: l_change_type_vendor CONSTANT VARCHAR2(30) := 'VENDOR_CHANGE';
2070:
2071: l_org_id NUMBER;
2072: l_doc_subtype po_headers_all.type_lookup_code%TYPE;
2073:
2074: l_old_vendor_id NUMBER;
2075: l_old_vendor_site_id NUMBER;
2076: l_old_vendor_contact_id NUMBER;

Line 2084: l_new_vendor_name po_headers_all.CLM_SUPPLIER_NAME%TYPE;

2080: l_new_vendor_site_id NUMBER;
2081: l_new_vendor_contact_id NUMBER;
2082: l_new_remit_to_addr NUMBER;
2083:
2084: l_new_vendor_name po_headers_all.CLM_SUPPLIER_NAME%TYPE;
2085: l_new_vendor_site_name po_headers_all.CLM_SUPPLIER_SITE_NAME%TYPE;
2086:
2087: l_default_method po_headers_all.SUPPLIER_NOTIF_METHOD%TYPE;
2088: l_fax_number po_headers_all.FAX%TYPE;

Line 2085: l_new_vendor_site_name po_headers_all.CLM_SUPPLIER_SITE_NAME%TYPE;

2081: l_new_vendor_contact_id NUMBER;
2082: l_new_remit_to_addr NUMBER;
2083:
2084: l_new_vendor_name po_headers_all.CLM_SUPPLIER_NAME%TYPE;
2085: l_new_vendor_site_name po_headers_all.CLM_SUPPLIER_SITE_NAME%TYPE;
2086:
2087: l_default_method po_headers_all.SUPPLIER_NOTIF_METHOD%TYPE;
2088: l_fax_number po_headers_all.FAX%TYPE;
2089: l_email_address po_headers_all.EMAIL_ADDRESS%TYPE;

Line 2087: l_default_method po_headers_all.SUPPLIER_NOTIF_METHOD%TYPE;

2083:
2084: l_new_vendor_name po_headers_all.CLM_SUPPLIER_NAME%TYPE;
2085: l_new_vendor_site_name po_headers_all.CLM_SUPPLIER_SITE_NAME%TYPE;
2086:
2087: l_default_method po_headers_all.SUPPLIER_NOTIF_METHOD%TYPE;
2088: l_fax_number po_headers_all.FAX%TYPE;
2089: l_email_address po_headers_all.EMAIL_ADDRESS%TYPE;
2090: l_xml_flag VARCHAR2(1) := 'N';
2091: l_edi_flag VARCHAR2(1) := 'N';

Line 2088: l_fax_number po_headers_all.FAX%TYPE;

2084: l_new_vendor_name po_headers_all.CLM_SUPPLIER_NAME%TYPE;
2085: l_new_vendor_site_name po_headers_all.CLM_SUPPLIER_SITE_NAME%TYPE;
2086:
2087: l_default_method po_headers_all.SUPPLIER_NOTIF_METHOD%TYPE;
2088: l_fax_number po_headers_all.FAX%TYPE;
2089: l_email_address po_headers_all.EMAIL_ADDRESS%TYPE;
2090: l_xml_flag VARCHAR2(1) := 'N';
2091: l_edi_flag VARCHAR2(1) := 'N';
2092:

Line 2089: l_email_address po_headers_all.EMAIL_ADDRESS%TYPE;

2085: l_new_vendor_site_name po_headers_all.CLM_SUPPLIER_SITE_NAME%TYPE;
2086:
2087: l_default_method po_headers_all.SUPPLIER_NOTIF_METHOD%TYPE;
2088: l_fax_number po_headers_all.FAX%TYPE;
2089: l_email_address po_headers_all.EMAIL_ADDRESS%TYPE;
2090: l_xml_flag VARCHAR2(1) := 'N';
2091: l_edi_flag VARCHAR2(1) := 'N';
2092:
2093: l_retcode pls_integer;

Line 2562: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;

2558:
2559: l_draft_id NUMBER;
2560: l_template_id NUMBER;
2561: l_style_id NUMBER;
2562: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
2563: l_org_id NUMBER;
2564: l_is_uda_enabled VARCHAR2(5);
2565: l_clause_updated_yn VARCHAR2(1);
2566: l_conc_mod_enabled VARCHAR2(1) ;

Line 2614: FROM po_headers_all

2610: INTO l_template_id,
2611: l_style_id,
2612: l_doc_subtype,
2613: l_org_id
2614: FROM po_headers_all
2615: WHERE po_header_id = p_po_header_id;
2616:
2617: /*Need to check if conc mod is enabled for this style of document. If not and there exists
2618: a mod already, new mod creation should not be allowed.*/

Line 2744: FROM po_headers_all_ext_b ext,

2740: NVL(n_ext_attr13,0) + NVL(n_ext_attr14,0) + NVL(n_ext_attr15,0) +
2741: NVL(n_ext_attr16,0) + NVL(n_ext_attr17,0) + NVL(n_ext_attr18,0) +
2742: NVL(n_ext_attr19,0) + NVL(n_ext_attr20,0)),0) attr_sum
2743: BULK COLLECT INTO l_entity_pk2, l_sum_check_tbl
2744: FROM po_headers_all_ext_b ext,
2745: po_multi_mod_requests multimod
2746: WHERE ext.po_header_id = multimod.uda_key_po_header_id
2747: AND ext.draft_id = multimod.uda_key_draft_id
2748: AND ext.attr_group_id = l_addr_attr_group_id