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_COPYDOC_S1 dependencies on PO_ONLINE_REPORT_TEXT

Line 72: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

68:
69: PROCEDURE fetch_header(
70: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
71: x_from_po_header_id IN po_headers.po_header_id%TYPE,
72: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
73: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
74: x_return_code OUT NOCOPY NUMBER
75: );
76: PROCEDURE insert_header(

Line 73: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

69: PROCEDURE fetch_header(
70: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
71: x_from_po_header_id IN po_headers.po_header_id%TYPE,
72: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
73: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
74: x_return_code OUT NOCOPY NUMBER
75: );
76: PROCEDURE insert_header(
77: x_po_header_record IN PO_HEADERS%ROWTYPE,

Line 78: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

74: x_return_code OUT NOCOPY NUMBER
75: );
76: PROCEDURE insert_header(
77: x_po_header_record IN PO_HEADERS%ROWTYPE,
78: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
79: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
80: x_return_code OUT NOCOPY NUMBER,
81: x_copy_terms IN VARCHAR2 --
82: );

Line 79: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

75: );
76: PROCEDURE insert_header(
77: x_po_header_record IN PO_HEADERS%ROWTYPE,
78: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
79: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
80: x_return_code OUT NOCOPY NUMBER,
81: x_copy_terms IN VARCHAR2 --
82: );
83: PROCEDURE insert_line(

Line 85: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

81: x_copy_terms IN VARCHAR2 --
82: );
83: PROCEDURE insert_line(
84: x_po_line_record IN po_lines%ROWTYPE,
85: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
86: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
87: x_return_code OUT NOCOPY NUMBER
88: );
89:

Line 86: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

82: );
83: PROCEDURE insert_line(
84: x_po_line_record IN po_lines%ROWTYPE,
85: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
86: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
87: x_return_code OUT NOCOPY NUMBER
88: );
89:
90: PROCEDURE insert_shipment(

Line 92: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

88: );
89:
90: PROCEDURE insert_shipment(
91: x_po_shipment_record IN po_line_locations%ROWTYPE,
92: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
93: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
94: x_line_num IN po_online_report_text.line_num%TYPE,
95: x_accrue_on_receipt_flag IN VARCHAR2,
96: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE, -- Bug 2761415

Line 93: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

89:
90: PROCEDURE insert_shipment(
91: x_po_shipment_record IN po_line_locations%ROWTYPE,
92: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
93: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
94: x_line_num IN po_online_report_text.line_num%TYPE,
95: x_accrue_on_receipt_flag IN VARCHAR2,
96: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE, -- Bug 2761415
97: x_return_code OUT NOCOPY NUMBER,

Line 94: x_line_num IN po_online_report_text.line_num%TYPE,

90: PROCEDURE insert_shipment(
91: x_po_shipment_record IN po_line_locations%ROWTYPE,
92: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
93: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
94: x_line_num IN po_online_report_text.line_num%TYPE,
95: x_accrue_on_receipt_flag IN VARCHAR2,
96: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE, -- Bug 2761415
97: x_return_code OUT NOCOPY NUMBER,
98: p_is_complex_work_po IN BOOLEAN, --

Line 104: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

100: );
101:
102: PROCEDURE insert_distribution(
103: x_po_distribution_record IN po_distributions%ROWTYPE,
104: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
105: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
106: x_line_num IN po_online_report_text.line_num%TYPE,
107: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
108: x_return_code OUT NOCOPY NUMBER

Line 105: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

101:
102: PROCEDURE insert_distribution(
103: x_po_distribution_record IN po_distributions%ROWTYPE,
104: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
105: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
106: x_line_num IN po_online_report_text.line_num%TYPE,
107: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
108: x_return_code OUT NOCOPY NUMBER
109: );

Line 106: x_line_num IN po_online_report_text.line_num%TYPE,

102: PROCEDURE insert_distribution(
103: x_po_distribution_record IN po_distributions%ROWTYPE,
104: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
105: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
106: x_line_num IN po_online_report_text.line_num%TYPE,
107: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
108: x_return_code OUT NOCOPY NUMBER
109: );
110:

Line 107: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

103: x_po_distribution_record IN po_distributions%ROWTYPE,
104: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
105: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
106: x_line_num IN po_online_report_text.line_num%TYPE,
107: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
108: x_return_code OUT NOCOPY NUMBER
109: );
110:
111: PROCEDURE handle_fatal(

Line 126: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

122: x_agent_id IN po_headers.agent_id%TYPE,
123: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
124: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
125: x_copy_attachments IN BOOLEAN,
126: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
127: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
128: x_return_code OUT NOCOPY NUMBER,
129: x_copy_terms IN VARCHAR2 --
130: );

Line 127: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

123: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
124: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
125: x_copy_attachments IN BOOLEAN,
126: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
127: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
128: x_return_code OUT NOCOPY NUMBER,
129: x_copy_terms IN VARCHAR2 --
130: );
131:

Line 144: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

140: x_po_header_id IN po_lines.po_header_id%TYPE,
141: x_from_po_header_id IN po_lines.po_header_id%TYPE,
142: x_copy_attachments IN BOOLEAN,
143: x_copy_price IN BOOLEAN,
144: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
145: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
146: x_return_code OUT NOCOPY NUMBER,
147: p_is_complex_work_po IN BOOLEAN, --
148: p_calling_program IN VARCHAR2,

Line 145: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

141: x_from_po_header_id IN po_lines.po_header_id%TYPE,
142: x_copy_attachments IN BOOLEAN,
143: x_copy_price IN BOOLEAN,
144: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
145: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
146: x_return_code OUT NOCOPY NUMBER,
147: p_is_complex_work_po IN BOOLEAN, --
148: p_calling_program IN VARCHAR2,
149: p_is_clm_doc IN VARCHAR2 --

Line 217: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

213: -- Making this procedure a autonomous transaction so that even if copy doc
214: -- fails we should get the error
215: --
216: PROCEDURE online_report(
217: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
218: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
219: x_message IN po_online_report_text.text_line%TYPE,
220: x_line_num IN po_online_report_text.line_num%TYPE,
221: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

Line 218: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

214: -- fails we should get the error
215: --
216: PROCEDURE online_report(
217: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
218: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
219: x_message IN po_online_report_text.text_line%TYPE,
220: x_line_num IN po_online_report_text.line_num%TYPE,
221: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
222: x_distribution_num IN po_online_report_text.distribution_num%TYPE,

Line 219: x_message IN po_online_report_text.text_line%TYPE,

215: --
216: PROCEDURE online_report(
217: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
218: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
219: x_message IN po_online_report_text.text_line%TYPE,
220: x_line_num IN po_online_report_text.line_num%TYPE,
221: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
222: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
223: x_message_type IN VARCHAR2 --

Line 220: x_line_num IN po_online_report_text.line_num%TYPE,

216: PROCEDURE online_report(
217: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
218: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
219: x_message IN po_online_report_text.text_line%TYPE,
220: x_line_num IN po_online_report_text.line_num%TYPE,
221: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
222: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
223: x_message_type IN VARCHAR2 --
224: ) IS

Line 221: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

217: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
218: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
219: x_message IN po_online_report_text.text_line%TYPE,
220: x_line_num IN po_online_report_text.line_num%TYPE,
221: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
222: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
223: x_message_type IN VARCHAR2 --
224: ) IS
225: pragma AUTONOMOUS_TRANSACTION; --

Line 222: x_distribution_num IN po_online_report_text.distribution_num%TYPE,

218: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
219: x_message IN po_online_report_text.text_line%TYPE,
220: x_line_num IN po_online_report_text.line_num%TYPE,
221: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
222: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
223: x_message_type IN VARCHAR2 --
224: ) IS
225: pragma AUTONOMOUS_TRANSACTION; --
226: x_text_line po_online_report_text.text_line%TYPE := NULL;

Line 226: x_text_line po_online_report_text.text_line%TYPE := NULL;

222: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
223: x_message_type IN VARCHAR2 --
224: ) IS
225: pragma AUTONOMOUS_TRANSACTION; --
226: x_text_line po_online_report_text.text_line%TYPE := NULL;
227: x_line_num_msg VARCHAR2(100) := NULL;
228: x_shipment_num_msg VARCHAR2(100) := NULL;
229: x_distribution_num_msg VARCHAR2(100) := NULL;
230: --

Line 231: -- Increased x_text_line_length to 2000 (length of PO_ONLINE_REPORT_TEXT.text_line);

227: x_line_num_msg VARCHAR2(100) := NULL;
228: x_shipment_num_msg VARCHAR2(100) := NULL;
229: x_distribution_num_msg VARCHAR2(100) := NULL;
230: --
231: -- Increased x_text_line_length to 2000 (length of PO_ONLINE_REPORT_TEXT.text_line);
232: -- changed substr to substrb below to handle multibyte characters.
233: x_text_line_length NUMBER := 2000;
234:
235: BEGIN

Line 257: INSERT INTO PO_ONLINE_REPORT_TEXT (

253:
254: x_text_line := substrb(x_text_line || x_message, 1, x_text_line_length);
255:
256: BEGIN
257: INSERT INTO PO_ONLINE_REPORT_TEXT (
258: online_report_id,
259: sequence,
260: last_updated_by,
261: last_update_date,

Line 300: -- po_online_report_text.

296: --Name: ret_and_del_online_report_rec
297: --Pre-reqs:
298: -- None.
299: --Modifies:
300: -- po_online_report_text.
301: --Locks:
302: -- None.
303: --Function:
304: -- This procedure would return the message_text and message_type

Line 305: -- and would also delete the data from the po_online_report_text.

301: --Locks:
302: -- None.
303: --Function:
304: -- This procedure would return the message_text and message_type
305: -- and would also delete the data from the po_online_report_text.
306: -- As this procedure is an autonomous transaction we would commit
307: -- as soon as we delete
308: --IN:
309: -- p_online_report_id

Line 342: DELETE PO_ONLINE_REPORT_TEXT

338: PO_LOG.proc_begin(d_module);
339: PO_LOG.proc_begin(d_module, 'p_online_report_id', p_online_report_id);
340: END IF;
341: d_pos := 10;
342: DELETE PO_ONLINE_REPORT_TEXT
343: WHERE ONLINE_REPORT_ID = p_online_report_id
344: RETURNING MESSAGE_TYPE, TEXT_LINE
345: BULK COLLECT INTO l_message_type, l_message; /*Bug:13077836 delete is returning more than one row*/
346: d_pos := 20;

Line 358: PO_LOG.event(d_module,d_pos,'Committed after Deleting Record from PO_Online_Report_Text');

354: END IF;
355: COMMIT;
356: d_pos := 30;
357: IF PO_LOG.d_event THEN
358: PO_LOG.event(d_module,d_pos,'Committed after Deleting Record from PO_Online_Report_Text');
359: END IF;
360: IF PO_LOG.d_proc THEN
361: PO_LOG.proc_end(d_module,'x_message_type',x_message_type);
362: PO_LOG.proc_end(d_module,'x_message',x_message);

Line 379: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

375: PROCEDURE copydoc_sql_error(
376: x_routine IN VARCHAR2,
377: x_progress IN VARCHAR2,
378: x_sqlcode IN NUMBER,
379: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
380: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
381: x_line_num IN po_online_report_text.line_num%TYPE,
382: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
383: x_distribution_num IN po_online_report_text.distribution_num%TYPE

Line 380: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

376: x_routine IN VARCHAR2,
377: x_progress IN VARCHAR2,
378: x_sqlcode IN NUMBER,
379: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
380: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
381: x_line_num IN po_online_report_text.line_num%TYPE,
382: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
383: x_distribution_num IN po_online_report_text.distribution_num%TYPE
384: ) IS

Line 381: x_line_num IN po_online_report_text.line_num%TYPE,

377: x_progress IN VARCHAR2,
378: x_sqlcode IN NUMBER,
379: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
380: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
381: x_line_num IN po_online_report_text.line_num%TYPE,
382: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
383: x_distribution_num IN po_online_report_text.distribution_num%TYPE
384: ) IS
385:

Line 382: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

378: x_sqlcode IN NUMBER,
379: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
380: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
381: x_line_num IN po_online_report_text.line_num%TYPE,
382: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
383: x_distribution_num IN po_online_report_text.distribution_num%TYPE
384: ) IS
385:
386: x_message VARCHAR2(240);

Line 383: x_distribution_num IN po_online_report_text.distribution_num%TYPE

379: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
380: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
381: x_line_num IN po_online_report_text.line_num%TYPE,
382: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
383: x_distribution_num IN po_online_report_text.distribution_num%TYPE
384: ) IS
385:
386: x_message VARCHAR2(240);
387:

