APPS.PO_DOC_UDA_UTIL dependencies on PO_HEADERS_ALL

Line 33: l_clm_standard_form PO_HEADERS_ALL.CLM_STANDARD_FORM%TYPE;

29: d_progress NUMBER := 0;
30: l_po_uda_usage_object po_uda_usage_object ;
31: l_attr_grp_ids_list PO_TBL_NUMBER;
32: l_x_attr_ids_count NUMBER;
33: l_clm_standard_form PO_HEADERS_ALL.CLM_STANDARD_FORM%TYPE;
34: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
35: l_attr_grp_ids PO_TBL_NUMBER;
36: t_count NUMBER;
37:

Line 54: SELECT clm_standard_form into l_clm_standard_form FROM po_headers_all

50: FOR c_get_usages_rec IN c_get_usages(p_template_id) LOOP
51: l_context := NULL;
52:
53: IF (c_get_usages_rec.attribute_category = 'FORMS') then
54: SELECT clm_standard_form into l_clm_standard_form FROM po_headers_all
55: WHERE po_header_id = p_po_header_id;
56: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'FORM_TYPE', l_clm_standard_form));
57: END IF;
58:

Line 322: FROM po_headers_all

318: END IF;
319: -- START WITH HEADER LEVEL MERGE
320: SELECT uda_template_id
321: INTO l_template_id
322: FROM po_headers_all
323: WHERE po_header_id = p_po_header_id;
324:
325: l_from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PO_HEADER_ID', p_po_header_id),
326: EGO_COL_NAME_VALUE_PAIR_OBJ('DRAFT_ID', p_draft_id));