eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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_neg_line_id_tbl IN PO_TBL_NUMBER,
32: p_neg_line_num_disp_tbl IN PO_TBL_VARCHAR100,
33: /*p_line_type_id_tbl IN PO_TBL_NUMBER,
34: p_item_id_tbl IN PO_TBL_NUMBER,

Line 31: p_neg_line_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_neg_line_id_tbl IN PO_TBL_NUMBER,
32: p_neg_line_num_disp_tbl IN PO_TBL_VARCHAR100,
33: /*p_line_type_id_tbl IN PO_TBL_NUMBER,
34: p_item_id_tbl IN PO_TBL_NUMBER,
35: p_item_revision_tbl IN PO_TBL_VARCHAR5, --

Line 33: /*p_line_type_id_tbl IN PO_TBL_NUMBER,

29: -- table params in
30: p_req_line_id_tbl IN PO_TBL_NUMBER,
31: p_neg_line_id_tbl IN PO_TBL_NUMBER,
32: p_neg_line_num_disp_tbl IN PO_TBL_VARCHAR100,
33: /*p_line_type_id_tbl IN PO_TBL_NUMBER,
34: p_item_id_tbl IN PO_TBL_NUMBER,
35: p_item_revision_tbl IN PO_TBL_VARCHAR5, --
36: p_category_id_tbl IN PO_TBL_NUMBER,
37: p_quantity_tbl IN PO_TBL_NUMBER,

Line 34: p_item_id_tbl IN PO_TBL_NUMBER,

30: p_req_line_id_tbl IN PO_TBL_NUMBER,
31: p_neg_line_id_tbl IN PO_TBL_NUMBER,
32: p_neg_line_num_disp_tbl IN PO_TBL_VARCHAR100,
33: /*p_line_type_id_tbl IN PO_TBL_NUMBER,
34: p_item_id_tbl IN PO_TBL_NUMBER,
35: p_item_revision_tbl IN PO_TBL_VARCHAR5, --
36: p_category_id_tbl IN PO_TBL_NUMBER,
37: p_quantity_tbl IN PO_TBL_NUMBER,
38: p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30,--

Line 36: p_category_id_tbl IN PO_TBL_NUMBER,

32: p_neg_line_num_disp_tbl IN PO_TBL_VARCHAR100,
33: /*p_line_type_id_tbl IN PO_TBL_NUMBER,
34: p_item_id_tbl IN PO_TBL_NUMBER,
35: p_item_revision_tbl IN PO_TBL_VARCHAR5, --
36: p_category_id_tbl IN PO_TBL_NUMBER,
37: p_quantity_tbl IN PO_TBL_NUMBER,
38: p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30,--
39: p_job_id_tbl IN PO_TBL_NUMBER,*/
40:

Line 37: p_quantity_tbl IN PO_TBL_NUMBER,

33: /*p_line_type_id_tbl IN PO_TBL_NUMBER,
34: p_item_id_tbl IN PO_TBL_NUMBER,
35: p_item_revision_tbl IN PO_TBL_VARCHAR5, --
36: p_category_id_tbl IN PO_TBL_NUMBER,
37: p_quantity_tbl IN PO_TBL_NUMBER,
38: p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30,--
39: p_job_id_tbl IN PO_TBL_NUMBER,*/
40:
41: -- some more input params

Line 39: p_job_id_tbl IN PO_TBL_NUMBER,*/

35: p_item_revision_tbl IN PO_TBL_VARCHAR5, --
36: p_category_id_tbl IN PO_TBL_NUMBER,
37: p_quantity_tbl IN PO_TBL_NUMBER,
38: p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30,--
39: p_job_id_tbl IN PO_TBL_NUMBER,*/
40:
41: -- some more input params
42: p_neg_outcome IN varchar2,
43: p_document_org_id IN number,

Line 68: p_req_line_id_tbl IN PO_TBL_NUMBER,

