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