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_LINES

Line 23: CURSOR po_line_cursor(x_po_header_id po_lines.po_header_id%TYPE) IS

19: --
20:
21: -- Cursor definitions:
22:
23: CURSOR po_line_cursor(x_po_header_id po_lines.po_header_id%TYPE) IS
24: SELECT *
25: FROM PO_LINES
26: WHERE po_header_id = x_po_header_id
27: ORDER BY line_num;

Line 25: FROM PO_LINES

21: -- Cursor definitions:
22:
23: CURSOR po_line_cursor(x_po_header_id po_lines.po_header_id%TYPE) IS
24: SELECT *
25: FROM PO_LINES
26: WHERE po_header_id = x_po_header_id
27: ORDER BY line_num;
28:
29: CURSOR po_shipment_cursor(x_po_line_id po_line_locations.po_line_id%TYPE) IS

Line 62: x_po_line_record IN po_lines%ROWTYPE,

58: x_return_code OUT NOCOPY NUMBER,
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: );

Line 113: x_po_line_record IN OUT NOCOPY po_lines%ROWTYPE,

109:
110: PROCEDURE process_line(
111: x_action_code IN VARCHAR2,
112: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
113: x_po_line_record IN OUT NOCOPY po_lines%ROWTYPE,
114: x_orig_po_line_id IN po_lines.po_line_id%TYPE,
115: x_wip_install_status IN VARCHAR2,
116: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
117: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,

Line 114: x_orig_po_line_id IN po_lines.po_line_id%TYPE,

110: PROCEDURE process_line(
111: x_action_code IN VARCHAR2,
112: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
113: x_po_line_record IN OUT NOCOPY po_lines%ROWTYPE,
114: x_orig_po_line_id IN po_lines.po_line_id%TYPE,
115: x_wip_install_status IN VARCHAR2,
116: x_sob_id IN financials_system_parameters.set_of_books_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,

Line 118: x_po_header_id IN po_lines.po_header_id%TYPE,

114: x_orig_po_line_id IN po_lines.po_line_id%TYPE,
115: x_wip_install_status IN VARCHAR2,
116: x_sob_id IN financials_system_parameters.set_of_books_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,

Line 158: p_po_line_rec IN PO_LINES%ROWTYPE,

154: p_generate_new_accounts IN BOOLEAN,
155: p_copy_attachments IN BOOLEAN,
156: p_online_report_id IN NUMBER,
157: p_po_header_rec IN PO_HEADERS%ROWTYPE,
158: p_po_line_rec IN PO_LINES%ROWTYPE,
159: p_po_shipment_rec IN PO_LINE_LOCATIONS%ROWTYPE,
160: p_sob_id IN FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE,
161: x_po_distribution_rec IN OUT NOCOPY PO_DISTRIBUTIONS%ROWTYPE,
162: x_sequence IN OUT NOCOPY NUMBER,

Line 829: x_po_line_record IN po_lines%ROWTYPE,

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

Line 880: INSERT INTO PO_LINES (

876:
877: --
878: -- Added order_type_lookup_code, purchase_basis and matching_basis
879: -- for PO Line level denormalization
880: INSERT INTO PO_LINES (
881: allow_price_override_flag,
882: attribute1,
883: attribute10,
884: attribute11,

Line 1180: l_item_id po_lines.item_id%TYPE := null;

1176: --bug #2717053: changed var names/types to conform to standards
1177: l_vendor_site_id po_headers.vendor_site_id%TYPE := null;
1178: l_to_ship_to_location_id po_line_locations.ship_to_location_id%TYPE;
1179: l_to_ship_to_organization_id po_line_locations.ship_to_organization_id%TYPE;
1180: l_item_id po_lines.item_id%TYPE := null;
1181: l_count number:= 0;
1182: l_quantity po_line_locations.quantity%TYPE;
1183: l_quote_type_code po_headers.quote_type_lookup_code%TYPE := null;
1184:

Line 1223: x_secondary_quantity PO_LINES_ALL.SECONDARY_QUANTITY%TYPE := NULL;

1219: --
1220: l_unit_meas_lookup_code MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE := NULL;
1221: x_secondary_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE := NULL;
1222: x_secondary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE := NULL;
1223: x_secondary_quantity PO_LINES_ALL.SECONDARY_QUANTITY%TYPE := NULL;
1224: --
1225:
1226: -- Bug 4958300
1227: l_line_value_basis PO_LINE_LOCATIONS_ALL.value_basis%type;

Line 1263: from po_lines_all

1259: select item_id, unit_meas_lookup_code,
1260: order_type_lookup_code, matching_basis
1261: into l_item_id, l_unit_meas_lookup_code,
1262: l_line_value_basis, l_line_matching_basis
1263: from po_lines_all
1264: where po_line_id=x_po_shipment_record.po_line_id;
1265:
1266: -- CONSIGNED FPI START
1267: -- Bug Fix for #2697755: COPY PO WITH CONSIGNED SHIPMENT LINE FAILS

Line 2517: p_orig_po_line_id IN PO_LINES.po_line_id%TYPE

2513: --End of Comments
2514: --------------------------------------------------------------------------------
2515: PROCEDURE copy_attributes
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

Line 2518: , p_new_po_line_id IN PO_LINES.po_line_id%TYPE

2514: --------------------------------------------------------------------------------
2515: PROCEDURE copy_attributes
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: )

Line 2519: , p_line_num IN PO_LINES.line_num%TYPE

2515: PROCEDURE copy_attributes
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

Line 2563: x_po_line_record IN OUT NOCOPY po_lines%ROWTYPE,

2559:
2560: PROCEDURE process_line(
2561: x_action_code IN VARCHAR2,
2562: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
2563: x_po_line_record IN OUT NOCOPY po_lines%ROWTYPE,
2564: x_orig_po_line_id IN po_lines.po_line_id%TYPE,
2565: x_wip_install_status IN VARCHAR2,
2566: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
2567: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,

Line 2564: x_orig_po_line_id IN po_lines.po_line_id%TYPE,

2560: PROCEDURE process_line(
2561: x_action_code IN VARCHAR2,
2562: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
2563: x_po_line_record IN OUT NOCOPY po_lines%ROWTYPE,
2564: x_orig_po_line_id IN po_lines.po_line_id%TYPE,
2565: x_wip_install_status IN VARCHAR2,
2566: x_sob_id IN financials_system_parameters.set_of_books_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,

Line 2568: x_po_header_id IN po_lines.po_header_id%TYPE,

2564: x_orig_po_line_id IN po_lines.po_line_id%TYPE,
2565: x_wip_install_status IN VARCHAR2,
2566: x_sob_id IN financials_system_parameters.set_of_books_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,

Line 2629: fnd_attached_documents2_pkg.copy_attachments('PO_LINES',

2625: IF (x_internal_return_code = 0) THEN
2626: IF (x_copy_attachments) THEN
2627: l_progress := '030';
2628:
2629: fnd_attached_documents2_pkg.copy_attachments('PO_LINES',
2630: x_orig_po_line_id,
2631: '',
2632: '',
2633: '',

Line 2635: 'PO_LINES',

2631: '',
2632: '',
2633: '',
2634: '',
2635: 'PO_LINES',
2636: x_po_line_record.po_line_id,
2637: '',
2638: '',
2639: '',

Line 2821: select item_id into l_item_id from po_lines

2817: from po_system_parameters;
2818:
2819: l_progress := '060';
2820:
2821: select item_id into l_item_id from po_lines
2822: where po_line_id = p_po_line_id;
2823:
2824:
2825: if l_item_id is not NULL then

Line 2982: p_po_line_rec IN PO_LINES%ROWTYPE,

2978: p_generate_new_accounts IN BOOLEAN,
2979: p_copy_attachments IN BOOLEAN,
2980: p_online_report_id IN NUMBER,
2981: p_po_header_rec IN PO_HEADERS%ROWTYPE,
2982: p_po_line_rec IN PO_LINES%ROWTYPE,
2983: p_po_shipment_rec IN PO_LINE_LOCATIONS%ROWTYPE,
2984: p_sob_id IN FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE,
2985: x_po_distribution_rec IN OUT NOCOPY PO_DISTRIBUTIONS%ROWTYPE,
2986: x_sequence IN OUT NOCOPY NUMBER,

Line 2996: l_line_id PO_LINES_ALL.po_line_id%TYPE;

2992: l_internal_return_code NUMBER := NULL;
2993: l_return_status VARCHAR2(1);
2994:
2995: --: use local vars for this to handle BPA case
2996: l_line_id PO_LINES_ALL.po_line_id%TYPE;
2997: l_line_num PO_LINES_ALL.line_num%TYPE;
2998: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
2999: l_shipment_num PO_LINE_LOCATIONS_ALL.shipment_num%TYPE;
3000: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;

Line 2997: l_line_num PO_LINES_ALL.line_num%TYPE;

2993: l_return_status VARCHAR2(1);
2994:
2995: --: use local vars for this to handle BPA case
2996: l_line_id PO_LINES_ALL.po_line_id%TYPE;
2997: l_line_num PO_LINES_ALL.line_num%TYPE;
2998: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
2999: l_shipment_num PO_LINE_LOCATIONS_ALL.shipment_num%TYPE;
3000: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
3001:

Line 3192: x_po_line_record po_lines%ROWTYPE;

3188:
3189: COPYDOC_FATAL EXCEPTION;
3190:
3191: x_po_header_record PO_HEADERS%ROWTYPE;
3192: x_po_line_record po_lines%ROWTYPE;
3193: x_po_shipment_record po_line_locations%ROWTYPE;
3194: x_po_distribution_record po_distributions%ROWTYPE;
3195:
3196: x_orig_po_line_id po_lines.po_line_id%TYPE;

Line 3196: x_orig_po_line_id po_lines.po_line_id%TYPE;

3192: x_po_line_record po_lines%ROWTYPE;
3193: x_po_shipment_record po_line_locations%ROWTYPE;
3194: x_po_distribution_record po_distributions%ROWTYPE;
3195:
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;

Line 3524: UPDATE PO_LINES

3520: /* got total quantity from all shipments under the line */
3521: IF (x_orig_quotation_class_code = 'BID') THEN
3522: x_progress := '090';
3523:
3524: UPDATE PO_LINES
3525: SET quantity = x_line_quantity
3526: WHERE po_header_id = x_to_po_header_id
3527: AND po_line_id = x_po_line_record.po_line_id;
3528:

Line 3676: FROM po_lines

3672:
3673: BEGIN
3674:
3675: SELECT count(*) INTO l_has_config_id
3676: FROM po_lines
3677: WHERE po_header_id = p_po_header_id AND
3678: supplier_ref_number IS NOT NULL;
3679:
3680: IF (l_has_config_id = 0) THEN