Line 416: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

412: *************************************************************/
413: PROCEDURE fetch_header(
414: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
415: x_from_po_header_id IN po_headers.po_header_id%TYPE,
416: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
417: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
418: x_return_code OUT NOCOPY NUMBER
419: ) IS
420:

Line 417: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

413: PROCEDURE fetch_header(
414: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
415: x_from_po_header_id IN po_headers.po_header_id%TYPE,
416: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
417: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
418: x_return_code OUT NOCOPY NUMBER
419: ) IS
420:
421: x_progress VARCHAR2(4);

Line 449: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

445: ** create new PO record from info. stored in x_po_header_record
446: ****************************************************************/
447: PROCEDURE insert_header(
448: x_po_header_record IN PO_HEADERS%ROWTYPE,
449: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
450: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
451: x_return_code OUT NOCOPY NUMBER,
452: x_copy_terms IN VARCHAR2 --
453: ) IS

Line 450: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

446: ****************************************************************/
447: PROCEDURE insert_header(
448: x_po_header_record IN PO_HEADERS%ROWTYPE,
449: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
450: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
451: x_return_code OUT NOCOPY NUMBER,
452: x_copy_terms IN VARCHAR2 --
453: ) IS
454:

Line 909: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

905:
906: /** create new line record with info from x_po_line_record **/
907: PROCEDURE insert_line(
908: x_po_line_record IN po_lines%ROWTYPE,
909: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
910: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
911: x_return_code OUT NOCOPY NUMBER
912: ) IS
913:

Line 910: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

906: /** create new line record with info from x_po_line_record **/
907: PROCEDURE insert_line(
908: x_po_line_record IN po_lines%ROWTYPE,
909: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
910: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
911: x_return_code OUT NOCOPY NUMBER
912: ) IS
913:
914: l_progress VARCHAR2(4);

Line 1284: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

1280:
1281:
1282: PROCEDURE insert_shipment(
1283: x_po_shipment_record IN po_line_locations%ROWTYPE,
1284: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1285: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1286: x_line_num IN po_online_report_text.line_num%TYPE,
1287: x_accrue_on_receipt_flag IN VARCHAR2,
1288: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE, -- Bug 2761415

Line 1285: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

1281:
1282: PROCEDURE insert_shipment(
1283: x_po_shipment_record IN po_line_locations%ROWTYPE,
1284: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1285: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1286: x_line_num IN po_online_report_text.line_num%TYPE,
1287: x_accrue_on_receipt_flag IN VARCHAR2,
1288: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE, -- Bug 2761415
1289: x_return_code OUT NOCOPY NUMBER,

Line 1286: x_line_num IN po_online_report_text.line_num%TYPE,

1282: PROCEDURE insert_shipment(
1283: x_po_shipment_record IN po_line_locations%ROWTYPE,
1284: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1285: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1286: x_line_num IN po_online_report_text.line_num%TYPE,
1287: x_accrue_on_receipt_flag IN VARCHAR2,
1288: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE, -- Bug 2761415
1289: x_return_code OUT NOCOPY NUMBER,
1290: p_is_complex_work_po IN BOOLEAN, --

Line 2006: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

2002:
2003:
2004: PROCEDURE insert_distribution(
2005: x_po_distribution_record IN po_distributions%ROWTYPE,
2006: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2007: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2008: x_line_num IN po_online_report_text.line_num%TYPE,
2009: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
2010: x_return_code OUT NOCOPY NUMBER

Line 2007: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

2003:
2004: PROCEDURE insert_distribution(
2005: x_po_distribution_record IN po_distributions%ROWTYPE,
2006: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2007: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2008: x_line_num IN po_online_report_text.line_num%TYPE,
2009: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
2010: x_return_code OUT NOCOPY NUMBER
2011: ) IS

Line 2008: x_line_num IN po_online_report_text.line_num%TYPE,

2004: PROCEDURE insert_distribution(
2005: x_po_distribution_record IN po_distributions%ROWTYPE,
2006: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2007: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2008: x_line_num IN po_online_report_text.line_num%TYPE,
2009: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
2010: x_return_code OUT NOCOPY NUMBER
2011: ) IS
2012:

Line 2009: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

2005: x_po_distribution_record IN po_distributions%ROWTYPE,
2006: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2007: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2008: x_line_num IN po_online_report_text.line_num%TYPE,
2009: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
2010: x_return_code OUT NOCOPY NUMBER
2011: ) IS
2012:
2013: l_progress VARCHAR2(4);

Line 2412: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

2408: x_agent_id IN po_headers.agent_id%TYPE,
2409: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
2410: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
2411: x_copy_attachments IN BOOLEAN,
2412: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2413: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2414: x_return_code OUT NOCOPY NUMBER,
2415: x_copy_terms IN VARCHAR2
2416: ) IS

Line 2413: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

2409: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
2410: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
2411: x_copy_attachments IN BOOLEAN,
2412: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2413: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2414: x_return_code OUT NOCOPY NUMBER,
2415: x_copy_terms IN VARCHAR2
2416: ) IS
2417:

Line 2677: -- The key to PO_ONLINE_REPORT_TEXT where error messages will be added in case

2673: -- The PO_LINE_ID of the new document.
2674: --p_line_num
2675: -- The line number in the document which is being ccopied.
2676: --p_online_report_id
2677: -- The key to PO_ONLINE_REPORT_TEXT where error messages will be added in case
2678: -- of error
2679: --OUT:
2680: --x_sequence
2681: -- The sequence number of the error for this document. It will be incremented

Line 2690: , p_online_report_id IN PO_ONLINE_REPORT_TEXT.online_report_id%TYPE

2686: (
2687: p_orig_po_line_id IN PO_LINES.po_line_id%TYPE
2688: , p_new_po_line_id IN PO_LINES.po_line_id%TYPE
2689: , p_line_num IN PO_LINES.line_num%TYPE
2690: , p_online_report_id IN PO_ONLINE_REPORT_TEXT.online_report_id%TYPE
2691: , x_sequence IN OUT NOCOPY PO_ONLINE_REPORT_TEXT.sequence%TYPE
2692: )
2693: IS
2694: d_mod CONSTANT VARCHAR2(100) := D_copy_attributes;

Line 2691: , x_sequence IN OUT NOCOPY PO_ONLINE_REPORT_TEXT.sequence%TYPE

2687: p_orig_po_line_id IN PO_LINES.po_line_id%TYPE
2688: , p_new_po_line_id IN PO_LINES.po_line_id%TYPE
2689: , p_line_num IN PO_LINES.line_num%TYPE
2690: , p_online_report_id IN PO_ONLINE_REPORT_TEXT.online_report_id%TYPE
2691: , x_sequence IN OUT NOCOPY PO_ONLINE_REPORT_TEXT.sequence%TYPE
2692: )
2693: IS
2694: d_mod CONSTANT VARCHAR2(100) := D_copy_attributes;
2695: l_progress VARCHAR2(4);

