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 50: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

46:
47: PROCEDURE fetch_header(
48: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
49: x_from_po_header_id IN po_headers.po_header_id%TYPE,
50: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
51: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
52: x_return_code OUT NOCOPY NUMBER
53: );
54: PROCEDURE insert_header(

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

47: PROCEDURE fetch_header(
48: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
49: x_from_po_header_id IN po_headers.po_header_id%TYPE,
50: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
51: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
52: x_return_code OUT NOCOPY NUMBER
53: );
54: PROCEDURE insert_header(
55: x_po_header_record IN PO_HEADERS%ROWTYPE,

Line 56: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

52: x_return_code OUT NOCOPY NUMBER
53: );
54: PROCEDURE insert_header(
55: x_po_header_record IN PO_HEADERS%ROWTYPE,
56: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
57: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
58: x_return_code OUT NOCOPY NUMBER,
59: x_copy_terms IN VARCHAR2 --
60: );

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

53: );
54: PROCEDURE insert_header(
55: x_po_header_record IN PO_HEADERS%ROWTYPE,
56: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
57: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
58: x_return_code OUT NOCOPY NUMBER,
59: x_copy_terms IN VARCHAR2 --
60: );
61: PROCEDURE insert_line(

Line 63: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

59: x_copy_terms IN VARCHAR2 --
60: );
61: PROCEDURE insert_line(
62: x_po_line_record IN po_lines%ROWTYPE,
63: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
64: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
65: x_return_code OUT NOCOPY NUMBER
66: );
67:

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

60: );
61: PROCEDURE insert_line(
62: x_po_line_record IN po_lines%ROWTYPE,
63: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
64: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
65: x_return_code OUT NOCOPY NUMBER
66: );
67:
68: PROCEDURE insert_shipment(

Line 70: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

66: );
67:
68: PROCEDURE insert_shipment(
69: x_po_shipment_record IN po_line_locations%ROWTYPE,
70: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
71: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
72: x_line_num IN po_online_report_text.line_num%TYPE,
73: x_accrue_on_receipt_flag IN VARCHAR2,
74: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE, -- Bug 2761415

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

67:
68: PROCEDURE insert_shipment(
69: x_po_shipment_record IN po_line_locations%ROWTYPE,
70: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
71: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
72: x_line_num IN po_online_report_text.line_num%TYPE,
73: x_accrue_on_receipt_flag IN VARCHAR2,
74: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE, -- Bug 2761415
75: x_return_code OUT NOCOPY NUMBER,

Line 72: x_line_num IN po_online_report_text.line_num%TYPE,

68: PROCEDURE insert_shipment(
69: x_po_shipment_record IN po_line_locations%ROWTYPE,
70: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
71: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
72: x_line_num IN po_online_report_text.line_num%TYPE,
73: x_accrue_on_receipt_flag IN VARCHAR2,
74: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE, -- Bug 2761415
75: x_return_code OUT NOCOPY NUMBER,
76: p_is_complex_work_po IN BOOLEAN, --

Line 82: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

78: );
79:
80: PROCEDURE insert_distribution(
81: x_po_distribution_record IN po_distributions%ROWTYPE,
82: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
83: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
84: x_line_num IN po_online_report_text.line_num%TYPE,
85: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
86: x_return_code OUT NOCOPY NUMBER

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

79:
80: PROCEDURE insert_distribution(
81: x_po_distribution_record IN po_distributions%ROWTYPE,
82: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
83: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
84: x_line_num IN po_online_report_text.line_num%TYPE,
85: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
86: x_return_code OUT NOCOPY NUMBER
87: );

Line 84: x_line_num IN po_online_report_text.line_num%TYPE,

80: PROCEDURE insert_distribution(
81: x_po_distribution_record IN po_distributions%ROWTYPE,
82: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
83: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
84: x_line_num IN po_online_report_text.line_num%TYPE,
85: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
86: x_return_code OUT NOCOPY NUMBER
87: );
88:

Line 85: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

81: x_po_distribution_record IN po_distributions%ROWTYPE,
82: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
83: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
84: x_line_num IN po_online_report_text.line_num%TYPE,
85: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
86: x_return_code OUT NOCOPY NUMBER
87: );
88:
89: PROCEDURE handle_fatal(

Line 104: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

100: x_agent_id IN po_headers.agent_id%TYPE,
101: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
102: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
103: x_copy_attachments IN BOOLEAN,
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_return_code OUT NOCOPY NUMBER,
107: x_copy_terms IN VARCHAR2 --
108: );

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

101: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
102: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
103: x_copy_attachments IN BOOLEAN,
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_return_code OUT NOCOPY NUMBER,
107: x_copy_terms IN VARCHAR2 --
108: );
109:

Line 121: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

117: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
118: x_po_header_id IN po_lines.po_header_id%TYPE,
119: x_copy_attachments IN BOOLEAN,
120: x_copy_price IN BOOLEAN,
121: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
122: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
123: x_return_code OUT NOCOPY NUMBER,
124: p_is_complex_work_po IN BOOLEAN --
125: );

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

