APPS.PON_AUCTION_INTERFACE_PKG dependencies on PO_UDA_AG_TEMPLATE_USAGES

Line 927: l_comp_pricing_grp_id po_uda_ag_template_usages.ATTRIBUTE_GROUP_ID%TYPE; -- bug 13571062

923: pop_start_dt pon_auction_item_prices_all.need_by_date%TYPE;
924: pop_end_dt pon_auction_item_prices_all.need_by_date%TYPE;
925: --CLM Bug : 10096343
926: l_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE;
927: l_comp_pricing_grp_id po_uda_ag_template_usages.ATTRIBUTE_GROUP_ID%TYPE; -- bug 13571062
928: BEGIN
929: logme(l_log_module, 'Entered add_negotiation_line');
930: logme(l_log_module, 'P_DOCUMENT_NUMBER '||P_DOCUMENT_NUMBER);
931: logme(l_log_module, 'P_CONTRACT_TYPE '||P_CONTRACT_TYPE);

Line 1861: FROM po_uda_ag_template_usages

1857: -- add amount of grouped lines.
1858: logme('pon.plsql.pon_auction_interface_pkg.Add_Negotiation_Line',
1859: 'When items were grouped');
1860: SELECT ATTRIBUTE_GROUP_ID INTO l_comp_pricing_grp_id
1861: FROM po_uda_ag_template_usages
1862: WHERE template_id = P_REQ_LINE_TEMP_ID
1863: AND ATTRIBUTE1 = P_CLM_IDC_TYPE
1864: AND ATTRIBUTE2 = P_CLM_CONTRACT_TYPE;
1865:

Line 1882: (select attribute_group_id from po_uda_ag_template_usages

1878: delete pon_auction_item_prices_ext_b
1879: where auction_header_id = p_document_number
1880: and line_number=p_line_number
1881: and attr_group_id in
1882: (select attribute_group_id from po_uda_ag_template_usages
1883: where template_id=p_uda_template_id
1884: and nvl(attribute1,'X')=nvl(p_clm_idc_type,'X')
1885: and nvl(attribute2,'X')=nvl(p_clm_contract_type,'X'));
1886: logme('pon.plsql.pon_auction_interface_pkg.Add_Negotiation_Line',

Line 1891: FROM po_uda_ag_template_usages

1887: 'Delete complex pricing UDA ');
1888:
1889: ELSE
1890: SELECT ATTRIBUTE_GROUP_ID INTO l_comp_pricing_grp_id
1891: FROM po_uda_ag_template_usages
1892: WHERE template_id = P_UDA_TEMPLATE_ID
1893: AND ATTRIBUTE1 = P_CLM_IDC_TYPE
1894: AND ATTRIBUTE2 = P_CLM_CONTRACT_TYPE;
1895: