APPS.POR_UDA_PKG dependencies on PO_REQUISITION_HEADERS_ALL

Line 141: FROM po_requisition_headers_all WHERE requisition_header_id = p_req_header_id;

137: END IF;
138:
139: SELECT uda_template_id, preparer_id, org_id
140: INTO l_template_id, l_preparer_id, l_org_id
141: FROM po_requisition_headers_all WHERE requisition_header_id = p_req_header_id;
142:
143: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('PREPARER_ID', l_preparer_id || '', l_external_attr_value_pairs);
144: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('ORG_ID', l_org_id || '', l_external_attr_value_pairs);
145: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', FND_API.G_RET_STS_SUCCESS, l_external_attr_value_pairs);

Line 665: SELECT requisition_header_id, uda_template_id FROM po_requisition_headers_all

661: l_msg_data VARCHAR2(2000);
662: l_req_source_hdr_id NUMBER;
663:
664: CURSOR get_source_ids(p_confirmed_id NUMBER, p_revision_num NUMBER ) IS
665: SELECT requisition_header_id, uda_template_id FROM po_requisition_headers_all
666: WHERE conformed_header_id = p_confirmed_id
667: AND revision_num = p_revision_num;
668:
669: CURSOR c_get_add_agids_tbl(l_template_id NUMBER) IS

Line 764: SELECT requisition_header_id FROM po_requisition_headers_all

760: l_line_ids Dbms_Sql.number_table;
761: l_conformed_line_ids Dbms_Sql.number_table;
762:
763: CURSOR get_req_header_id(p_confirmed_id NUMBER, p_revision_num NUMBER) IS
764: SELECT requisition_header_id FROM po_requisition_headers_all
765: WHERE conformed_header_id = p_confirmed_id
766: AND revision_num = p_revision_num;
767:
768: BEGIN

Line 855: SELECT uda_template_id FROM po_requisition_headers_all

851: l_msg_count NUMBER;
852: l_msg_data VARCHAR2(2000);
853:
854: CURSOR get_source_ids(p_from_req_header_id NUMBER) IS
855: SELECT uda_template_id FROM po_requisition_headers_all
856: WHERE requisition_header_id = p_from_req_header_id;
857:
858: BEGIN
859:

Line 1049: FROM po_requisition_headers_all WHERE requisition_header_id = p_req_header_id;

1045: PO_LOG.proc_begin(d_module, 'p_req_header_id', p_req_header_id);
1046: END IF;
1047:
1048: SELECT uda_template_id INTO l_template_id
1049: FROM po_requisition_headers_all WHERE requisition_header_id = p_req_header_id;
1050:
1051: l_po_uda_usage_object := PO_UDA_USAGE_OBJECT();
1052: l_po_uda_usage_object_array := PO_UDA_USAGE_OBJECT_ARRAY();
1053: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY();

Line 1074: FROM po_requisition_headers_all

1070: END IF;
1071: END LOOP;
1072:
1073: SELECT preparer_id, org_id INTO l_preparer_id, l_org_id
1074: FROM po_requisition_headers_all
1075: WHERE requisition_header_id = p_req_header_id;
1076:
1077: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('PREPARER_ID', l_preparer_id || '', l_external_attr_value_pairs);
1078: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('ORG_ID', l_org_id || '', l_external_attr_value_pairs);