118: x_po_header_id IN po_lines.po_header_id%TYPE,
119: x_copy_attachments IN BOOLEAN,
120: x_copy_price IN BOOLEAN,
121: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
122: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
123: x_return_code OUT NOCOPY NUMBER,
124: p_is_complex_work_po IN BOOLEAN --
125: );
126:

Line 194: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

190: -- Making this procedure a autonomous transaction so that even if copy doc
191: -- fails we should get the error
192: --
193: PROCEDURE online_report(
194: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
195: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
196: x_message IN po_online_report_text.text_line%TYPE,
197: x_line_num IN po_online_report_text.line_num%TYPE,
198: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

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

191: -- fails we should get the error
192: --
193: PROCEDURE online_report(
194: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
195: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
196: x_message IN po_online_report_text.text_line%TYPE,
197: x_line_num IN po_online_report_text.line_num%TYPE,
198: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
199: x_distribution_num IN po_online_report_text.distribution_num%TYPE,

Line 196: x_message IN po_online_report_text.text_line%TYPE,

192: --
193: PROCEDURE online_report(
194: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
195: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
196: x_message IN po_online_report_text.text_line%TYPE,
197: x_line_num IN po_online_report_text.line_num%TYPE,
198: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
199: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
200: x_message_type IN VARCHAR2 --

Line 197: x_line_num IN po_online_report_text.line_num%TYPE,

193: PROCEDURE online_report(
194: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
195: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
196: x_message IN po_online_report_text.text_line%TYPE,
197: x_line_num IN po_online_report_text.line_num%TYPE,
198: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
199: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
200: x_message_type IN VARCHAR2 --
201: ) IS

Line 198: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

194: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
195: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
196: x_message IN po_online_report_text.text_line%TYPE,
197: x_line_num IN po_online_report_text.line_num%TYPE,
198: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
199: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
200: x_message_type IN VARCHAR2 --
201: ) IS
202: pragma AUTONOMOUS_TRANSACTION; --

Line 199: x_distribution_num IN po_online_report_text.distribution_num%TYPE,

195: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
196: x_message IN po_online_report_text.text_line%TYPE,
197: x_line_num IN po_online_report_text.line_num%TYPE,
198: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
199: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
200: x_message_type IN VARCHAR2 --
201: ) IS
202: pragma AUTONOMOUS_TRANSACTION; --
203: x_text_line po_online_report_text.text_line%TYPE := NULL;

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

199: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
200: x_message_type IN VARCHAR2 --
201: ) IS
202: pragma AUTONOMOUS_TRANSACTION; --
203: x_text_line po_online_report_text.text_line%TYPE := NULL;
204: x_line_num_msg VARCHAR2(100) := NULL;
205: x_shipment_num_msg VARCHAR2(100) := NULL;
206: x_distribution_num_msg VARCHAR2(100) := NULL;
207: --

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

204: x_line_num_msg VARCHAR2(100) := NULL;
205: x_shipment_num_msg VARCHAR2(100) := NULL;
206: x_distribution_num_msg VARCHAR2(100) := NULL;
207: --
208: -- Increased x_text_line_length to 2000 (length of PO_ONLINE_REPORT_TEXT.text_line);
209: -- changed substr to substrb below to handle multibyte characters.
210: x_text_line_length NUMBER := 2000;
211:
212: BEGIN

