APPS.POR_UDA_PKG dependencies on PO_REQUISITION_LINES_ALL

Line 32: SELECT CONTRACT_TYPE FROM po_requisition_lines_all

28: SELECT DISTINCT(ATTRIBUTE_CATEGORY) FROM po_uda_ag_template_usages
29: WHERE template_id = p_template_id;
30:
31: CURSOR c_get_usage_context(p_req_line_id NUMBER) IS
32: SELECT CONTRACT_TYPE FROM po_requisition_lines_all
33: WHERE requisition_line_id = p_req_line_id;
34:
35: BEGIN
36:

Line 129: SELECT requisition_line_id FROM po_requisition_lines_all

125:
126: msg_count NUMBER;
127:
128: CURSOR c_get_lines(p_req_header_id NUMBER) IS
129: SELECT requisition_line_id FROM po_requisition_lines_all
130: WHERE requisition_header_id = p_req_header_id;
131:
132:
133: BEGIN

Line 179: FROM po_requisition_lines_all

175: FOR c_get_lines_rec IN c_get_lines(p_req_header_id) LOOP
176:
177: SELECT uda_template_id, line_type_id, contract_type, item_id, deliver_to_location_id
178: INTO l_template_id, l_line_type_id, l_contract_line_type, l_item_id, l_deliver_to_location_id
179: FROM po_requisition_lines_all
180: WHERE requisition_line_id = c_get_lines_rec.requisition_line_id;
181:
182: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('ITEM_ID', l_item_id || '', l_external_attr_value_pairs);
183: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('CONTRACT_TYPE', l_contract_line_type || '', l_external_attr_value_pairs);

Line 782: FROM po_requisition_lines_all

778: CLOSE get_req_header_id;
779:
780: SELECT requisition_line_id , conformed_line_id
781: BULK COLLECT INTO l_line_ids , l_conformed_line_ids
782: FROM po_requisition_lines_all
783: WHERE requisition_header_id = l_req_source_hdr_id;
784: -- AND group_line_id IS NULL
785: -- AND clm_base_line_num IS NULL;
786:

Line 797: FROM po_requisition_lines_all WHERE REQUISITION_LINE_ID = l_line_ids(i);

793: FOR i IN 1..l_line_ids.Count LOOP
794: IF l_conformed_line_ids(i) IS NOT NULL THEN
795:
796: SELECT uda_template_id INTO l_template_id
797: FROM po_requisition_lines_all WHERE REQUISITION_LINE_ID = l_line_ids(i);
798:
799: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(
800: 'REQUISITION_LINE_ID', l_line_ids(i)));
801:

Line 938: FROM po_requisition_lines_all

934:
935:
936: SELECT requisition_line_id
937: BULK COLLECT INTO l_from_line_ids
938: FROM po_requisition_lines_all
939: WHERE requisition_header_id = p_from_req_header_id;
940:
941: SELECT requisition_line_id
942: BULK COLLECT INTO l_to_line_ids

Line 943: FROM po_requisition_lines_all

939: WHERE requisition_header_id = p_from_req_header_id;
940:
941: SELECT requisition_line_id
942: BULK COLLECT INTO l_to_line_ids
943: FROM po_requisition_lines_all
944: WHERE requisition_header_id = p_to_req_header_id;
945:
946: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY();
947: l_to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY();

Line 956: FROM po_requisition_lines_all WHERE REQUISITION_LINE_ID = l_from_line_ids(i);

952: FOR i IN 1..l_from_line_ids.Count LOOP
953: IF l_to_line_ids(i) IS NOT NULL THEN
954:
955: SELECT uda_template_id INTO l_template_id
956: FROM po_requisition_lines_all WHERE REQUISITION_LINE_ID = l_from_line_ids(i);
957:
958: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(
959: 'REQUISITION_LINE_ID', l_from_line_ids(i)));
960:

Line 1030: SELECT requisition_line_id FROM po_requisition_lines_all

1026: WHERE template_id = p_template_id
1027: AND ATTRIBUTE_CATEGORY <> 'DOCUMENT_NUMBERING';
1028:
1029: CURSOR c_get_lines(p_req_header_id NUMBER) IS
1030: SELECT requisition_line_id FROM po_requisition_lines_all
1031: WHERE requisition_header_id = p_req_header_id;
1032:
1033: CURSOR c_get_line_usages(p_template_id NUMBER) IS
1034: SELECT DISTINCT(ATTRIBUTE_CATEGORY) FROM po_uda_ag_template_usages

Line 1038: SELECT CONTRACT_TYPE FROM po_requisition_lines_all

1034: SELECT DISTINCT(ATTRIBUTE_CATEGORY) FROM po_uda_ag_template_usages
1035: WHERE template_id = p_template_id;
1036:
1037: CURSOR c_get_usage_context(p_req_line_id NUMBER) IS
1038: SELECT CONTRACT_TYPE FROM po_requisition_lines_all
1039: WHERE requisition_line_id = p_req_line_id;
1040:
1041:
1042: BEGIN

Line 1099: FROM po_requisition_lines_all

1095: --Loop through all the lines for this PR to default UDA's
1096: FOR c_get_lines_rec IN c_get_lines(p_req_header_id) LOOP
1097:
1098: SELECT uda_template_id INTO l_template_id
1099: FROM po_requisition_lines_all
1100: WHERE requisition_line_id = c_get_lines_rec.requisition_line_id;
1101:
1102: l_po_uda_usage_object := PO_UDA_USAGE_OBJECT();
1103: l_po_uda_usage_object_array := PO_UDA_USAGE_OBJECT_ARRAY();

Line 1127: FROM po_requisition_lines_all

1123: END LOOP;
1124:
1125: SELECT line_type_id, contract_type, item_id, deliver_to_location_id
1126: INTO l_line_type_id, l_contract_line_type, l_item_id, l_deliver_to_location_id
1127: FROM po_requisition_lines_all
1128: WHERE requisition_line_id = c_get_lines_rec.requisition_line_id;
1129:
1130: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('ITEM_ID', l_item_id || '', l_external_attr_value_pairs);
1131: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('CONTRACT_TYPE', l_contract_line_type || '', l_external_attr_value_pairs);