APPS.PO_UDA_DEFAULTING_PKG dependencies on PO_HEADERS_MERGE_V

Line 378: FROM po_headers_merge_v

374: AND DRAFT_ID = p_draft_id;
375:
376: CURSOR c_get_usage_context2(p_header_id NUMBER, p_draft_id NUMBER) IS
377: SELECT CLM_STANDARD_FORM
378: FROM po_headers_merge_v
379: WHERE po_header_id = p_header_id
380: AND DRAFT_ID = p_draft_id;
381:
382: -- CURSORS FOR ALL CONTEXTS should be added later if needed

Line 1073: FROM po_headers_merge_v

1069: BEGIN
1070: d_progress := 20;
1071: SELECT VENDOR_ID, VENDOR_SITE_ID, VENDOR_CONTACT_ID
1072: INTO l_vendor_id, l_vendor_site_id, l_vendor_contact_id
1073: FROM po_headers_merge_v
1074: WHERE PO_HEADER_ID = p_po_header_id
1075: AND DRAFT_ID = p_draft_id;
1076:
1077: d_progress := 30;

Line 1104: FROM po_headers_merge_v

1100: PO_UDA_DEFAULTING_PKG.DEBUG('Draft Id is '|| p_draft_id, d_progress);
1101: d_progress := 70;
1102: SELECT UDA_TEMPLATE_ID
1103: INTO l_template_id
1104: FROM po_headers_merge_v
1105: WHERE PO_HEADER_ID = p_po_header_id
1106: AND DRAFT_ID = p_draft_id;
1107:
1108: d_progress := 80;

Line 1361: FROM PO_HEADERS_MERGE_V

1357: BEGIN
1358: d_progress := 40;
1359: SELECT VENDOR_ID, VENDOR_SITE_ID, VENDOR_CONTACT_ID, ORG_ID, AGENT_ID, UDA_TEMPLATE_ID
1360: INTO l_vendor_id, l_vendor_site_id, l_vendor_contact_id, l_org_id, l_agent_id, l_template_id
1361: FROM PO_HEADERS_MERGE_V
1362: WHERE PO_HEADER_ID = p_po_header_id
1363: AND DRAFT_ID = p_draft_id;
1364:
1365: d_progress := 50;

Line 1379: FROM PO_HEADERS_MERGE_V

1375:
1376: l_header_dirty_flag := 'N';
1377: SELECT VENDOR_ID, VENDOR_SITE_ID, VENDOR_CONTACT_ID, ORG_ID, AGENT_ID, UDA_TEMPLATE_ID
1378: INTO l_vendor_id, l_vendor_site_id, l_vendor_contact_id, l_org_id, l_agent_id, l_template_id
1379: FROM PO_HEADERS_MERGE_V
1380: WHERE PO_HEADER_ID = p_po_header_id
1381: AND DRAFT_ID = -1;
1382:
1383: d_progress := 70;

Line 1396: FROM PO_HEADERS_MERGE_V

1392: ELSE -- mod case. mod is not supposed to throw a NDF with +ve draft id, dirty or not dirty
1393: d_progress := 80;
1394: SELECT VENDOR_ID, VENDOR_SITE_ID, VENDOR_CONTACT_ID, ORG_ID, AGENT_ID, UDA_TEMPLATE_ID
1395: INTO l_vendor_id, l_vendor_site_id, l_vendor_contact_id, l_org_id, l_agent_id, l_template_id
1396: FROM PO_HEADERS_MERGE_V
1397: WHERE PO_HEADER_ID = p_po_header_id
1398: AND DRAFT_ID = p_draft_id;
1399:
1400: d_progress := 90;