APPS.PO_NEGOTIATIONS_SV1 dependencies on PO_TBL_NUMBER

Line 25: -- p_req_line_id_tbl IN PO_TBL_NUMBER Required

21: -- p_negotiation_type IN varchar2 Required
22: -- The negotiation type of the document
23: -- p_grouping_method IN varchar2 Required
24: -- The req grouping selected from the UI
25: -- p_req_line_id_tbl IN PO_TBL_NUMBER Required
26: -- The table containing the req_line_id column.
27: -- p_line_type_ids_tbl IN PO_TBL_NUMBER Required
28: -- The table containing the line_type_id column.
29: -- p_item_ids_tbl IN PO_TBL_NUMBER Required

Line 27: -- p_line_type_ids_tbl IN PO_TBL_NUMBER Required

23: -- p_grouping_method IN varchar2 Required
24: -- The req grouping selected from the UI
25: -- p_req_line_id_tbl IN PO_TBL_NUMBER Required
26: -- The table containing the req_line_id column.
27: -- p_line_type_ids_tbl IN PO_TBL_NUMBER Required
28: -- The table containing the line_type_id column.
29: -- p_item_ids_tbl IN PO_TBL_NUMBER Required
30: -- The table containing the item_id column.
31: --

Line 29: -- p_item_ids_tbl IN PO_TBL_NUMBER Required

25: -- p_req_line_id_tbl IN PO_TBL_NUMBER Required
26: -- The table containing the req_line_id column.
27: -- p_line_type_ids_tbl IN PO_TBL_NUMBER Required
28: -- The table containing the line_type_id column.
29: -- p_item_ids_tbl IN PO_TBL_NUMBER Required
30: -- The table containing the item_id column.
31: --
32: -- p_item_revisions_tbl IN PO_TBL_VARCHAR5 Required
33: -- The table containing the item_revision column.

Line 34: -- p_category_ids_tbl IN PO_TBL_NUMBER Required

30: -- The table containing the item_id column.
31: --
32: -- p_item_revisions_tbl IN PO_TBL_VARCHAR5 Required
33: -- The table containing the item_revision column.
34: -- p_category_ids_tbl IN PO_TBL_NUMBER Required
35: -- The table containing the req_line_id column.
36: -- p_quantities_tbl IN PO_TBL_NUMBER Required
37: -- The table containing the quantity column.
38: --

Line 36: -- p_quantities_tbl IN PO_TBL_NUMBER Required

32: -- p_item_revisions_tbl IN PO_TBL_VARCHAR5 Required
33: -- The table containing the item_revision column.
34: -- p_category_ids_tbl IN PO_TBL_NUMBER Required
35: -- The table containing the req_line_id column.
36: -- p_quantities_tbl IN PO_TBL_NUMBER Required
37: -- The table containing the quantity column.
38: --
39: -- p_unit_meas_lookup_codes_tbl IN PO_TBL_VARCHAR30 Required
40: -- The table containing the unit_meas_lookup_code column.

Line 41: -- p_job_ids_tbl IN PO_TBL_NUMBER Required

37: -- The table containing the quantity column.
38: --
39: -- p_unit_meas_lookup_codes_tbl IN PO_TBL_VARCHAR30 Required
40: -- The table containing the unit_meas_lookup_code column.
41: -- p_job_ids_tbl IN PO_TBL_NUMBER Required
42: -- The table containing the job_id column.
43: -- p_neg_outcome IN varchar2 Required
44: -- The type of document for the negotiation outcome
45: -- p_document_org_id IN number Not Required

Line 71: p_req_line_id_tbl IN PO_TBL_NUMBER,

67: -- input params
68: p_negotiation_type IN varchar2,
69: p_grouping_method IN varchar2,
70: -- table params in
71: p_req_line_id_tbl IN PO_TBL_NUMBER,
72: p_line_type_id_tbl IN PO_TBL_NUMBER,
73: p_item_id_tbl IN PO_TBL_NUMBER,
74: p_item_revision_tbl IN PO_TBL_VARCHAR5, --
75: p_category_id_tbl IN PO_TBL_NUMBER,

