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 146: x_orig_po_header_id po_lines.po_header_id%TYPE := NULL;

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

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

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

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

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

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

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

Line 168: x_secondary_quantity_fsp po_lines.quantity%type;

164: x_quote_sub_type po_headers.quote_type_lookup_code%type;
165: --
166: x_secondary_unit_fsp MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
167: x_secondary_uom_fsp MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
168: x_secondary_quantity_fsp po_lines.quantity%type;
169: --
170:
171: --Bug 16559524
172: x_valid_flag VARCHAR2(2);

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

291: END IF;
292: --Bug 16559524 End
293:
294: /* store original info */
295: -- bug877084: don't need to override in po_lines
296:
297: SELECT po_header_id
298: INTO x_orig_po_header_id
299: FROM po_lines

Line 299: FROM po_lines

295: -- bug877084: don't need to override in po_lines
296:
297: SELECT po_header_id
298: INTO x_orig_po_header_id
299: FROM po_lines
300: WHERE po_line_id = x_orig_po_line_id;
301:
302: /* 1780903 : When a bid quotation is copied to a standard or planned PO
303: we need to copy the quote reference to the PO . For this we copy the

Line 362: FROM po_lines

358: -- the blanket is either copied or left blank.
359: begin
360: SELECT unit_price
361: INTO x_blanket_price
362: FROM po_lines
363: WHERE po_header_id = x_orig_po_header_id
364: AND po_line_id = x_orig_po_line_id;
365: exception
366: when others then

Line 584: SELECT po_lines_s.nextval

580: x_po_line_record.po_header_id := x_po_header_id;
581:
582: x_progress := '001';
583: BEGIN
584: SELECT po_lines_s.nextval
585: INTO x_po_line_record.po_line_id
586: FROM SYS.DUAL;
587: EXCEPTION
588: WHEN OTHERS THEN