DBA Data[Home] [Help]

APPS.PON_MULTIPLE_RESPONSE_PKG dependencies on PON_BID_HEADERS

Line 45: p_draft_number IN pon_bid_headers.bid_number%TYPE,

41: -- ======================================================================
42: PROCEDURE check_and_load_bid
43: (
44: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
45: p_draft_number IN pon_bid_headers.bid_number%TYPE,
46: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
47: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
48: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
49: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,

Line 46: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

42: PROCEDURE check_and_load_bid
43: (
44: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
45: p_draft_number IN pon_bid_headers.bid_number%TYPE,
46: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
47: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
48: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
49: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
50: p_userid IN pon_bid_headers.created_by%TYPE,

Line 47: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,

43: (
44: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
45: p_draft_number IN pon_bid_headers.bid_number%TYPE,
46: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
47: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
48: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
49: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
50: p_userid IN pon_bid_headers.created_by%TYPE,
51: p_venid IN pon_bid_headers.vendor_id%TYPE,

Line 48: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,

44: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
45: p_draft_number IN pon_bid_headers.bid_number%TYPE,
46: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
47: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
48: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
49: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
50: p_userid IN pon_bid_headers.created_by%TYPE,
51: p_venid IN pon_bid_headers.vendor_id%TYPE,
52: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

Line 49: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,

45: p_draft_number IN pon_bid_headers.bid_number%TYPE,
46: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
47: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
48: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
49: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
50: p_userid IN pon_bid_headers.created_by%TYPE,
51: p_venid IN pon_bid_headers.vendor_id%TYPE,
52: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
53: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,

Line 50: p_userid IN pon_bid_headers.created_by%TYPE,

46: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
47: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
48: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
49: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
50: p_userid IN pon_bid_headers.created_by%TYPE,
51: p_venid IN pon_bid_headers.vendor_id%TYPE,
52: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
53: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
54: p_buyer_user IN VARCHAR2,

Line 51: p_venid IN pon_bid_headers.vendor_id%TYPE,

47: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
48: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
49: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
50: p_userid IN pon_bid_headers.created_by%TYPE,
51: p_venid IN pon_bid_headers.vendor_id%TYPE,
52: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
53: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
54: p_buyer_user IN VARCHAR2,
55: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,

Line 52: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

48: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
49: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
50: p_userid IN pon_bid_headers.created_by%TYPE,
51: p_venid IN pon_bid_headers.vendor_id%TYPE,
52: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
53: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
54: p_buyer_user IN VARCHAR2,
55: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
56: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,

Line 53: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,

49: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
50: p_userid IN pon_bid_headers.created_by%TYPE,
51: p_venid IN pon_bid_headers.vendor_id%TYPE,
52: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
53: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
54: p_buyer_user IN VARCHAR2,
55: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
56: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
57:

Line 55: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,

51: p_venid IN pon_bid_headers.vendor_id%TYPE,
52: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
53: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
54: p_buyer_user IN VARCHAR2,
55: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
56: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
57:
58: ----------- Supplier Management: Supplier Evaluation -----------
59: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,

Line 56: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,

52: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
53: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
54: p_buyer_user IN VARCHAR2,
55: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
56: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
57:
58: ----------- Supplier Management: Supplier Evaluation -----------
59: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
60: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,

Line 59: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,

55: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
56: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
57:
58: ----------- Supplier Management: Supplier Evaluation -----------
59: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
60: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
61: ----------------------------------------------------------------
62:
63: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,

Line 60: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,

56: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
57:
58: ----------- Supplier Management: Supplier Evaluation -----------
59: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
60: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
61: ----------------------------------------------------------------
62:
63: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
64: x_rebid_flag OUT NOCOPY VARCHAR2,

Line 63: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,

59: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
60: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
61: ----------------------------------------------------------------
62:
63: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
64: x_rebid_flag OUT NOCOPY VARCHAR2,
65: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
66: x_amend_bid_def OUT NOCOPY VARCHAR2,
67: x_round_bid_def OUT NOCOPY VARCHAR2,

Line 65: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,

61: ----------------------------------------------------------------
62:
63: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
64: x_rebid_flag OUT NOCOPY VARCHAR2,
65: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
66: x_amend_bid_def OUT NOCOPY VARCHAR2,
67: x_round_bid_def OUT NOCOPY VARCHAR2,
68: x_prev_bid_disq OUT NOCOPY VARCHAR2,
69: x_prev_bid_wthd OUT NOCOPY VARCHAR2,

Line 74: p_rev_bid_number IN pon_bid_headers.bid_number%TYPE,

70: x_withdraw_reason OUT NOCOPY VARCHAR2,
71: x_edit_draft OUT NOCOPY VARCHAR2,
72:
73: p_action_code IN VARCHAR2,
74: p_rev_bid_number IN pon_bid_headers.bid_number%TYPE,
75: x_return_status OUT NOCOPY NUMBER,
76: x_return_code OUT NOCOPY VARCHAR2
77: );
78:

Line 88: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

84: * which has offers. Draft offers on previous round are not considered.
85: * If offers exist on multiple documents, latest submitted document with offers will be returned.
86: */
87: PROCEDURE get_latest_neg_with_resp(p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
88: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
89: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
90: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
91: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
92: p_eval_flag IN VARCHAR2,

Line 89: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,

85: * If offers exist on multiple documents, latest submitted document with offers will be returned.
86: */
87: PROCEDURE get_latest_neg_with_resp(p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
88: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
89: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
90: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
91: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
92: p_eval_flag IN VARCHAR2,
93: p_buyer_user IN VARCHAR2,

Line 90: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

86: */
87: PROCEDURE get_latest_neg_with_resp(p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
88: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
89: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
90: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
91: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
92: p_eval_flag IN VARCHAR2,
93: p_buyer_user IN VARCHAR2,
94: x_auc_id_with_resp OUT NOCOPY pon_auction_headers_all.auction_header_id%TYPE,

Line 91: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,

87: PROCEDURE get_latest_neg_with_resp(p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
88: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
89: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
90: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
91: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
92: p_eval_flag IN VARCHAR2,
93: p_buyer_user IN VARCHAR2,
94: x_auc_id_with_resp OUT NOCOPY pon_auction_headers_all.auction_header_id%TYPE,
95: x_is_prev_amend OUT NOCOPY VARCHAR2);