Line 2755: -- The key to PO_ONLINE_REPORT_TEXT where error messages will be added in case

2751: -- The PO_LINE_ID of the new document.
2752: --p_line_num
2753: -- The line number in the document which is being ccopied.
2754: --p_online_report_id
2755: -- The key to PO_ONLINE_REPORT_TEXT where error messages will be added in case
2756: -- of error
2757: --OUT:
2758: --x_sequence
2759: -- The sequence number of the error for this document. It will be incremented

Line 2769: , p_online_report_id IN PO_ONLINE_REPORT_TEXT.online_report_id%TYPE

2765: p_orig_po_line_id IN PO_LINES.po_line_id%TYPE
2766: , p_new_po_header_id IN PO_HEADERS.po_header_id%TYPE
2767: , p_new_po_line_id IN PO_LINES.po_line_id%TYPE
2768: , p_line_num IN PO_LINES.line_num%TYPE
2769: , p_online_report_id IN PO_ONLINE_REPORT_TEXT.online_report_id%TYPE
2770: , x_sequence IN OUT NOCOPY PO_ONLINE_REPORT_TEXT.sequence%TYPE
2771: )
2772: IS
2773: d_mod CONSTANT VARCHAR2(100) := D_copy_line_adjustments;

Line 2770: , x_sequence IN OUT NOCOPY PO_ONLINE_REPORT_TEXT.sequence%TYPE

2766: , p_new_po_header_id IN PO_HEADERS.po_header_id%TYPE
2767: , p_new_po_line_id IN PO_LINES.po_line_id%TYPE
2768: , p_line_num IN PO_LINES.line_num%TYPE
2769: , p_online_report_id IN PO_ONLINE_REPORT_TEXT.online_report_id%TYPE
2770: , x_sequence IN OUT NOCOPY PO_ONLINE_REPORT_TEXT.sequence%TYPE
2771: )
2772: IS
2773: d_mod CONSTANT VARCHAR2(100) := D_copy_line_adjustments;
2774: l_api_name CONSTANT varchar2(30) := 'copy_line_adjustments';

Line 2848: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

2844: x_po_header_id IN po_lines.po_header_id%TYPE,
2845: x_from_po_header_id IN po_lines.po_header_id%TYPE,
2846: x_copy_attachments IN BOOLEAN,
2847: x_copy_price IN BOOLEAN,
2848: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2849: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2850: x_return_code OUT NOCOPY NUMBER,
2851: p_is_complex_work_po IN BOOLEAN, --
2852: p_calling_program IN VARCHAR2,

Line 2849: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

2845: x_from_po_header_id IN po_lines.po_header_id%TYPE,
2846: x_copy_attachments IN BOOLEAN,
2847: x_copy_price IN BOOLEAN,
2848: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2849: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2850: x_return_code OUT NOCOPY NUMBER,
2851: p_is_complex_work_po IN BOOLEAN, --
2852: p_calling_program IN VARCHAR2,
2853: p_is_clm_doc IN VARCHAR2 --

Line 3510: x_online_report_id OUT NOCOPY po_online_report_text.online_report_id%TYPE,

3506: x_copy_attachments IN BOOLEAN,
3507: x_copy_price IN BOOLEAN,
3508: x_from_po_header_id IN po_headers.po_header_id%TYPE,
3509: x_to_po_header_id OUT NOCOPY po_headers.po_header_id%TYPE,
3510: x_online_report_id OUT NOCOPY po_online_report_text.online_report_id%TYPE,
3511: x_to_segment1 IN OUT NOCOPY po_headers.segment1%TYPE,
3512: x_agent_id IN po_headers.agent_id%TYPE,
3513: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
3514: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,

Line 3534: x_line_num po_online_report_text.line_num%TYPE := NULL;

3530: x_orig_line_location_id po_line_locations.line_location_id%TYPE;
3531: x_orig_po_distribution_id po_distributions.po_distribution_id%TYPE;
3532:
3533: x_document_num VARCHAR(100);
3534: x_line_num po_online_report_text.line_num%TYPE := NULL;
3535: x_shipment_num po_online_report_text.shipment_num%TYPE := NULL;
3536: x_distribution_num po_online_report_text.distribution_num%TYPE := NULL;
3537:
3538: x_progress VARCHAR2(4);

Line 3535: x_shipment_num po_online_report_text.shipment_num%TYPE := NULL;

3531: x_orig_po_distribution_id po_distributions.po_distribution_id%TYPE;
3532:
3533: x_document_num VARCHAR(100);
3534: x_line_num po_online_report_text.line_num%TYPE := NULL;
3535: x_shipment_num po_online_report_text.shipment_num%TYPE := NULL;
3536: x_distribution_num po_online_report_text.distribution_num%TYPE := NULL;
3537:
3538: x_progress VARCHAR2(4);
3539: x_internal_return_code NUMBER;

Line 3536: x_distribution_num po_online_report_text.distribution_num%TYPE := NULL;

3532:
3533: x_document_num VARCHAR(100);
3534: x_line_num po_online_report_text.line_num%TYPE := NULL;
3535: x_shipment_num po_online_report_text.shipment_num%TYPE := NULL;
3536: x_distribution_num po_online_report_text.distribution_num%TYPE := NULL;
3537:
3538: x_progress VARCHAR2(4);
3539: x_internal_return_code NUMBER;
3540:

Line 3541: x_sequence po_online_report_text.sequence%TYPE := 1;

3537:
3538: x_progress VARCHAR2(4);
3539: x_internal_return_code NUMBER;
3540:
3541: x_sequence po_online_report_text.sequence%TYPE := 1;
3542: /* this is used only for BID quotation to calculate quantity at the line
3543: level from shipments. */
3544: x_line_quantity NUMBER;
3545: x_orig_quotation_class_code po_headers.quotation_class_code%TYPE := NULL;

Line 3592: SELECT po_online_report_text_s.nextval

3588: x_to_po_header_id := NULL;
3589:
3590: x_progress := '000';
3591: BEGIN
3592: SELECT po_online_report_text_s.nextval
3593: INTO x_online_report_id
3594: FROM SYS.DUAL;
3595: EXCEPTION
3596: WHEN OTHERS THEN

Line 4439: l_online_report_id PO_ONLINE_REPORT_TEXT.online_report_id%type;

4435: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%type;
4436: l_inv_org_id FINANCIALS_SYSTEM_PARAMS_ALL.inventory_organization_id%type;
4437: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%type;
4438: l_return_code NUMBER;
4439: l_online_report_id PO_ONLINE_REPORT_TEXT.online_report_id%type;
4440: d_pos NUMBER;
4441: d_module VARCHAR2(70) := 'po.plsql.PO_COPYDOC_S1.VAL_PARAMS_AND_DUPLICATE_DOC';
4442: d_log_msg VARCHAR2(200);
4443: BEGIN