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_S

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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