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_S3 dependencies on PO_LINES

Line 11: x_line_type_id IN OUT NOCOPY po_lines.line_type_id%TYPE,

7:
8: -- Private function prototypes
9:
10: PROCEDURE validate_line_type_id(
11: x_line_type_id IN OUT NOCOPY po_lines.line_type_id%TYPE,
12: x_wip_install_status IN VARCHAR2,
13: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
14: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
15: x_line_num IN po_online_report_text.line_num%TYPE,

Line 20: x_transaction_reason_code IN OUT NOCOPY po_lines.transaction_reason_code%TYPE,

16: x_return_code OUT NOCOPY NUMBER
17: );
18:
19: PROCEDURE validate_trx_reason_code(
20: x_transaction_reason_code IN OUT NOCOPY po_lines.transaction_reason_code%TYPE,
21: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
22: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
23: x_line_num IN po_online_report_text.line_num%TYPE,
24: x_return_code OUT NOCOPY NUMBER

Line 29: x_line_type_id IN OUT NOCOPY po_lines.line_type_id%TYPE,

25: );
26: -- End of Private function prototypes
27:
28: PROCEDURE validate_line_type_id(
29: x_line_type_id IN OUT NOCOPY po_lines.line_type_id%TYPE,
30: x_wip_install_status IN VARCHAR2,
31: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
32: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
33: x_line_num IN po_online_report_text.line_num%TYPE,

Line 73: x_transaction_reason_code IN OUT NOCOPY po_lines.transaction_reason_code%TYPE,

69:
70:
71:
72: PROCEDURE validate_trx_reason_code(
73: x_transaction_reason_code IN OUT NOCOPY po_lines.transaction_reason_code%TYPE,
74: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
75: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
76: x_line_num IN po_online_report_text.line_num%TYPE,
77: x_return_code OUT NOCOPY NUMBER

Line 128: x_po_line_record IN OUT NOCOPY po_lines%ROWTYPE,

124: *************************************************************/
125: PROCEDURE validate_line(
126: x_action_code IN VARCHAR2,
127: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
128: x_po_line_record IN OUT NOCOPY po_lines%ROWTYPE,
129: x_orig_po_line_id IN po_lines.po_line_id%TYPE,
130: x_wip_install_status IN VARCHAR2,
131: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
132: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,

Line 129: x_orig_po_line_id IN po_lines.po_line_id%TYPE,

125: PROCEDURE validate_line(
126: x_action_code IN VARCHAR2,
127: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
128: x_po_line_record IN OUT NOCOPY po_lines%ROWTYPE,
129: x_orig_po_line_id IN po_lines.po_line_id%TYPE,
130: x_wip_install_status IN VARCHAR2,
131: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
132: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
133: x_po_header_id IN po_lines.po_header_id%TYPE,

Line 133: x_po_header_id IN po_lines.po_header_id%TYPE,

129: x_orig_po_line_id IN po_lines.po_line_id%TYPE,
130: x_wip_install_status IN VARCHAR2,
131: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
132: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
133: x_po_header_id IN po_lines.po_header_id%TYPE,
134: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
135: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
136: x_copy_price IN BOOLEAN,
137: x_return_code OUT NOCOPY NUMBER,

Line 145: x_orig_po_header_id po_lines.po_header_id%TYPE := NULL;

141: COPYDOC_LINE_FAILURE EXCEPTION;
142: x_progress VARCHAR2(4) := NULL;
143: x_internal_return_code NUMBER := NULL;
144: x_quotation_class_code VARCHAR2(10) := NULL;
145: x_orig_po_header_id po_lines.po_header_id%TYPE := NULL;
146: x_qty po_lines.quantity%type := NULL;
147: x_blanket_price po_lines.unit_price%type := NULL;
148: x_order_type_lookup_code po_line_types.order_type_lookup_code%type;
149: -- start of 1548597

Line 146: x_qty po_lines.quantity%type := NULL;

142: x_progress VARCHAR2(4) := NULL;
143: x_internal_return_code NUMBER := NULL;
144: x_quotation_class_code VARCHAR2(10) := NULL;
145: x_orig_po_header_id po_lines.po_header_id%TYPE := NULL;
146: x_qty po_lines.quantity%type := NULL;
147: x_blanket_price po_lines.unit_price%type := NULL;
148: x_order_type_lookup_code po_line_types.order_type_lookup_code%type;
149: -- start of 1548597
150: x_secondary_qty po_lines.secondary_quantity%type := NULL;

Line 147: x_blanket_price po_lines.unit_price%type := NULL;

143: x_internal_return_code NUMBER := NULL;
144: x_quotation_class_code VARCHAR2(10) := NULL;
145: x_orig_po_header_id po_lines.po_header_id%TYPE := NULL;
146: x_qty po_lines.quantity%type := NULL;
147: x_blanket_price po_lines.unit_price%type := NULL;
148: x_order_type_lookup_code po_line_types.order_type_lookup_code%type;
149: -- start of 1548597
150: x_secondary_qty po_lines.secondary_quantity%type := NULL;
151: x_item_number VARCHAR2(240);

Line 150: x_secondary_qty po_lines.secondary_quantity%type := NULL;

146: x_qty po_lines.quantity%type := NULL;
147: x_blanket_price po_lines.unit_price%type := NULL;
148: x_order_type_lookup_code po_line_types.order_type_lookup_code%type;
149: -- start of 1548597
150: x_secondary_qty po_lines.secondary_quantity%type := NULL;
151: x_item_number VARCHAR2(240);
152: x_process_org VARCHAR2(1);
153: x_dummy VARCHAR2(240);
154: x_product VARCHAR2(3) := 'GMI';

Line 167: x_secondary_quantity_fsp po_lines.quantity%type;

163: x_quote_sub_type po_headers.quote_type_lookup_code%type;
164: --
165: x_secondary_unit_fsp MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
166: x_secondary_uom_fsp MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
167: x_secondary_quantity_fsp po_lines.quantity%type;
168: --
169:
170: BEGIN
171:

Line 203: -- bug877084: don't need to override in po_lines

199: task_id (?)
200: ******/
201:
202: /* store original info */
203: -- bug877084: don't need to override in po_lines
204:
205: SELECT po_header_id
206: INTO x_orig_po_header_id
207: FROM po_lines

Line 207: FROM po_lines

203: -- bug877084: don't need to override in po_lines
204:
205: SELECT po_header_id
206: INTO x_orig_po_header_id
207: FROM po_lines
208: WHERE po_line_id = x_orig_po_line_id;
209:
210: /* 1780903 : When a bid quotation is copied to a standard or planned PO
211: we need to copy the quote reference to the PO . For this we copy the

Line 267: FROM po_lines

263: -- the blanket is either copied or left blank.
264: begin
265: SELECT unit_price
266: INTO x_blanket_price
267: FROM po_lines
268: WHERE po_header_id = x_orig_po_header_id
269: AND po_line_id = x_orig_po_line_id;
270: exception
271: when others then

Line 483: SELECT po_lines_s.nextval

479: x_po_line_record.po_header_id := x_po_header_id;
480:
481: x_progress := '001';
482: BEGIN
483: SELECT po_lines_s.nextval
484: INTO x_po_line_record.po_line_id
485: FROM SYS.DUAL;
486: EXCEPTION
487: WHEN OTHERS THEN