[Home] [Help]
79: p_object_name := 'PO_LINES_ALL_EXT_B';
80: p_pk1_column_name := 'PO_LINE_ID';
81: elsif p_doc_type = 'HEADER' then
82: p_attr_group_type := 'PO_HEADER_EXT_ATTRS';
83: p_object_name := 'PO_HEADERS_ALL_EXT_B';
84: p_pk1_column_name := 'PO_HEADER_ID';
85: end if;
86:
87: if (p_data_type = 'C' or p_data_type = 'A' ) then
133: SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP,
134: AG.ATTR_GROUP_ID ATTR_GROUP_ID,
135: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME,
136: AG.MULTI_ROW MULTI_ROW
137: FROM EGO_FND_DSC_FLX_CTX_EXT AG, po_headers_all h,
138: PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU
139: WHERE h.po_header_id = p_headerId
140: AND H.UDA_TEMPLATE_ID = POT.TEMPLATE_ID
141: AND POT.TEMPLATE_ID = POTU.TEMPLATE_ID
141: AND POT.TEMPLATE_ID = POTU.TEMPLATE_ID
142: AND AG.DESCRIPTIVE_FLEXFIELD_NAME = POT.ENTITY_CODE
143: AND AG.ATTR_GROUP_ID = POTU.ATTRIBUTE_GROUP_ID
144: AND potu.attribute_group_id in (select distinct attr_group_id
145: from po_headers_all_ext_b
146: where po_header_id = p_headerId
147: and draft_id = p_draft_id
148: and attr_group_id = potu.attribute_group_id)
149: ORDER BY POTU.ATTRIBUTE_GROUP_SEQUENCE;
214: L_SQL := L_SQL || ')))';
215: ELSE
216: L_SQL := L_SQL || ' ))';
217: END IF;
218: L_SQL := L_SQL || ' from po_headers_all_ext_vl where po_header_id = ' ||
219: p_headerId || ' AND draft_id = ' || p_draft_id ||
220: ' and attr_group_id = ' || REC.ATTR_GROUP_ID || ')' ;
221: L_O_CTR := L_O_CTR + 1;
222: END LOOP;
247: clob_addr CLOB;
248: c_addr SYS_REFCURSOR;
249: l_address varchar2(4000);
250: begin
251: l_where_sql := ' from po_headers_all_ext_vl where po_header_id = :1 and draft_id = :2';
252:
253: begin
254: SELECT ag.attr_group_id,
255: efdfce.application_column_name
304: c_cnt SYS_REFCURSOR;
305: clob_cnt CLOB;
306:
307: begin
308: l_where_sql := ' from po_headers_all_ext_vl where po_header_id = :1 and draft_id = :2';
309:
310: begin
311: SELECT ag.attr_group_id,
312: efdfce.application_column_name