64: -- input params
65: p_negotiation_type IN varchar2,
66: p_grouping_method IN varchar2,
67: -- table params in
68: p_req_line_id_tbl IN PO_TBL_NUMBER,
69: p_neg_line_id_tbl IN PO_TBL_NUMBER,
70: p_neg_line_num_disp_tbl IN PO_TBL_VARCHAR100,
71: /* p_line_type_id_tbl IN PO_TBL_NUMBER,
72: p_item_id_tbl IN PO_TBL_NUMBER,

Line 69: p_neg_line_id_tbl IN PO_TBL_NUMBER,

65: p_negotiation_type IN varchar2,
66: p_grouping_method IN varchar2,
67: -- table params in
68: p_req_line_id_tbl IN PO_TBL_NUMBER,
69: p_neg_line_id_tbl IN PO_TBL_NUMBER,
70: p_neg_line_num_disp_tbl IN PO_TBL_VARCHAR100,
71: /* p_line_type_id_tbl IN PO_TBL_NUMBER,
72: p_item_id_tbl IN PO_TBL_NUMBER,
73: p_item_revision_tbl IN PO_TBL_VARCHAR5, --

Line 71: /* p_line_type_id_tbl IN PO_TBL_NUMBER,

67: -- table params in
68: p_req_line_id_tbl IN PO_TBL_NUMBER,
69: p_neg_line_id_tbl IN PO_TBL_NUMBER,
70: p_neg_line_num_disp_tbl IN PO_TBL_VARCHAR100,
71: /* p_line_type_id_tbl IN PO_TBL_NUMBER,
72: p_item_id_tbl IN PO_TBL_NUMBER,
73: p_item_revision_tbl IN PO_TBL_VARCHAR5, --
74: p_category_id_tbl IN PO_TBL_NUMBER,
75: p_quantity_tbl IN PO_TBL_NUMBER,

Line 72: p_item_id_tbl IN PO_TBL_NUMBER,

68: p_req_line_id_tbl IN PO_TBL_NUMBER,
69: p_neg_line_id_tbl IN PO_TBL_NUMBER,
70: p_neg_line_num_disp_tbl IN PO_TBL_VARCHAR100,
71: /* p_line_type_id_tbl IN PO_TBL_NUMBER,
72: p_item_id_tbl IN PO_TBL_NUMBER,
73: p_item_revision_tbl IN PO_TBL_VARCHAR5, --
74: p_category_id_tbl IN PO_TBL_NUMBER,
75: p_quantity_tbl IN PO_TBL_NUMBER,
76: p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30,--

Line 74: p_category_id_tbl IN PO_TBL_NUMBER,

70: p_neg_line_num_disp_tbl IN PO_TBL_VARCHAR100,
71: /* p_line_type_id_tbl IN PO_TBL_NUMBER,
72: p_item_id_tbl IN PO_TBL_NUMBER,
73: p_item_revision_tbl IN PO_TBL_VARCHAR5, --
74: p_category_id_tbl IN PO_TBL_NUMBER,
75: p_quantity_tbl IN PO_TBL_NUMBER,
76: p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30,--
77: p_job_id_tbl IN PO_TBL_NUMBER,
78: p_line_num_display IN PO_TBL_VARCHAR30,

Line 75: p_quantity_tbl IN PO_TBL_NUMBER,

71: /* p_line_type_id_tbl IN PO_TBL_NUMBER,
72: p_item_id_tbl IN PO_TBL_NUMBER,
73: p_item_revision_tbl IN PO_TBL_VARCHAR5, --
74: p_category_id_tbl IN PO_TBL_NUMBER,
75: p_quantity_tbl IN PO_TBL_NUMBER,
76: p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30,--
77: p_job_id_tbl IN PO_TBL_NUMBER,
78: p_line_num_display IN PO_TBL_VARCHAR30,
79: p_group_line_id IN PO_TBL_NUMBER,

Line 77: p_job_id_tbl IN PO_TBL_NUMBER,

73: p_item_revision_tbl IN PO_TBL_VARCHAR5, --
74: p_category_id_tbl IN PO_TBL_NUMBER,
75: p_quantity_tbl IN PO_TBL_NUMBER,
76: p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30,--
77: p_job_id_tbl IN PO_TBL_NUMBER,
78: p_line_num_display IN PO_TBL_VARCHAR30,
79: p_group_line_id IN PO_TBL_NUMBER,
80: p_clm_info_flag IN PO_TBL_VARCHAR5,
81: p_clm_option_indicator IN PO_TBL_VARCHAR5,

Line 79: p_group_line_id IN PO_TBL_NUMBER,

75: p_quantity_tbl IN PO_TBL_NUMBER,
76: p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30,--
77: p_job_id_tbl IN PO_TBL_NUMBER,
78: p_line_num_display IN PO_TBL_VARCHAR30,
79: p_group_line_id IN PO_TBL_NUMBER,
80: p_clm_info_flag IN PO_TBL_VARCHAR5,
81: p_clm_option_indicator IN PO_TBL_VARCHAR5,
82: p_clm_option_num IN PO_TBL_NUMBER,
83: p_clm_option_from_date IN PO_TBL_DATE,

Line 82: p_clm_option_num IN PO_TBL_NUMBER,

78: p_line_num_display IN PO_TBL_VARCHAR30,
79: p_group_line_id IN PO_TBL_NUMBER,
80: p_clm_info_flag IN PO_TBL_VARCHAR5,
81: p_clm_option_indicator IN PO_TBL_VARCHAR5,
82: p_clm_option_num IN PO_TBL_NUMBER,
83: p_clm_option_from_date IN PO_TBL_DATE,
84: p_clm_option_to_date IN PO_TBL_DATE,
85: p_clm_funded_flag IN PO_TBL_VARCHAR5,
86: p_clm_base_line_num IN PO_TBL_NUMBER,*/

