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 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_neg_line_id_tbl IN PO_TBL_NUMBER,
73: p_neg_line_num_disp_tbl IN PO_TBL_VARCHAR100,
74: /*p_line_type_id_tbl IN PO_TBL_NUMBER,
75: p_item_id_tbl IN PO_TBL_NUMBER,

Line 72: p_neg_line_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_neg_line_id_tbl IN PO_TBL_NUMBER,
73: p_neg_line_num_disp_tbl IN PO_TBL_VARCHAR100,
74: /*p_line_type_id_tbl IN PO_TBL_NUMBER,
75: p_item_id_tbl IN PO_TBL_NUMBER,
76: p_item_revision_tbl IN PO_TBL_VARCHAR5, --

Line 74: /*p_line_type_id_tbl IN PO_TBL_NUMBER,

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

Line 75: p_item_id_tbl IN PO_TBL_NUMBER,

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

Line 77: p_category_id_tbl IN PO_TBL_NUMBER,

73: p_neg_line_num_disp_tbl IN PO_TBL_VARCHAR100,
74: /*p_line_type_id_tbl IN PO_TBL_NUMBER,
75: p_item_id_tbl IN PO_TBL_NUMBER,
76: p_item_revision_tbl IN PO_TBL_VARCHAR5, --
77: p_category_id_tbl IN PO_TBL_NUMBER,
78: p_quantity_tbl IN PO_TBL_NUMBER,
79: p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30,--
80: p_job_id_tbl IN PO_TBL_NUMBER,*/
81: -- some more input params

Line 78: p_quantity_tbl IN PO_TBL_NUMBER,

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

Line 80: p_job_id_tbl IN PO_TBL_NUMBER,*/

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

Line 191: p_req_line_id_tbl IN PO_TBL_NUMBER,

187: -- input params
188: p_negotiation_type IN varchar2,
189: p_grouping_method IN varchar2,
190: -- table params in
191: p_req_line_id_tbl IN PO_TBL_NUMBER,
192: p_neg_line_id_tbl IN PO_TBL_NUMBER,
193: p_neg_line_num_disp_tbl IN PO_TBL_VARCHAR100,
194: /*p_line_type_id_tbl IN PO_TBL_NUMBER,
195: p_item_id_tbl IN PO_TBL_NUMBER,

Line 192: p_neg_line_id_tbl IN PO_TBL_NUMBER,

188: p_negotiation_type IN varchar2,
189: p_grouping_method IN varchar2,
190: -- table params in
191: p_req_line_id_tbl IN PO_TBL_NUMBER,
192: p_neg_line_id_tbl IN PO_TBL_NUMBER,
193: p_neg_line_num_disp_tbl IN PO_TBL_VARCHAR100,
194: /*p_line_type_id_tbl IN PO_TBL_NUMBER,
195: p_item_id_tbl IN PO_TBL_NUMBER,
196: p_item_revision_tbl IN PO_TBL_VARCHAR5, --

Line 194: /*p_line_type_id_tbl IN PO_TBL_NUMBER,

190: -- table params in
191: p_req_line_id_tbl IN PO_TBL_NUMBER,
192: p_neg_line_id_tbl IN PO_TBL_NUMBER,
193: p_neg_line_num_disp_tbl IN PO_TBL_VARCHAR100,
194: /*p_line_type_id_tbl IN PO_TBL_NUMBER,
195: p_item_id_tbl IN PO_TBL_NUMBER,
196: p_item_revision_tbl IN PO_TBL_VARCHAR5, --
197: p_category_id_tbl IN PO_TBL_NUMBER,
198: p_quantity_tbl IN PO_TBL_NUMBER,

Line 195: p_item_id_tbl IN PO_TBL_NUMBER,

191: p_req_line_id_tbl IN PO_TBL_NUMBER,
192: p_neg_line_id_tbl IN PO_TBL_NUMBER,
193: p_neg_line_num_disp_tbl IN PO_TBL_VARCHAR100,
194: /*p_line_type_id_tbl IN PO_TBL_NUMBER,
195: p_item_id_tbl IN PO_TBL_NUMBER,
196: p_item_revision_tbl IN PO_TBL_VARCHAR5, --
197: p_category_id_tbl IN PO_TBL_NUMBER,
198: p_quantity_tbl IN PO_TBL_NUMBER,
199: p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30,--

Line 197: p_category_id_tbl IN PO_TBL_NUMBER,

193: p_neg_line_num_disp_tbl IN PO_TBL_VARCHAR100,
194: /*p_line_type_id_tbl IN PO_TBL_NUMBER,
195: p_item_id_tbl IN PO_TBL_NUMBER,
196: p_item_revision_tbl IN PO_TBL_VARCHAR5, --
197: p_category_id_tbl IN PO_TBL_NUMBER,
198: p_quantity_tbl IN PO_TBL_NUMBER,
199: p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30,--
200: p_job_id_tbl IN PO_TBL_NUMBER,
201: p_line_num_display IN PO_TBL_VARCHAR30,

Line 198: p_quantity_tbl IN PO_TBL_NUMBER,

194: /*p_line_type_id_tbl IN PO_TBL_NUMBER,
195: p_item_id_tbl IN PO_TBL_NUMBER,
196: p_item_revision_tbl IN PO_TBL_VARCHAR5, --
197: p_category_id_tbl IN PO_TBL_NUMBER,
198: p_quantity_tbl IN PO_TBL_NUMBER,
199: p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30,--
200: p_job_id_tbl IN PO_TBL_NUMBER,
201: p_line_num_display IN PO_TBL_VARCHAR30,
202: p_group_line_id IN PO_TBL_NUMBER,

Line 200: p_job_id_tbl IN PO_TBL_NUMBER,

196: p_item_revision_tbl IN PO_TBL_VARCHAR5, --
197: p_category_id_tbl IN PO_TBL_NUMBER,
198: p_quantity_tbl IN PO_TBL_NUMBER,
199: p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30,--
200: p_job_id_tbl IN PO_TBL_NUMBER,
201: p_line_num_display IN PO_TBL_VARCHAR30,
202: p_group_line_id IN PO_TBL_NUMBER,
203: p_clm_info_flag IN PO_TBL_VARCHAR5,
204: p_clm_option_indicator IN PO_TBL_VARCHAR5,

Line 202: p_group_line_id IN PO_TBL_NUMBER,

198: p_quantity_tbl IN PO_TBL_NUMBER,
199: p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30,--
200: p_job_id_tbl IN PO_TBL_NUMBER,
201: p_line_num_display IN PO_TBL_VARCHAR30,
202: p_group_line_id IN PO_TBL_NUMBER,
203: p_clm_info_flag IN PO_TBL_VARCHAR5,
204: p_clm_option_indicator IN PO_TBL_VARCHAR5,
205: p_clm_option_num IN PO_TBL_NUMBER,
206: p_clm_option_from_date IN PO_TBL_DATE,

Line 205: p_clm_option_num IN PO_TBL_NUMBER,

201: p_line_num_display IN PO_TBL_VARCHAR30,
202: p_group_line_id IN PO_TBL_NUMBER,
203: p_clm_info_flag IN PO_TBL_VARCHAR5,
204: p_clm_option_indicator IN PO_TBL_VARCHAR5,
205: p_clm_option_num IN PO_TBL_NUMBER,
206: p_clm_option_from_date IN PO_TBL_DATE,
207: p_clm_option_to_date IN PO_TBL_DATE,
208: p_clm_funded_flag IN PO_TBL_VARCHAR5,
209: p_clm_base_line_num IN PO_TBL_NUMBER,*/

