DBA Data[Home] [Help]

APPS.PON_UNSOL_VALIDATIONS_PKG dependencies on PON_BID_HEADERS

Line 12: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

8: PROCEDURE VALIDATE_UNSOL_LINES( p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
9: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
10: p_interface_type IN pon_interface_errors.interface_type%TYPE,
11: p_userid IN pon_interface_errors.created_by%TYPE,
12: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
13: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
14: p_spreadsheet IN VARCHAR2,
15: p_blanket IN VARCHAR2,
16: p_global IN VARCHAR2,

Line 13: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

9: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
10: p_interface_type IN pon_interface_errors.interface_type%TYPE,
11: p_userid IN pon_interface_errors.created_by%TYPE,
12: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
13: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
14: p_spreadsheet IN VARCHAR2,
15: p_blanket IN VARCHAR2,
16: p_global IN VARCHAR2,
17: p_trans_view IN VARCHAR2,

Line 25: p_min_bid_change IN pon_bid_headers.min_bid_change%TYPE,

21: p_price_driven IN VARCHAR2,
22: p_percent_decr IN VARCHAR2,
23: p_bid_decr_method IN pon_auction_headers_all.bid_decrement_method%TYPE,
24: p_min_bid_decr IN pon_auction_headers_all.min_bid_decrement%TYPE,
25: p_min_bid_change IN pon_bid_headers.min_bid_change%TYPE,
26: p_rate IN pon_bid_headers.rate%TYPE,
27: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
28: p_amt_precision IN fnd_currencies.precision%TYPE,
29: p_bid_curr_code IN pon_bid_headers.bid_currency_code%TYPE,

Line 26: p_rate IN pon_bid_headers.rate%TYPE,

22: p_percent_decr IN VARCHAR2,
23: p_bid_decr_method IN pon_auction_headers_all.bid_decrement_method%TYPE,
24: p_min_bid_decr IN pon_auction_headers_all.min_bid_decrement%TYPE,
25: p_min_bid_change IN pon_bid_headers.min_bid_change%TYPE,
26: p_rate IN pon_bid_headers.rate%TYPE,
27: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
28: p_amt_precision IN fnd_currencies.precision%TYPE,
29: p_bid_curr_code IN pon_bid_headers.bid_currency_code%TYPE,
30: p_suffix IN VARCHAR2,

Line 27: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,

23: p_bid_decr_method IN pon_auction_headers_all.bid_decrement_method%TYPE,
24: p_min_bid_decr IN pon_auction_headers_all.min_bid_decrement%TYPE,
25: p_min_bid_change IN pon_bid_headers.min_bid_change%TYPE,
26: p_rate IN pon_bid_headers.rate%TYPE,
27: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
28: p_amt_precision IN fnd_currencies.precision%TYPE,
29: p_bid_curr_code IN pon_bid_headers.bid_currency_code%TYPE,
30: p_suffix IN VARCHAR2,
31: p_batch_id IN pon_interface_errors.batch_id%TYPE,

Line 29: p_bid_curr_code IN pon_bid_headers.bid_currency_code%TYPE,

25: p_min_bid_change IN pon_bid_headers.min_bid_change%TYPE,
26: p_rate IN pon_bid_headers.rate%TYPE,
27: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
28: p_amt_precision IN fnd_currencies.precision%TYPE,
29: p_bid_curr_code IN pon_bid_headers.bid_currency_code%TYPE,
30: p_suffix IN VARCHAR2,
31: p_batch_id IN pon_interface_errors.batch_id%TYPE,
32: p_request_id IN pon_interface_errors.request_id%TYPE,
33: p_two_part_tech_surrogate_flag IN VARCHAR2) IS

Line 1068: , pon_bid_headers pbh

1064: bl.CLM_PROMISE_PERIOD s_clm_promise_period,
1065: bl.CLM_PROMISE_PERIOD_UOM s_clm_promise_period_uom,
1066: bl.CLM_PROMISE_POP_DURATION s_clm_pop_duration
1067: FROM pon_bid_item_prices bl
1068: , pon_bid_headers pbh
1069: WHERE pbh.auction_header_id = p_auc_header_id
1070: AND pbh.bid_number = p_bid_number
1071: AND bl.bid_number = pbh.bid_number
1072: AND bl.auction_line_number = -1

Line 1392: FROM pon_bid_headers bh,

1388: bh.number_price_decimals s_precision,
1389: bl.line_num_display s_clm_line_num_display,
1390: nvl(bl.clm_cost_constraint,'X') s_clm_cost_constraint, -- CLM QA Bug : 9835426
1391: bl.order_type_lookup_code s_order_type_lookup_code --For clm bug : 10136754
1392: FROM pon_bid_headers bh,
1393: pon_bid_item_prices bl
1394: WHERE bh.auction_header_id = p_auc_header_id
1395: AND bh.bid_number = p_bid_number
1396: AND bl.bid_number = bh.bid_number