Line 234: INSERT INTO PO_ONLINE_REPORT_TEXT (

230:
231: x_text_line := substrb(x_text_line || x_message, 1, x_text_line_length);
232:
233: BEGIN
234: INSERT INTO PO_ONLINE_REPORT_TEXT (
235: online_report_id,
236: sequence,
237: last_updated_by,
238: last_update_date,

Line 277: -- po_online_report_text.

273: --Name: ret_and_del_online_report_rec
274: --Pre-reqs:
275: -- None.
276: --Modifies:
277: -- po_online_report_text.
278: --Locks:
279: -- None.
280: --Function:
281: -- This procedure would return the message_text and message_type

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

278: --Locks:
279: -- None.
280: --Function:
281: -- This procedure would return the message_text and message_type
282: -- and would also delete the data from the po_online_report_text.
283: -- As this procedure is an autonomous transaction we would commit
284: -- as soon as we delete
285: --IN:
286: -- p_online_report_id

Line 313: DELETE PO_ONLINE_REPORT_TEXT

309: PO_LOG.proc_begin(d_module);
310: PO_LOG.proc_begin(d_module, 'p_online_report_id', p_online_report_id);
311: END IF;
312: d_pos := 10;
313: DELETE PO_ONLINE_REPORT_TEXT
314: WHERE ONLINE_REPORT_ID = p_online_report_id
315: RETURNING MESSAGE_TYPE, TEXT_LINE
316: INTO x_message_type, x_message;
317: d_pos := 20;

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

321: END IF;
322: COMMIT;
323: d_pos := 30;
324: IF PO_LOG.d_event THEN
325: PO_LOG.event(d_module,d_pos,'Committed after Deleting Record from PO_Online_Report_Text');
326: END IF;
327: IF PO_LOG.d_proc THEN
328: PO_LOG.proc_end(d_module,'x_message_type',x_message_type);
329: PO_LOG.proc_end(d_module,'x_message',x_message);

Line 346: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

342: PROCEDURE copydoc_sql_error(
343: x_routine IN VARCHAR2,
344: x_progress IN VARCHAR2,
345: x_sqlcode IN NUMBER,
346: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
347: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
348: x_line_num IN po_online_report_text.line_num%TYPE,
349: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
350: x_distribution_num IN po_online_report_text.distribution_num%TYPE

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

343: x_routine IN VARCHAR2,
344: x_progress IN VARCHAR2,
345: x_sqlcode IN NUMBER,
346: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
347: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
348: x_line_num IN po_online_report_text.line_num%TYPE,
349: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
350: x_distribution_num IN po_online_report_text.distribution_num%TYPE
351: ) IS

Line 348: x_line_num IN po_online_report_text.line_num%TYPE,

344: x_progress IN VARCHAR2,
345: x_sqlcode IN NUMBER,
346: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
347: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
348: x_line_num IN po_online_report_text.line_num%TYPE,
349: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
350: x_distribution_num IN po_online_report_text.distribution_num%TYPE
351: ) IS
352:

Line 349: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

345: x_sqlcode IN NUMBER,
346: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
347: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
348: x_line_num IN po_online_report_text.line_num%TYPE,
349: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
350: x_distribution_num IN po_online_report_text.distribution_num%TYPE
351: ) IS
352:
353: x_message VARCHAR2(240);

Line 350: x_distribution_num IN po_online_report_text.distribution_num%TYPE

346: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
347: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
348: x_line_num IN po_online_report_text.line_num%TYPE,
349: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
350: x_distribution_num IN po_online_report_text.distribution_num%TYPE
351: ) IS
352:
353: x_message VARCHAR2(240);
354:

Line 383: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

379: *************************************************************/
380: PROCEDURE fetch_header(
381: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
382: x_from_po_header_id IN po_headers.po_header_id%TYPE,
383: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
384: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
385: x_return_code OUT NOCOPY NUMBER
386: ) IS
387:

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

380: PROCEDURE fetch_header(
381: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
382: x_from_po_header_id IN po_headers.po_header_id%TYPE,
383: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
384: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
385: x_return_code OUT NOCOPY NUMBER
386: ) IS
387:
388: x_progress VARCHAR2(4);

Line 416: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

412: ** create new PO record from info. stored in x_po_header_record
413: ****************************************************************/
414: PROCEDURE insert_header(
415: x_po_header_record IN PO_HEADERS%ROWTYPE,
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: x_copy_terms IN VARCHAR2 --
420: ) IS

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

413: ****************************************************************/
414: PROCEDURE insert_header(
415: x_po_header_record IN PO_HEADERS%ROWTYPE,
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: x_copy_terms IN VARCHAR2 --
420: ) IS
421:

Line 830: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

826:
827: /** create new line record with info from x_po_line_record **/
828: PROCEDURE insert_line(
829: x_po_line_record IN po_lines%ROWTYPE,
830: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
831: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
832: x_return_code OUT NOCOPY NUMBER
833: ) IS
834:

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

827: /** create new line record with info from x_po_line_record **/
828: PROCEDURE insert_line(
829: x_po_line_record IN po_lines%ROWTYPE,
830: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
831: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
832: x_return_code OUT NOCOPY NUMBER
833: ) IS
834:
835: l_progress VARCHAR2(4);

Line 1164: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