Line 86: p_clm_base_line_num IN PO_TBL_NUMBER,*/

82: p_clm_option_num IN PO_TBL_NUMBER,
83: p_clm_option_from_date IN PO_TBL_DATE,
84: p_clm_option_to_date IN PO_TBL_DATE,
85: p_clm_funded_flag IN PO_TBL_VARCHAR5,
86: p_clm_base_line_num IN PO_TBL_NUMBER,*/
87:
88: -- some more input params
89: p_neg_outcome IN varchar2,
90: p_document_org_id IN number,

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

121: ==============================================================================*/
122:
123: PROCEDURE create_negotiation(x_negotiation_type IN varchar2 ,
124: x_grouping_method IN varchar2 ,
125: t_req_lines IN PO_TBL_NUMBER, /* Changed the po_tbl_number to upper case for uniformity - bug 6631173 */ --bug5841426
126: p_neg_style_id IN NUMBER, --
127: p_outcome_style_id IN NUMBER, --
128: x_negotiation_id IN OUT NOCOPY number,
129: x_doc_url_params IN OUT NOCOPY varchar2,

Line 139: , t_neg_lines IN PO_TBL_NUMBER DEFAULT NULL

135: --
136: p_document_org_id IN number DEFAULT null,
137: --umbrella program
138: p_fair_opp_notice_flag IN VARCHAR2 DEFAULT NULL
139: , t_neg_lines IN PO_TBL_NUMBER DEFAULT NULL
140: , t_neg_line_num IN PO_TBL_VARCHAR100 DEFAULT NULL
141: );
142:
143: /*============================================================================

Line 284: PROCEDURE COPY_REQ_UDA_TO_SOL(p_req_lines IN PO_TBL_NUMBER,

280: Suggested Property Administration Office => PR -> SOL
281: Issuing Office => User Preferences / PR -> SOL
282: Business Priority and Project Information => PR -> SOL
283: */
284: PROCEDURE COPY_REQ_UDA_TO_SOL(p_req_lines IN PO_TBL_NUMBER,
285: p_auction_header_id IN NUMBER);
286: /* Bug 9881440 - End */
287:
288: --the procedure to remove the requisitions from the req pool

Line 291: p_requisition_line_id IN PO_TBL_NUMBER,

287:
288: --the procedure to remove the requisitions from the req pool
289: PROCEDURE REMOVE_FROM_REQ_POOL(p_line_type IN VARCHAR2,
290: p_auction_header_id IN NUMBER,
291: p_requisition_line_id IN PO_TBL_NUMBER,
292: x_return_status OUT NOCOPY VARCHAR2,
293: x_error_msg OUT NOCOPY VARCHAR2);
294:
295: g_log_module_name varchar2(30) := 'po_negotiations_sv1';