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 26: CURSOR po_line_cursor(x_po_header_id po_lines.po_header_id%TYPE) IS

22: D_copy_line_adjustments CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'copy_line_adjustments');
23:
24: -- Cursor definitions:
25:
26: CURSOR po_line_cursor(x_po_header_id po_lines.po_header_id%TYPE) IS
27: SELECT *
28: FROM PO_LINES
29: WHERE po_header_id = x_po_header_id
30: ORDER BY line_num;

Line 28: FROM PO_LINES

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

Line 47: CURSOR clm_po_line_cursor(x_po_header_id po_lines.po_header_id%TYPE) IS

43: AND distribution_type <> 'AGREEMENT' --bug 3338216: filter BPA dists
44: ORDER BY distribution_num;
45:
46: -- CLM CLIN/SLIN Changes
47: CURSOR clm_po_line_cursor(x_po_header_id po_lines.po_header_id%TYPE) IS
48: SELECT DISTINCT group_line_id
49: FROM PO_LINES
50: WHERE po_header_id = x_po_header_id
51: AND group_line_id IS NOT NULL

Line 49: FROM PO_LINES

45:
46: -- CLM CLIN/SLIN Changes
47: CURSOR clm_po_line_cursor(x_po_header_id po_lines.po_header_id%TYPE) IS
48: SELECT DISTINCT group_line_id
49: FROM PO_LINES
50: WHERE po_header_id = x_po_header_id
51: AND group_line_id IS NOT NULL
52: UNION
53: SELECT DISTINCT clm_base_line_num

Line 54: FROM PO_LINES

50: WHERE po_header_id = x_po_header_id
51: AND group_line_id IS NOT NULL
52: UNION
53: SELECT DISTINCT clm_base_line_num
54: FROM PO_LINES
55: WHERE po_header_id = x_po_header_id
56: AND clm_base_line_num IS NOT NULL;
57:
58: CURSOR clm_po_distribution_cursor(x_po_header_id po_lines.po_header_id%TYPE) IS

Line 58: CURSOR clm_po_distribution_cursor(x_po_header_id po_lines.po_header_id%TYPE) IS

54: FROM PO_LINES
55: WHERE po_header_id = x_po_header_id
56: AND clm_base_line_num IS NOT NULL;
57:
58: CURSOR clm_po_distribution_cursor(x_po_header_id po_lines.po_header_id%TYPE) IS
59: SELECT DISTINCT group_line_id
60: FROM PO_DISTRIBUTIONS
61: WHERE po_header_id = x_po_header_id
62: AND distribution_type <> 'AGREEMENT'

Line 84: x_po_line_record IN po_lines%ROWTYPE,

80: x_return_code OUT NOCOPY NUMBER,
81: x_copy_terms IN VARCHAR2 --
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: );

Line 135: x_po_line_record IN OUT NOCOPY po_lines%ROWTYPE,

131:
132: PROCEDURE process_line(
133: x_action_code IN VARCHAR2,
134: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
135: x_po_line_record IN OUT NOCOPY po_lines%ROWTYPE,
136: x_orig_po_line_id IN po_lines.po_line_id%TYPE,
137: x_wip_install_status IN VARCHAR2,
138: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
139: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,

Line 136: x_orig_po_line_id IN po_lines.po_line_id%TYPE,

132: PROCEDURE process_line(
133: x_action_code IN VARCHAR2,
134: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
135: x_po_line_record IN OUT NOCOPY po_lines%ROWTYPE,
136: x_orig_po_line_id IN po_lines.po_line_id%TYPE,
137: x_wip_install_status IN VARCHAR2,
138: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
139: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
140: x_po_header_id IN po_lines.po_header_id%TYPE,

Line 140: x_po_header_id IN po_lines.po_header_id%TYPE,

136: x_orig_po_line_id IN po_lines.po_line_id%TYPE,
137: x_wip_install_status IN VARCHAR2,
138: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
139: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
140: x_po_header_id IN po_lines.po_header_id%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,

Line 141: x_from_po_header_id IN po_lines.po_header_id%TYPE,

137: x_wip_install_status IN VARCHAR2,
138: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
139: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
140: x_po_header_id IN po_lines.po_header_id%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,

Line 183: p_po_line_rec IN PO_LINES%ROWTYPE,

179: p_generate_new_accounts IN BOOLEAN,
180: p_copy_attachments IN BOOLEAN,
181: p_online_report_id IN NUMBER,
182: p_po_header_rec IN PO_HEADERS%ROWTYPE,
183: p_po_line_rec IN PO_LINES%ROWTYPE,
184: p_po_shipment_rec IN PO_LINE_LOCATIONS%ROWTYPE,
185: p_sob_id IN FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE,
186: x_po_distribution_rec IN OUT NOCOPY PO_DISTRIBUTIONS%ROWTYPE,
187: x_sequence IN OUT NOCOPY NUMBER,

Line 908: x_po_line_record IN po_lines%ROWTYPE,

904:
905:
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

Line 962: INSERT INTO PO_LINES (

958:
959: --
960: -- Added order_type_lookup_code, purchase_basis and matching_basis
961: -- for PO Line level denormalization
962: INSERT INTO PO_LINES (
963: allow_price_override_flag,
964: attribute1,
965: attribute10,
966: attribute11,

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

1296: --bug #2717053: changed var names/types to conform to standards
1297: l_vendor_site_id po_headers.vendor_site_id%TYPE := null;
1298: l_to_ship_to_location_id po_line_locations.ship_to_location_id%TYPE;
1299: l_to_ship_to_organization_id po_line_locations.ship_to_organization_id%TYPE;
1300: l_item_id po_lines.item_id%TYPE := null;
1301: l_count number:= 0;
1302: l_quantity po_line_locations.quantity%TYPE;
1303: l_quote_type_code po_headers.quote_type_lookup_code%TYPE := null;
1304:

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

1339: --
1340: l_unit_meas_lookup_code MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE := NULL;
1341: x_secondary_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE := NULL;
1342: x_secondary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE := NULL;
1343: x_secondary_quantity PO_LINES_ALL.SECONDARY_QUANTITY%TYPE := NULL;
1344: --
1345:
1346: -- Bug 4958300
1347: l_line_value_basis PO_LINE_LOCATIONS_ALL.value_basis%type;

Line 1351: l_clm_delivery_event_code po_lines_all.clm_delivery_event_code%type;

1347: l_line_value_basis PO_LINE_LOCATIONS_ALL.value_basis%type;
1348: l_line_matching_basis PO_LINE_LOCATIONS_ALL.matching_basis%type;
1349: --
1350:
1351: l_clm_delivery_event_code po_lines_all.clm_delivery_event_code%type;
1352:
1353: BEGIN
1354:
1355: l_progress := '000';

Line 1383: -- Take clm_delivery_event_code from po_lines

1379: --:added UOM to select below
1380: -- bug 4958300: added value basis/matching basis
1381:
1382: --
1383: -- Take clm_delivery_event_code from po_lines
1384: -- Update Need By Date and Promised Date only if delivery event is not used.
1385:
1386: select item_id, unit_meas_lookup_code,
1387: order_type_lookup_code, matching_basis,

Line 1392: from po_lines_all

1388: clm_delivery_event_code
1389: into l_item_id, l_unit_meas_lookup_code,
1390: l_line_value_basis, l_line_matching_basis,
1391: l_clm_delivery_event_code
1392: from po_lines_all
1393: where po_line_id=x_po_shipment_record.po_line_id;
1394:
1395: -- CONSIGNED FPI START
1396: -- Bug Fix for #2697755: COPY PO WITH CONSIGNED SHIPMENT LINE FAILS

Line 2687: p_orig_po_line_id IN PO_LINES.po_line_id%TYPE

2683: --End of Comments
2684: --------------------------------------------------------------------------------
2685: PROCEDURE copy_attributes
2686: (
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

Line 2688: , p_new_po_line_id IN PO_LINES.po_line_id%TYPE

2684: --------------------------------------------------------------------------------
2685: PROCEDURE copy_attributes
2686: (
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: )

Line 2689: , p_line_num IN PO_LINES.line_num%TYPE

2685: PROCEDURE copy_attributes
2686: (
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

Line 2765: p_orig_po_line_id IN PO_LINES.po_line_id%TYPE

2761: --End of Comments
2762: --------------------------------------------------------------------------------
2763: PROCEDURE copy_line_adjustments
2764: (
2765: p_orig_po_line_id IN PO_LINES.po_line_id%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

Line 2767: , p_new_po_line_id IN PO_LINES.po_line_id%TYPE

2763: PROCEDURE copy_line_adjustments
2764: (
2765: p_orig_po_line_id IN PO_LINES.po_line_id%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: )

Line 2768: , p_line_num IN PO_LINES.line_num%TYPE

2764: (
2765: p_orig_po_line_id IN PO_LINES.po_line_id%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

Line 2839: x_po_line_record IN OUT NOCOPY po_lines%ROWTYPE,

2835:
2836: PROCEDURE process_line(
2837: x_action_code IN VARCHAR2,
2838: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
2839: x_po_line_record IN OUT NOCOPY po_lines%ROWTYPE,
2840: x_orig_po_line_id IN po_lines.po_line_id%TYPE,
2841: x_wip_install_status IN VARCHAR2,
2842: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
2843: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,

Line 2840: x_orig_po_line_id IN po_lines.po_line_id%TYPE,

2836: PROCEDURE process_line(
2837: x_action_code IN VARCHAR2,
2838: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
2839: x_po_line_record IN OUT NOCOPY po_lines%ROWTYPE,
2840: x_orig_po_line_id IN po_lines.po_line_id%TYPE,
2841: x_wip_install_status IN VARCHAR2,
2842: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
2843: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
2844: x_po_header_id IN po_lines.po_header_id%TYPE,

Line 2844: x_po_header_id IN po_lines.po_header_id%TYPE,

2840: x_orig_po_line_id IN po_lines.po_line_id%TYPE,
2841: x_wip_install_status IN VARCHAR2,
2842: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
2843: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
2844: x_po_header_id IN po_lines.po_header_id%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,

Line 2845: x_from_po_header_id IN po_lines.po_header_id%TYPE,

2841: x_wip_install_status IN VARCHAR2,
2842: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
2843: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
2844: x_po_header_id IN po_lines.po_header_id%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,

Line 2920: FROM po_lines_all

2916: IF (Nvl(x_po_line_record.CLM_OPTION_INDICATOR,' ') LIKE 'B') THEN
2917:
2918: SELECT Decode(Count(po_line_id),0,NULL,'B')
2919: INTO x_po_line_record.CLM_OPTION_INDICATOR
2920: FROM po_lines_all
2921: WHERE po_header_id = x_from_po_header_id
2922: AND CLM_BASE_LINE_NUM =x_orig_po_line_id
2923: AND Nvl(CLM_EXERCISED_FLAG,'N') = 'N' ;
2924:

Line 2954: fnd_attached_documents2_pkg.copy_attachments('PO_LINES',

2950: IF (x_internal_return_code = 0) THEN
2951: IF (x_copy_attachments) THEN
2952: l_progress := '030';
2953:
2954: fnd_attached_documents2_pkg.copy_attachments('PO_LINES',
2955: x_orig_po_line_id,
2956: '',
2957: '',
2958: '',

Line 2960: 'PO_LINES',

2956: '',
2957: '',
2958: '',
2959: '',
2960: 'PO_LINES',
2961: x_po_line_record.po_line_id,
2962: '',
2963: '',
2964: '',

Line 3154: select item_id into l_item_id from po_lines

3150: from po_system_parameters;
3151:
3152: l_progress := '060';
3153:
3154: select item_id into l_item_id from po_lines
3155: where po_line_id = p_po_line_id;
3156:
3157:
3158: if l_item_id is not NULL then

Line 3315: p_po_line_rec IN PO_LINES%ROWTYPE,

3311: p_generate_new_accounts IN BOOLEAN,
3312: p_copy_attachments IN BOOLEAN,
3313: p_online_report_id IN NUMBER,
3314: p_po_header_rec IN PO_HEADERS%ROWTYPE,
3315: p_po_line_rec IN PO_LINES%ROWTYPE,
3316: p_po_shipment_rec IN PO_LINE_LOCATIONS%ROWTYPE,
3317: p_sob_id IN FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE,
3318: x_po_distribution_rec IN OUT NOCOPY PO_DISTRIBUTIONS%ROWTYPE,
3319: x_sequence IN OUT NOCOPY NUMBER,

Line 3329: l_line_id PO_LINES_ALL.po_line_id%TYPE;

3325: l_internal_return_code NUMBER := NULL;
3326: l_return_status VARCHAR2(1);
3327:
3328: --: use local vars for this to handle BPA case
3329: l_line_id PO_LINES_ALL.po_line_id%TYPE;
3330: l_line_num PO_LINES_ALL.line_num%TYPE;
3331: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
3332: l_shipment_num PO_LINE_LOCATIONS_ALL.shipment_num%TYPE;
3333: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;

Line 3330: l_line_num PO_LINES_ALL.line_num%TYPE;

3326: l_return_status VARCHAR2(1);
3327:
3328: --: use local vars for this to handle BPA case
3329: l_line_id PO_LINES_ALL.po_line_id%TYPE;
3330: l_line_num PO_LINES_ALL.line_num%TYPE;
3331: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
3332: l_shipment_num PO_LINE_LOCATIONS_ALL.shipment_num%TYPE;
3333: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
3334:

Line 3525: x_po_line_record po_lines%ROWTYPE;

3521:
3522: COPYDOC_FATAL EXCEPTION;
3523:
3524: x_po_header_record PO_HEADERS%ROWTYPE;
3525: x_po_line_record po_lines%ROWTYPE;
3526: x_po_shipment_record po_line_locations%ROWTYPE;
3527: x_po_distribution_record po_distributions%ROWTYPE;
3528:
3529: x_orig_po_line_id po_lines.po_line_id%TYPE;

Line 3529: x_orig_po_line_id po_lines.po_line_id%TYPE;

3525: x_po_line_record po_lines%ROWTYPE;
3526: x_po_shipment_record po_line_locations%ROWTYPE;
3527: x_po_distribution_record po_distributions%ROWTYPE;
3528:
3529: x_orig_po_line_id po_lines.po_line_id%TYPE;
3530: x_orig_line_location_id po_line_locations.line_location_id%TYPE;
3531: x_orig_po_distribution_id po_distributions.po_distribution_id%TYPE;
3532:
3533: x_document_num VARCHAR(100);

Line 3561: l_cursor_group_line_id po_lines.po_line_id%TYPE;

3557:
3558: l_is_complex_work_po BOOLEAN; --
3559:
3560: -- CLM CLIN/SLIN Changes
3561: l_cursor_group_line_id po_lines.po_line_id%TYPE;
3562: l_group_line_id po_lines.po_line_id%TYPE;
3563: l_line_num_display po_lines.line_num_display%TYPE;
3564: l_line_num po_lines.line_num%TYPE;
3565: l_cursor_line_id po_lines.po_line_id%TYPE;

Line 3562: l_group_line_id po_lines.po_line_id%TYPE;

3558: l_is_complex_work_po BOOLEAN; --
3559:
3560: -- CLM CLIN/SLIN Changes
3561: l_cursor_group_line_id po_lines.po_line_id%TYPE;
3562: l_group_line_id po_lines.po_line_id%TYPE;
3563: l_line_num_display po_lines.line_num_display%TYPE;
3564: l_line_num po_lines.line_num%TYPE;
3565: l_cursor_line_id po_lines.po_line_id%TYPE;
3566: l_clm_line_id po_lines.po_line_id%TYPE;

Line 3563: l_line_num_display po_lines.line_num_display%TYPE;

3559:
3560: -- CLM CLIN/SLIN Changes
3561: l_cursor_group_line_id po_lines.po_line_id%TYPE;
3562: l_group_line_id po_lines.po_line_id%TYPE;
3563: l_line_num_display po_lines.line_num_display%TYPE;
3564: l_line_num po_lines.line_num%TYPE;
3565: l_cursor_line_id po_lines.po_line_id%TYPE;
3566: l_clm_line_id po_lines.po_line_id%TYPE;
3567:

Line 3564: l_line_num po_lines.line_num%TYPE;

3560: -- CLM CLIN/SLIN Changes
3561: l_cursor_group_line_id po_lines.po_line_id%TYPE;
3562: l_group_line_id po_lines.po_line_id%TYPE;
3563: l_line_num_display po_lines.line_num_display%TYPE;
3564: l_line_num po_lines.line_num%TYPE;
3565: l_cursor_line_id po_lines.po_line_id%TYPE;
3566: l_clm_line_id po_lines.po_line_id%TYPE;
3567:
3568: l_template_id NUMBER;

Line 3565: l_cursor_line_id po_lines.po_line_id%TYPE;

3561: l_cursor_group_line_id po_lines.po_line_id%TYPE;
3562: l_group_line_id po_lines.po_line_id%TYPE;
3563: l_line_num_display po_lines.line_num_display%TYPE;
3564: l_line_num po_lines.line_num%TYPE;
3565: l_cursor_line_id po_lines.po_line_id%TYPE;
3566: l_clm_line_id po_lines.po_line_id%TYPE;
3567:
3568: l_template_id NUMBER;
3569: l_match_val VARCHAR2(2);

Line 3566: l_clm_line_id po_lines.po_line_id%TYPE;

3562: l_group_line_id po_lines.po_line_id%TYPE;
3563: l_line_num_display po_lines.line_num_display%TYPE;
3564: l_line_num po_lines.line_num%TYPE;
3565: l_cursor_line_id po_lines.po_line_id%TYPE;
3566: l_clm_line_id po_lines.po_line_id%TYPE;
3567:
3568: l_template_id NUMBER;
3569: l_match_val VARCHAR2(2);
3570: l_clm_src_doc_id NUMBER;

Line 4050: UPDATE PO_LINES

4046: -- Modified the condition for Bug 9783916 ,now this block is for BID, Std PO and Planned PO
4047: IF (x_orig_quotation_class_code = 'BID' OR (x_action_code='PO' AND (x_to_doc_subtype = 'STANDARD' OR x_to_doc_subtype = 'PLANNED'))) THEN
4048: x_progress := '090';
4049:
4050: UPDATE PO_LINES
4051: SET quantity = x_line_quantity
4052: WHERE po_header_id = x_to_po_header_id
4053: AND po_line_id = x_po_line_record.po_line_id;
4054:

Line 4087: (SELECT nw.po_line_id FROM po_lines nw ,po_lines od

4083: exhibit_name,
4084: exhibit_description,
4085: is_cdrl,
4086: x_to_po_header_id,
4087: (SELECT nw.po_line_id FROM po_lines nw ,po_lines od
4088: WHERE nw.po_header_id = x_to_po_header_id
4089: AND nw.line_num = od.line_num
4090: AND nw.line_num_display = od.line_num_display
4091: AND od.po_header_id = x_from_po_header_id

Line 4115: FROM po_lines

4111: EXIT CLMLINES WHEN clm_po_line_cursor%NOTFOUND;
4112:
4113: SELECT line_num_display, line_num
4114: INTO l_line_num_display, l_line_num
4115: FROM po_lines
4116: WHERE po_header_id = x_from_po_header_id AND
4117: po_line_id = l_cursor_line_id AND ROWNUM =1 ;
4118:
4119: SELECT po_line_id

Line 4121: FROM po_lines

4117: po_line_id = l_cursor_line_id AND ROWNUM =1 ;
4118:
4119: SELECT po_line_id
4120: INTO l_clm_line_id
4121: FROM po_lines
4122: WHERE po_header_id = x_to_po_header_id AND
4123: line_num = l_line_num AND
4124: line_num_display = l_line_num_display AND ROWNUM =1 ;
4125:

Line 4126: UPDATE PO_LINES

4122: WHERE po_header_id = x_to_po_header_id AND
4123: line_num = l_line_num AND
4124: line_num_display = l_line_num_display AND ROWNUM =1 ;
4125:
4126: UPDATE PO_LINES
4127: SET group_line_id = Decode(group_line_id, l_cursor_line_id, l_clm_line_id, group_line_id),
4128: clm_base_line_num = Decode(clm_base_line_num, l_cursor_line_id, l_clm_line_id, clm_base_line_num)
4129: WHERE po_header_id = x_to_po_header_id AND
4130: ((group_line_id IS NOT NULL AND

Line 4147: FROM po_lines

4143: EXIT CLMDISTRIBUTIONS WHEN clm_po_distribution_cursor%NOTFOUND;
4144:
4145: SELECT line_num_display, line_num
4146: INTO l_line_num_display, l_line_num
4147: FROM po_lines
4148: WHERE po_header_id = x_from_po_header_id AND
4149: po_line_id = l_cursor_group_line_id AND ROWNUM =1 ;
4150:
4151: SELECT po_line_id

Line 4153: FROM po_lines

4149: po_line_id = l_cursor_group_line_id AND ROWNUM =1 ;
4150:
4151: SELECT po_line_id
4152: INTO l_group_line_id
4153: FROM po_lines
4154: WHERE po_header_id = x_to_po_header_id AND
4155: line_num = l_line_num AND
4156: line_num_display = l_line_num_display AND ROWNUM =1 ;
4157:

Line 4308: FROM po_lines

4304:
4305: BEGIN
4306:
4307: SELECT count(*) INTO l_has_config_id
4308: FROM po_lines
4309: WHERE po_header_id = p_po_header_id AND
4310: supplier_ref_number IS NOT NULL;
4311:
4312: IF (l_has_config_id = 0) THEN

Line 4641: ,x_po_line_record IN OUT NOCOPY po_lines%ROWTYPE

4637: ,p_from_po_header_id IN NUMBER
4638: ,p_from_pk_value IN NUMBER
4639: ,p_to_pk_value IN NUMBER
4640: ,x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE
4641: ,x_po_line_record IN OUT NOCOPY po_lines%ROWTYPE
4642: ,x_po_shipment_record IN OUT NOCOPY PO_LINE_LOCATIONS%ROWTYPE
4643: ,x_po_distribution_rec IN OUT NOCOPY PO_DISTRIBUTIONS%ROWTYPE
4644: ,x_return_status OUT NOCOPY VARCHAR2
4645: ,x_msg_count OUT NOCOPY NUMBER

Line 4663: l_clm_delivery_event_code po_lines_all.clm_delivery_event_code%type;

4659: l_api_name CONSTANT varchar2(30) := 'COPY_UDA_ATTRS';
4660: l_log_head CONSTANT VARCHAR2(100) := 'po_copydoc_s1';
4661: l_pk_col_name VARCHAR2(200);
4662:
4663: l_clm_delivery_event_code po_lines_all.clm_delivery_event_code%type;
4664:
4665: BEGIN
4666: l_progress := '8880';
4667: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Starting code for UDA Submission check');

Line 4720: UPDATE PO_LINES_ALL

4716: ELSIF p_level = 'LINE' THEN
4717:
4718: IF PO_CLM_CLO_UTIL.Isclminstalled THEN
4719:
4720: UPDATE PO_LINES_ALL
4721: SET uda_template_id = x_po_line_record.uda_template_id,
4722: clm_min_total_amount = x_po_line_record.clm_min_total_amount,
4723: clm_max_total_amount = x_po_line_record.clm_max_total_amount,
4724: clm_min_total_quantity = x_po_line_record.clm_min_total_quantity,

Line 4744: FROM po_lines_all

4740:
4741:
4742: SELECT UDA_TEMPLATE_ID
4743: INTO l_template_id
4744: FROM po_lines_all
4745: WHERE PO_LINE_ID = p_from_pk_value;
4746:
4747: IF l_template_id IS NULL THEN
4748: RETURN;

Line 4758: -- Take clm_delivery_event_code from po_lines

4754:
4755: IF PO_CLM_CLO_UTIL.Isclminstalled THEN
4756:
4757: --
4758: -- Take clm_delivery_event_code from po_lines
4759: -- Update POP Dates only if delivery event is not used.
4760:
4761: SELECT pl.CLM_DELIVERY_EVENT_CODE
4762: INTO l_clm_delivery_event_code

Line 4763: FROM po_lines_all pl, po_line_locations_all pll

4759: -- Update POP Dates only if delivery event is not used.
4760:
4761: SELECT pl.CLM_DELIVERY_EVENT_CODE
4762: INTO l_clm_delivery_event_code
4763: FROM po_lines_all pl, po_line_locations_all pll
4764: WHERE pll.LINE_LOCATION_ID = p_from_pk_value
4765: AND pll.po_line_id = pl.po_line_id;
4766:
4767: UPDATE PO_LINE_LOCATIONS_ALL