1160:
1161:
1162: PROCEDURE insert_shipment(
1163: x_po_shipment_record IN po_line_locations%ROWTYPE,
1164: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1165: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1166: x_line_num IN po_online_report_text.line_num%TYPE,
1167: x_accrue_on_receipt_flag IN VARCHAR2,
1168: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE, -- Bug 2761415

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

1161:
1162: PROCEDURE insert_shipment(
1163: x_po_shipment_record IN po_line_locations%ROWTYPE,
1164: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1165: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1166: x_line_num IN po_online_report_text.line_num%TYPE,
1167: x_accrue_on_receipt_flag IN VARCHAR2,
1168: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE, -- Bug 2761415
1169: x_return_code OUT NOCOPY NUMBER,

Line 1166: x_line_num IN po_online_report_text.line_num%TYPE,

1162: PROCEDURE insert_shipment(
1163: x_po_shipment_record IN po_line_locations%ROWTYPE,
1164: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1165: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1166: x_line_num IN po_online_report_text.line_num%TYPE,
1167: x_accrue_on_receipt_flag IN VARCHAR2,
1168: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE, -- Bug 2761415
1169: x_return_code OUT NOCOPY NUMBER,
1170: p_is_complex_work_po IN BOOLEAN, --

Line 1858: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

1854:
1855:
1856: PROCEDURE insert_distribution(
1857: x_po_distribution_record IN po_distributions%ROWTYPE,
1858: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1859: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1860: x_line_num IN po_online_report_text.line_num%TYPE,
1861: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1862: x_return_code OUT NOCOPY NUMBER

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

1855:
1856: PROCEDURE insert_distribution(
1857: x_po_distribution_record IN po_distributions%ROWTYPE,
1858: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1859: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1860: x_line_num IN po_online_report_text.line_num%TYPE,
1861: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1862: x_return_code OUT NOCOPY NUMBER
1863: ) IS

Line 1860: x_line_num IN po_online_report_text.line_num%TYPE,

1856: PROCEDURE insert_distribution(
1857: x_po_distribution_record IN po_distributions%ROWTYPE,
1858: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1859: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1860: x_line_num IN po_online_report_text.line_num%TYPE,
1861: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1862: x_return_code OUT NOCOPY NUMBER
1863: ) IS
1864:

Line 1861: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

1857: x_po_distribution_record IN po_distributions%ROWTYPE,
1858: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1859: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1860: x_line_num IN po_online_report_text.line_num%TYPE,
1861: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1862: x_return_code OUT NOCOPY NUMBER
1863: ) IS
1864:
1865: l_progress VARCHAR2(4);

Line 2242: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

2238: x_agent_id IN po_headers.agent_id%TYPE,
2239: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
2240: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
2241: x_copy_attachments IN BOOLEAN,
2242: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2243: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2244: x_return_code OUT NOCOPY NUMBER,
2245: x_copy_terms IN VARCHAR2
2246: ) IS

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

2239: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
2240: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
2241: x_copy_attachments IN BOOLEAN,
2242: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2243: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2244: x_return_code OUT NOCOPY NUMBER,
2245: x_copy_terms IN VARCHAR2
2246: ) IS
2247:

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

2503: -- The PO_LINE_ID of the new document.
2504: --p_line_num
2505: -- The line number in the document which is being ccopied.
2506: --p_online_report_id
2507: -- The key to PO_ONLINE_REPORT_TEXT where error messages will be added in case
2508: -- of error
2509: --OUT:
2510: --x_sequence
2511: -- The sequence number of the error for this document. It will be incremented

Line 2520: , p_online_report_id IN PO_ONLINE_REPORT_TEXT.online_report_id%TYPE

2516: (
2517: p_orig_po_line_id IN PO_LINES.po_line_id%TYPE
2518: , p_new_po_line_id IN PO_LINES.po_line_id%TYPE
2519: , p_line_num IN PO_LINES.line_num%TYPE
2520: , p_online_report_id IN PO_ONLINE_REPORT_TEXT.online_report_id%TYPE
2521: , x_sequence IN OUT NOCOPY PO_ONLINE_REPORT_TEXT.sequence%TYPE
2522: )
2523: IS
2524: d_mod CONSTANT VARCHAR2(100) := D_copy_attributes;

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

2517: p_orig_po_line_id IN PO_LINES.po_line_id%TYPE
2518: , p_new_po_line_id IN PO_LINES.po_line_id%TYPE
2519: , p_line_num IN PO_LINES.line_num%TYPE
2520: , p_online_report_id IN PO_ONLINE_REPORT_TEXT.online_report_id%TYPE
2521: , x_sequence IN OUT NOCOPY PO_ONLINE_REPORT_TEXT.sequence%TYPE
2522: )
2523: IS
2524: d_mod CONSTANT VARCHAR2(100) := D_copy_attributes;
2525: l_progress VARCHAR2(4);

Line 2571: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

2567: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
2568: x_po_header_id IN po_lines.po_header_id%TYPE,
2569: x_copy_attachments IN BOOLEAN,
2570: x_copy_price IN BOOLEAN,
2571: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2572: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2573: x_return_code OUT NOCOPY NUMBER,
2574: p_is_complex_work_po IN BOOLEAN --
2575: ) IS

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

2568: x_po_header_id IN po_lines.po_header_id%TYPE,
2569: x_copy_attachments IN BOOLEAN,
2570: x_copy_price IN BOOLEAN,
2571: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2572: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2573: x_return_code OUT NOCOPY NUMBER,
2574: p_is_complex_work_po IN BOOLEAN --
2575: ) IS
2576:

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

3173: x_copy_attachments IN BOOLEAN,
3174: x_copy_price IN BOOLEAN,
3175: x_from_po_header_id IN po_headers.po_header_id%TYPE,
3176: x_to_po_header_id OUT NOCOPY po_headers.po_header_id%TYPE,
3177: x_online_report_id OUT NOCOPY po_online_report_text.online_report_id%TYPE,
3178: x_to_segment1 IN OUT NOCOPY po_headers.segment1%TYPE,
3179: x_agent_id IN po_headers.agent_id%TYPE,
3180: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
3181: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,

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

3196: x_orig_po_line_id po_lines.po_line_id%TYPE;
3197: x_orig_line_location_id po_line_locations.line_location_id%TYPE;
3198: x_orig_po_distribution_id po_distributions.po_distribution_id%TYPE;
3199:
3200: x_line_num po_online_report_text.line_num%TYPE := NULL;
3201: x_shipment_num po_online_report_text.shipment_num%TYPE := NULL;
3202: x_distribution_num po_online_report_text.distribution_num%TYPE := NULL;
3203:
3204: x_progress VARCHAR2(4);

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

3197: x_orig_line_location_id po_line_locations.line_location_id%TYPE;
3198: x_orig_po_distribution_id po_distributions.po_distribution_id%TYPE;
3199:
3200: x_line_num po_online_report_text.line_num%TYPE := NULL;
3201: x_shipment_num po_online_report_text.shipment_num%TYPE := NULL;
3202: x_distribution_num po_online_report_text.distribution_num%TYPE := NULL;
3203:
3204: x_progress VARCHAR2(4);
3205: x_internal_return_code NUMBER;

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

3198: x_orig_po_distribution_id po_distributions.po_distribution_id%TYPE;
3199:
3200: x_line_num po_online_report_text.line_num%TYPE := NULL;
3201: x_shipment_num po_online_report_text.shipment_num%TYPE := NULL;
3202: x_distribution_num po_online_report_text.distribution_num%TYPE := NULL;
3203:
3204: x_progress VARCHAR2(4);
3205: x_internal_return_code NUMBER;
3206:

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

3203:
3204: x_progress VARCHAR2(4);
3205: x_internal_return_code NUMBER;
3206:
3207: x_sequence po_online_report_text.sequence%TYPE := 1;
3208: /* this is used only for BID quotation to calculate quantity at the line
3209: level from shipments. */
3210: x_line_quantity NUMBER;
3211: x_orig_quotation_class_code po_headers.quotation_class_code%TYPE := NULL;

Line 3239: SELECT po_online_report_text_s.nextval

3235: x_to_po_header_id := NULL;
3236:
3237: x_progress := '000';
3238: BEGIN
3239: SELECT po_online_report_text_s.nextval
3240: INTO x_online_report_id
3241: FROM SYS.DUAL;
3242: EXCEPTION
3243: WHEN OTHERS THEN

Line 3807: l_online_report_id PO_ONLINE_REPORT_TEXT.online_report_id%type;

3803: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%type;
3804: l_inv_org_id FINANCIALS_SYSTEM_PARAMS_ALL.inventory_organization_id%type;
3805: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%type;
3806: l_return_code NUMBER;
3807: l_online_report_id PO_ONLINE_REPORT_TEXT.online_report_id%type;
3808: d_pos NUMBER;
3809: d_module VARCHAR2(70) := 'po.plsql.PO_COPYDOC_S1.VAL_PARAMS_AND_DUPLICATE_DOC';
3810: d_log_msg VARCHAR2(200);
3811: BEGIN