APPS.PO_NEGOTIATIONS_SV1 dependencies on PO_TBL_NUMBER

Line 12: Using the standard db table type PO_TBL_NUMBER will fix the issue.

8:
9: /* Bug 6631173 The below declaration was introduced in the bug 5841426,
10: the fix was working in Forms but not in the OA poages as the OA was not able to identify the
11: construct declared in a pls.
12: Using the standard db table type PO_TBL_NUMBER will fix the issue.
13: Commented the local object po_tble
14: TYPE po_tbl_number IS TABLE OF NUMBER; */ --bug5841426
15:
16: /*TYPE req_lines_table_type IS TABLE OF po_requisition_lines%rowtype

Line 14: TYPE po_tbl_number IS TABLE OF NUMBER; */ --bug5841426

10: the fix was working in Forms but not in the OA poages as the OA was not able to identify the
11: construct declared in a pls.
12: Using the standard db table type PO_TBL_NUMBER will fix the issue.
13: Commented the local object po_tble
14: TYPE po_tbl_number IS TABLE OF NUMBER; */ --bug5841426
15:
16: /*TYPE req_lines_table_type IS TABLE OF po_requisition_lines%rowtype
17: index by binary_integer;*/ --Bug5841426
18:

Line 30: p_req_line_id_tbl IN PO_TBL_NUMBER,

26: -- input params
27: p_negotiation_type IN varchar2,
28: p_grouping_method IN varchar2,
29: -- table params in
30: p_req_line_id_tbl IN PO_TBL_NUMBER,
31: p_line_type_id_tbl IN PO_TBL_NUMBER,
32: p_item_id_tbl IN PO_TBL_NUMBER,
33: p_item_revision_tbl IN PO_TBL_VARCHAR5, --
34: p_category_id_tbl IN PO_TBL_NUMBER,

Line 31: p_line_type_id_tbl IN PO_TBL_NUMBER,

27: p_negotiation_type IN varchar2,
28: p_grouping_method IN varchar2,
29: -- table params in
30: p_req_line_id_tbl IN PO_TBL_NUMBER,
31: p_line_type_id_tbl IN PO_TBL_NUMBER,
32: p_item_id_tbl IN PO_TBL_NUMBER,
33: p_item_revision_tbl IN PO_TBL_VARCHAR5, --
34: p_category_id_tbl IN PO_TBL_NUMBER,
35: p_quantity_tbl IN PO_TBL_NUMBER,

Line 32: p_item_id_tbl IN PO_TBL_NUMBER,

28: p_grouping_method IN varchar2,
29: -- table params in
30: p_req_line_id_tbl IN PO_TBL_NUMBER,
31: p_line_type_id_tbl IN PO_TBL_NUMBER,
32: p_item_id_tbl IN PO_TBL_NUMBER,
33: p_item_revision_tbl IN PO_TBL_VARCHAR5, --
34: p_category_id_tbl IN PO_TBL_NUMBER,
35: p_quantity_tbl IN PO_TBL_NUMBER,
36: p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30,--

Line 34: p_category_id_tbl IN PO_TBL_NUMBER,

30: p_req_line_id_tbl IN PO_TBL_NUMBER,
31: p_line_type_id_tbl IN PO_TBL_NUMBER,
32: p_item_id_tbl IN PO_TBL_NUMBER,
33: p_item_revision_tbl IN PO_TBL_VARCHAR5, --
34: p_category_id_tbl IN PO_TBL_NUMBER,
35: p_quantity_tbl IN PO_TBL_NUMBER,
36: p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30,--
37: p_job_id_tbl IN PO_TBL_NUMBER,
38: -- some more input params

Line 35: p_quantity_tbl IN PO_TBL_NUMBER,

31: p_line_type_id_tbl IN PO_TBL_NUMBER,
32: p_item_id_tbl IN PO_TBL_NUMBER,
33: p_item_revision_tbl IN PO_TBL_VARCHAR5, --
34: p_category_id_tbl IN PO_TBL_NUMBER,
35: p_quantity_tbl IN PO_TBL_NUMBER,
36: p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30,--
37: p_job_id_tbl IN PO_TBL_NUMBER,
38: -- some more input params
39: p_neg_outcome IN varchar2,

Line 37: p_job_id_tbl IN PO_TBL_NUMBER,

33: p_item_revision_tbl IN PO_TBL_VARCHAR5, --
34: p_category_id_tbl IN PO_TBL_NUMBER,
35: p_quantity_tbl IN PO_TBL_NUMBER,
36: p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30,--
37: p_job_id_tbl IN PO_TBL_NUMBER,
38: -- some more input params
39: p_neg_outcome IN varchar2,
40: p_document_org_id IN number,
41: p_neg_style_id IN NUMBER, --

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

66: ==============================================================================*/
67:
68: PROCEDURE create_negotiation(x_negotiation_type IN varchar2 ,
69: x_grouping_method IN varchar2 ,
70: t_req_lines IN PO_TBL_NUMBER, /* Changed the po_tbl_number to upper case for uniformity - bug 6631173 */ --bug5841426
71: p_neg_style_id IN NUMBER, --
72: p_outcome_style_id IN NUMBER, --
73: x_negotiation_id IN OUT NOCOPY number,
74: x_doc_url_params IN OUT NOCOPY varchar2,