Line 209: p_clm_base_line_num IN PO_TBL_NUMBER,*/

205: p_clm_option_num IN PO_TBL_NUMBER,
206: p_clm_option_from_date IN PO_TBL_DATE,
207: p_clm_option_to_date IN PO_TBL_DATE,
208: p_clm_funded_flag IN PO_TBL_VARCHAR5,
209: p_clm_base_line_num IN PO_TBL_NUMBER,*/
210:
211: -- some more input params
212: p_neg_outcome IN varchar2,
213: p_document_org_id IN number,

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

316: ==============================================================================*/
317:
318: PROCEDURE create_negotiation(x_negotiation_type IN varchar2 ,
319: x_grouping_method IN varchar2 ,
320: t_req_lines IN PO_TBL_NUMBER, /* Changed the po_tbl_number to upper case for uniformity - bug 6631173 */ -- bug5841426
321: p_neg_style_id IN NUMBER, --
322: p_outcome_style_id IN NUMBER, --
323: x_negotiation_id IN OUT NOCOPY number,
324: x_doc_url_params IN OUT NOCOPY varchar2,

Line 333: , t_neg_lines IN PO_TBL_NUMBER default null

329: p_neg_outcome IN varchar2,
330: --
331: p_document_org_id IN number DEFAULT null,
332: p_fair_opp_notice_flag in varchar2 default null
333: , t_neg_lines IN PO_TBL_NUMBER default null
334: , t_neg_line_num IN PO_TBL_VARCHAR100 DEFAULT NULL
335: )
336: IS
337:

Line 3184: PROCEDURE COPY_REQ_UDA_TO_SOL(p_req_lines IN PO_TBL_NUMBER,

3180: the record modified in STEP 5 back to ISSUING_OFFICE.
3181: STEP 8) After Step 5, if the data copied for Issuing Office is not valid, then don't perform any logic
3182: i.e., Issuing Office Copied from Requisition to Solicitaion should be kept as is.
3183: */
3184: PROCEDURE COPY_REQ_UDA_TO_SOL(p_req_lines IN PO_TBL_NUMBER,
3185: p_auction_header_id IN NUMBER)
3186: IS
3187: l_req_line_id NUMBER;
3188: l_req_header_id NUMBER;

Line 3376: p_requisition_line_id IN PO_TBL_NUMBER,

3372:
3373: --the procedure to remove the requisitions from the req pool
3374: PROCEDURE REMOVE_FROM_REQ_POOL(p_line_type IN VARCHAR2,
3375: p_auction_header_id IN NUMBER,
3376: p_requisition_line_id IN PO_TBL_NUMBER,
3377: x_return_status OUT NOCOPY VARCHAR2,
3378: x_error_msg OUT NOCOPY VARCHAR2) IS
3379:
3380: l_progress VARCHAR2(10);

Line 3705: l_req_line_ids PO_TBL_NUMBER := PO_TBL_NUMBER();

3701: SELECT DISTINCT(requisition_line_id)
3702: FROM pon_backing_requisitions
3703: WHERE auction_header_id = p_auction_header_id;
3704:
3705: l_req_line_ids PO_TBL_NUMBER := PO_TBL_NUMBER();
3706:
3707: l_progress VARCHAR2(10);
3708:
3709: