[Home] [Help]
39: p_object_name := 'PO_LINE_LOCATIONS_ALL_EXT_B';
40: p_pk1_column_name := 'LINE_LOCATION_ID';
41: elsif p_doc_type = 'LINES' then
42: p_attr_group_type := 'PO_LINE_EXT_ATTRS';
43: p_object_name := 'PO_LINES_ALL_EXT_B';
44: p_pk1_column_name := 'PO_LINE_ID';
45: elsif p_doc_type = 'HEADER' then
46: p_attr_group_type := 'PO_HEADER_EXT_ATTRS';
47: p_object_name := 'PO_HEADERS_ALL_EXT_B';
217: AND kartb.sav_Sae_id = art.article_id
218: AND ver.article_id = art.article_id
219: AND kartb.document_id in
220: (SELECT DISTINCT AUCTION_HEADER_ID FROM pon_bid_headers WHERE bid_number in
221: (SELECT bid_number FROM po_lines_all WHERE po_header_id = DOCUMENTID))
222: AND kartb.document_type = 'SOLICITATION'
223: AND ( (art.article_title LIKE '52.212-1%' AND ver.INSERT_BY_REFERENCE = 'Y')
224: OR (art.article_title LIKE '52.212-4%' AND ver.INSERT_BY_REFERENCE = 'Y')
225: OR (art.article_title LIKE '52.212-3%' AND ver.INSERT_BY_REFERENCE = 'N')
460: AND POT.TEMPLATE_ID = POTU.TEMPLATE_ID
461: AND AG.DESCRIPTIVE_FLEXFIELD_NAME = POT.ENTITY_CODE
462: AND AG.ATTR_GROUP_ID = POTU.ATTRIBUTE_GROUP_ID
463: AND potu.attribute_group_id in (select distinct attr_group_id
464: from po_lines_all_ext_b
465: where po_line_id = p_po_line_id
466: and draft_id = DRAFTID
467: and attr_group_id = potu.attribute_group_id
468: and pk1_value IS NULL)
505: DELETE FROM po_eda_uda_attr_values WHERE pk1_value = c.po_line_id AND lvl='AWARDLINE' AND pk2_value = DRAFTID;
506: FOR REC IN C_ATTR_GRP(c.po_line_id,p_draft_id) LOOP
507: FOR R IN C_ATTR_MD(REC.ATTR_GROUP, REC.DESC_FLEXFLD_NAME) LOOP
508:
509: l_sql2 := 'select '||R.APPLICATION_COLUMN_NAME || ' from po_lines_all_ext_vl where po_line_id = ' || c.po_line_id ||
510: ' AND draft_id = ' || DRAFTID || ' AND pk1_value IS NULL and attr_group_id = ' || REC.ATTR_GROUP_ID;
511: EXECUTE IMMEDIATE l_sql2 INTO l_value;
512:
513: