APPS.PO_DOC_UDA_UTIL dependencies on PO_LINES_ALL

Line 115: l_contract_type PO_LINES_ALL.CONTRACT_TYPE%TYPE;

111:
112: l_po_uda_usage_object po_uda_usage_object ;
113: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
114: l_attr_grp_ids_list PO_TBL_NUMBER;
115: l_contract_type PO_LINES_ALL.CONTRACT_TYPE%TYPE;
116: l_clm_idc_type PO_LINES_ALL.CLM_IDC_TYPE%TYPE;
117: l_x_attr_ids_count NUMBER;
118: l_attr_grp_ids PO_TBL_NUMBER;
119: t_count NUMBER;

Line 116: l_clm_idc_type PO_LINES_ALL.CLM_IDC_TYPE%TYPE;

112: l_po_uda_usage_object po_uda_usage_object ;
113: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
114: l_attr_grp_ids_list PO_TBL_NUMBER;
115: l_contract_type PO_LINES_ALL.CONTRACT_TYPE%TYPE;
116: l_clm_idc_type PO_LINES_ALL.CLM_IDC_TYPE%TYPE;
117: l_x_attr_ids_count NUMBER;
118: l_attr_grp_ids PO_TBL_NUMBER;
119: t_count NUMBER;
120: l_count NUMBER;

Line 145: FROM po_lines_all

141: IF(p_draft_id = -1) THEN
142: BEGIN
143: SELECT CONTRACT_TYPE, CLM_IDC_TYPE
144: INTO l_contract_type ,l_clm_idc_type
145: FROM po_lines_all
146: WHERE po_line_id = p_po_line_id;
147: EXCEPTION
148: WHEN No_Data_Found THEN
149: l_contract_type := NULL;

Line 386: FROM po_lines_all

382: FOR i IN 1..l_po_line_ids.Count
383: LOOP
384: SELECT uda_template_id
385: INTO l_template_id
386: FROM po_lines_all
387: WHERE po_line_id = l_po_line_ids(i);
388:
389: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PO_LINE_ID', l_po_line_ids(i)),
390: EGO_COL_NAME_VALUE_PAIR_OBJ('DRAFT_ID', p_draft_id));

Line 402: FROM po_lines_all

398: AND DRAFT_ID = p_draft_id;
399:
400: SELECT CONTRACT_TYPE, CLM_IDC_TYPE
401: INTO l_base_contract_type, l_base_idc_type
402: FROM po_lines_all
403: WHERE PO_LINE_ID = l_po_line_ids(i);
404:
405: IF (l_drft_contract_type <> l_base_contract_type) OR (l_drft_idc_type <> l_base_idc_type) THEN
406: DELETE FROM PO_LINES_ALL_EXT_TL WHERE extension_id IN (SELECT extension_id FROM PO_LINES_ALL_EXT_B WHERE PO_LINE_ID = l_po_line_ids(i) AND DRAFT_ID = -1);

Line 406: DELETE FROM PO_LINES_ALL_EXT_TL WHERE extension_id IN (SELECT extension_id FROM PO_LINES_ALL_EXT_B WHERE PO_LINE_ID = l_po_line_ids(i) AND DRAFT_ID = -1);

402: FROM po_lines_all
403: WHERE PO_LINE_ID = l_po_line_ids(i);
404:
405: IF (l_drft_contract_type <> l_base_contract_type) OR (l_drft_idc_type <> l_base_idc_type) THEN
406: DELETE FROM PO_LINES_ALL_EXT_TL WHERE extension_id IN (SELECT extension_id FROM PO_LINES_ALL_EXT_B WHERE PO_LINE_ID = l_po_line_ids(i) AND DRAFT_ID = -1);
407: DELETE FROM PO_LINES_ALL_EXT_B WHERE PO_LINE_ID = l_po_line_ids(i) AND DRAFT_ID = -1;
408: END IF;
409:
410: PO_UDA_DATA_UTIL.AutoCreate_User_Attrs

Line 407: DELETE FROM PO_LINES_ALL_EXT_B WHERE PO_LINE_ID = l_po_line_ids(i) AND DRAFT_ID = -1;

403: WHERE PO_LINE_ID = l_po_line_ids(i);
404:
405: IF (l_drft_contract_type <> l_base_contract_type) OR (l_drft_idc_type <> l_base_idc_type) THEN
406: DELETE FROM PO_LINES_ALL_EXT_TL WHERE extension_id IN (SELECT extension_id FROM PO_LINES_ALL_EXT_B WHERE PO_LINE_ID = l_po_line_ids(i) AND DRAFT_ID = -1);
407: DELETE FROM PO_LINES_ALL_EXT_B WHERE PO_LINE_ID = l_po_line_ids(i) AND DRAFT_ID = -1;
408: END IF;
409:
410: PO_UDA_DATA_UTIL.AutoCreate_User_Attrs
411: (