DBA Data[Home] [Help]

APPS.PON_BID_DEFAULTING_PKG dependencies on PON_BID_HEADERS_S

Line 975: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,

971: p_userid IN pon_bid_headers.created_by%TYPE,
972: p_venid IN pon_bid_headers.vendor_id%TYPE,
973: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
974: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
975: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
976: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
977: p_buyer_user IN VARCHAR2,
978: ----------- Supplier Management: Supplier Evaluation -----------
979: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,

Line 976: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,

972: p_venid IN pon_bid_headers.vendor_id%TYPE,
973: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
974: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
975: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
976: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
977: p_buyer_user IN VARCHAR2,
978: ----------- Supplier Management: Supplier Evaluation -----------
979: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
980: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,

Line 1018: SELECT pon_bid_headers_s.nextval INTO x_bid_number

1014: AND pbh.bid_number = p_source_bid_num;
1015: END IF;
1016:
1017: -- Generate next bid number
1018: SELECT pon_bid_headers_s.nextval INTO x_bid_number
1019: FROM dual;
1020:
1021: INSERT INTO pon_bid_headers
1022: (

Line 1196: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE

1192: p_rebid_flag IN VARCHAR2,
1193: p_restricted_flag IN VARCHAR2,
1194: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1195: p_batch_end IN pon_bid_item_prices.line_number%TYPE,
1196: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE
1197: ) IS
1198: l_auctpid pon_auction_headers_all.trading_partner_id%TYPE;
1199: l_blanket VARCHAR2(1);
1200: l_full_qty VARCHAR2(1);

Line 2860: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,

2856: p_userid IN pon_bid_headers.created_by%TYPE,
2857: p_venid IN pon_bid_headers.vendor_id%TYPE,
2858: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
2859: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
2860: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
2861: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
2862: p_buyer_user IN VARCHAR2,
2863: ----------- Supplier Management: Supplier Evaluation -----------
2864: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,

Line 2861: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,

2857: p_venid IN pon_bid_headers.vendor_id%TYPE,
2858: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
2859: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
2860: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
2861: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
2862: p_buyer_user IN VARCHAR2,
2863: ----------- Supplier Management: Supplier Evaluation -----------
2864: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
2865: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,

Line 2890: l_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;

2886: l_payment_type pon_auction_headers_all.PROGRESS_PAYMENT_TYPE%TYPE;
2887: l_contract_type pon_auction_headers_all.CONTRACT_TYPE%TYPE;
2888: l_module CONSTANT VARCHAR2(35) := 'create_new_draft_bid';
2889: l_other_draft_bid_number pon_bid_headers.bid_number%TYPE;
2890: l_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;
2891: l_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%TYPE;
2892:
2893:
2894: -- Two-part RFQ related variables

Line 4736: l_auctpid pon_bid_headers.surrog_bid_created_tp_id%TYPE;

4732: l_venid pon_bid_headers.vendor_id%TYPE;
4733: l_vensid pon_bid_headers.vendor_site_id%TYPE;
4734: l_venscode pon_bid_headers.vendor_site_code%TYPE;
4735: l_buyer_user VARCHAR2(1);
4736: l_auctpid pon_bid_headers.surrog_bid_created_tp_id%TYPE;
4737: l_auctpcid pon_bid_headers.surrog_bid_created_contact_id%TYPE;
4738:
4739: ---------- Supplier Management: Supplier Evaluation ----------
4740: l_evaluator_id pon_bid_headers.evaluator_id%TYPE;

Line 4737: l_auctpcid pon_bid_headers.surrog_bid_created_contact_id%TYPE;

4733: l_vensid pon_bid_headers.vendor_site_id%TYPE;
4734: l_venscode pon_bid_headers.vendor_site_code%TYPE;
4735: l_buyer_user VARCHAR2(1);
4736: l_auctpid pon_bid_headers.surrog_bid_created_tp_id%TYPE;
4737: l_auctpcid pon_bid_headers.surrog_bid_created_contact_id%TYPE;
4738:
4739: ---------- Supplier Management: Supplier Evaluation ----------
4740: l_evaluator_id pon_bid_headers.evaluator_id%TYPE;
4741: l_eval_flag pon_bid_headers.evaluation_flag%TYPE;

Line 4887: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,

4883: p_venid IN pon_bid_headers.vendor_id%TYPE,
4884: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
4885: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
4886: p_buyer_user IN VARCHAR2,
4887: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
4888: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
4889:
4890: ----------- Supplier Management: Supplier Evaluation -----------
4891: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,

Line 4888: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,

4884: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
4885: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
4886: p_buyer_user IN VARCHAR2,
4887: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
4888: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
4889:
4890: ----------- Supplier Management: Supplier Evaluation -----------
4891: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
4892: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,