APPS.OKC_REP_UDA_FUNCTIONS dependencies on PON_AUCTION_ITEM_PRICES_ALL

Line 82: l_auc_line_num pon_auction_item_prices_all.line_number%TYPE;

78:
79: l_proc_name CONSTANT VARCHAR2(50) := 'sbcr_source_doc_default';
80: l_api_name CONSTANT VARCHAR2(100):= g_pkg_name ||'.'||l_proc_name;
81:
82: l_auc_line_num pon_auction_item_prices_all.line_number%TYPE;
83: l_po_line_id po_lines_all.po_line_id%TYPE;
84: l_fsc_svc_codes PO_TBL_VARCHAR4000; --for IDV wihtout lines document fsc svc is a multi row attribute. For fetching them we will be using this variable
85:
86: BEGIN

Line 116: FROM (SELECT line_number FROM pon_auction_item_prices_all WHERE auction_header_id = p_source_doc_id

112: --For the values which will be coming at line level, the line which has maiximum amount willbe taken and defaulted
113: BEGIN
114: IF p_source_doc_type = 'SOLICITATION' THEN
115: SELECT line_number INTO l_auc_line_num
116: FROM (SELECT line_number FROM pon_auction_item_prices_all WHERE auction_header_id = p_source_doc_id
117: ORDER BY clm_amount DESC, item_description ASC)
118: WHERE rownum = 1;
119:
120: ELSIF p_source_doc_type = 'PO_STANDARD_MOD' OR p_source_doc_type = 'PA_BLANKET_MOD' THEN

Line 226: FROM pon_auction_item_prices_all

222:
223: BEGIN
224: IF p_source_doc_type = 'SOLICITATION' THEN
225: SELECT Sum(Nvl(clm_amount, 0)) INTO x_total_amount
226: FROM pon_auction_item_prices_all
227: WHERE auction_header_id = p_source_doc_id;
228: ELSE --for doc types PO_STANDARD_MOD, PA_BLANKET_MOD, PA_CONTRACT_MOD
229: SELECT changed_amt INTO x_total_amount
230: FROM po_drafts