Line 72: p_line_type_id_tbl IN PO_TBL_NUMBER,

68: p_negotiation_type IN varchar2,
69: p_grouping_method IN varchar2,
70: -- table params in
71: p_req_line_id_tbl IN PO_TBL_NUMBER,
72: p_line_type_id_tbl IN PO_TBL_NUMBER,
73: p_item_id_tbl IN PO_TBL_NUMBER,
74: p_item_revision_tbl IN PO_TBL_VARCHAR5, --
75: p_category_id_tbl IN PO_TBL_NUMBER,
76: p_quantity_tbl IN PO_TBL_NUMBER,

Line 73: p_item_id_tbl IN PO_TBL_NUMBER,

69: p_grouping_method IN varchar2,
70: -- table params in
71: p_req_line_id_tbl IN PO_TBL_NUMBER,
72: p_line_type_id_tbl IN PO_TBL_NUMBER,
73: p_item_id_tbl IN PO_TBL_NUMBER,
74: p_item_revision_tbl IN PO_TBL_VARCHAR5, --
75: p_category_id_tbl IN PO_TBL_NUMBER,
76: p_quantity_tbl IN PO_TBL_NUMBER,
77: p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30,--

Line 75: p_category_id_tbl IN PO_TBL_NUMBER,

71: p_req_line_id_tbl IN PO_TBL_NUMBER,
72: p_line_type_id_tbl IN PO_TBL_NUMBER,
73: p_item_id_tbl IN PO_TBL_NUMBER,
74: p_item_revision_tbl IN PO_TBL_VARCHAR5, --
75: p_category_id_tbl IN PO_TBL_NUMBER,
76: p_quantity_tbl IN PO_TBL_NUMBER,
77: p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30,--
78: p_job_id_tbl IN PO_TBL_NUMBER,
79: -- some more input params

Line 76: p_quantity_tbl IN PO_TBL_NUMBER,

72: p_line_type_id_tbl IN PO_TBL_NUMBER,
73: p_item_id_tbl IN PO_TBL_NUMBER,
74: p_item_revision_tbl IN PO_TBL_VARCHAR5, --
75: p_category_id_tbl IN PO_TBL_NUMBER,
76: p_quantity_tbl IN PO_TBL_NUMBER,
77: p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30,--
78: p_job_id_tbl IN PO_TBL_NUMBER,
79: -- some more input params
80: p_neg_outcome IN varchar2,

Line 78: p_job_id_tbl IN PO_TBL_NUMBER,

74: p_item_revision_tbl IN PO_TBL_VARCHAR5, --
75: p_category_id_tbl IN PO_TBL_NUMBER,
76: p_quantity_tbl IN PO_TBL_NUMBER,
77: p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30,--
78: p_job_id_tbl IN PO_TBL_NUMBER,
79: -- some more input params
80: p_neg_outcome IN varchar2,
81: p_document_org_id IN number,
82: p_neg_style_id IN NUMBER, --

Line 169: t_req_lines IN PO_TBL_NUMBER, /* Changed the po_tbl_number to upper case for uniformity - bug 6631173 */ -- bug5841426

165: ==============================================================================*/
166:
167: PROCEDURE create_negotiation(x_negotiation_type IN varchar2 ,
168: x_grouping_method IN varchar2 ,
169: t_req_lines IN PO_TBL_NUMBER, /* Changed the po_tbl_number to upper case for uniformity - bug 6631173 */ -- bug5841426
170: p_neg_style_id IN NUMBER, --
171: p_outcome_style_id IN NUMBER, --
172: x_negotiation_id IN OUT NOCOPY number,
173: x_doc_url_params IN OUT NOCOPY varchar2,