DBA Data[Home] [Help]

APPS.PO_AUTO_LINE_PROCESS_PVT dependencies on STANDARD

Line 1272: -- standard who columns

1268: NVL(intf_lines.line_loc_populated_flag, 'N'),
1269: intf_lines.price_discount ,
1270: intf_lines.terms_id ,
1271: intf_lines.Shipment_Type ,
1272: -- standard who columns
1273: intf_lines.last_updated_by,
1274: intf_lines.last_update_date,
1275: intf_lines.last_update_login,
1276: intf_lines.creation_date,

Line 1488: -- standard who columns

1484: p_lines.poll_intf_pop_flag_tbl,
1485: p_lines.price_discount_tbl,
1486: p_lines.terms_id_tbl,
1487: p_lines.Shipment_Type_tbl,
1488: -- standard who columns
1489: p_lines.last_updated_by_tbl,
1490: p_lines.last_update_date_tbl,
1491: p_lines.last_update_login_tbl,
1492: p_lines.creation_date_tbl,

Line 1778: IF (PO_AUTOCREATE_PARAMS.g_document_type = 'PO' AND PO_AUTOCREATE_PARAMS.g_document_subtype IN ('STANDARD', 'PLANNED', 'RELEASE')) THEN

1774: END IF;
1775:
1776: l_progress := '010';
1777:
1778: IF (PO_AUTOCREATE_PARAMS.g_document_type = 'PO' AND PO_AUTOCREATE_PARAMS.g_document_subtype IN ('STANDARD', 'PLANNED', 'RELEASE')) THEN
1779: g_calculate_tax_flag := 'Y';
1780: END IF;
1781:
1782: l_progress := '020' ;

Line 1887: AND PO_AUTOCREATE_PARAMS.g_document_subtype = 'STANDARD'

1883: -- If called from Sourcing, simply use the rate specified in the interface
1884: -- table.
1885: IF ( PO_AUTOCREATE_PARAMS.g_interface_source_code <> 'SOURCING'
1886: AND PO_AUTOCREATE_PARAMS.g_purchasing_ou_id <> l_requesting_ou_id
1887: AND PO_AUTOCREATE_PARAMS.g_document_subtype = 'STANDARD'
1888: AND NVL (p_lines.clm_info_flag_tbl (i), 'N') <> 'Y' ) THEN
1889: l_progress := '060';
1890: get_rate_for_req_price (p_requesting_ou_id => l_requesting_ou_id,
1891: p_purchasing_ou_id => PO_AUTOCREATE_PARAMS.g_purchasing_ou_id,

Line 1937: IF(PO_AUTOCREATE_PARAMS.g_document_subtype='STANDARD' OR PO_AUTOCREATE_PARAMS.g_document_subtype='PLANNED'

1933: if (PO_AUTOCREATE_PARAMS.g_interface_source_code <> 'SOURCING') then
1934: p_lines.clm_idc_type_tbl(i) := nvl(p_lines.clm_idc_type_tbl(i),'IDC_NA');
1935: end if;
1936:
1937: IF(PO_AUTOCREATE_PARAMS.g_document_subtype='STANDARD' OR PO_AUTOCREATE_PARAMS.g_document_subtype='PLANNED'
1938: OR PO_AUTOCREATE_PARAMS.g_document_subtype = 'BLANKET') THEN
1939:
1940: BEGIN
1941: l_progress := '090';

Line 2023: IF (p_lines.from_line_id_tbl(i) IS NOT NULL) AND (PO_AUTOCREATE_PARAMS.g_document_subtype = 'STANDARD') THEN

2019: -- When autocreating a PO that references a GA, and the req line and
2020: -- GA line have different UOM's, convert to the GA's UOM if the
2021: -- UOM Convert profile is Yes. If UOM Convert is No, do not create
2022: -- this line.
2023: IF (p_lines.from_line_id_tbl(i) IS NOT NULL) AND (PO_AUTOCREATE_PARAMS.g_document_subtype = 'STANDARD') THEN
2024:
2025: l_progress := '110';
2026:
2027: BEGIN

Line 2496: IF( PO_AUTOCREATE_PARAMS.g_document_subtype='STANDARD'

2492: END IF;
2493: END IF;
2494: END IF;
2495:
2496: IF( PO_AUTOCREATE_PARAMS.g_document_subtype='STANDARD'
2497: OR PO_AUTOCREATE_PARAMS.g_document_subtype='PLANNED'
2498: OR PO_AUTOCREATE_PARAMS.g_document_subtype='BLANKET' ) THEN
2499: l_progress :='290';
2500:

Line 2506: -- 1) Autocreating a Standard PO or a BlANKET and pricing is enhanced for the style selected

2502:
2503: l_progress:='300';
2504: -- Call the Pricing API only when...
2505: --
2506: -- 1) Autocreating a Standard PO or a BlANKET and pricing is enhanced for the style selected
2507: -- 2) Source Document exists or the pricing is enhanced for the style selected
2508: -- 3) Not a Consumption Advice
2509: -- 4) Requisition Line's Contractor Status is not 'ASSIGNED'
2510: -- ( if the contractor status is 'ASSIGNED',

Line 2516: IF ( (PO_AUTOCREATE_PARAMS.g_document_subtype = 'STANDARD' OR ( PO_AUTOCREATE_PARAMS.g_document_subtype = 'BLANKET' AND l_enhanced_pricing_flag = 'Y') )

2512: --
2513: -- 5) Not a complex work PO
2514: l_contractor_status := PO_SERVICES_PVT.get_contractor_status(p_lines.requisition_line_id_tbl(i));
2515: -- Enhanced Pricing: Enable pricing call for BLANKET document subtype if pricing enhanced for the style selected
2516: IF ( (PO_AUTOCREATE_PARAMS.g_document_subtype = 'STANDARD' OR ( PO_AUTOCREATE_PARAMS.g_document_subtype = 'BLANKET' AND l_enhanced_pricing_flag = 'Y') )
2517: AND ( p_lines.from_line_id_tbl(i) IS NOT NULL OR p_lines.contract_id_tbl(i) IS NOT NULL OR l_enhanced_pricing_flag = 'Y' )
2518: AND (NVL(p_lines.clm_info_flag_tbl(i),'N')<> 'Y')
2519: AND ( PO_AUTOCREATE_PARAMS.g_interface_source_code <> 'CONSUMPTION_ADVICE' )
2520: AND (NOT po_autocreate_params.g_is_complex_work_po) --

Line 2586: -- If we are Autocreating a Standard PO,

2582: --
2583: END IF;
2584:
2585: /* GA FPI end */
2586: -- If we are Autocreating a Standard PO,
2587: -- then setup the Interface tables to copy over Price Differentials.
2588: IF ( PO_AUTOCREATE_PARAMS.g_document_subtype = 'STANDARD'
2589: AND PO_AUTOCREATE_PARAMS.g_interface_source_code NOT IN ('SOURCING', 'CONSUMPTION_ADVICE')
2590: AND (NOT po_autocreate_params.g_is_complex_work_po)) THEN

Line 2588: IF ( PO_AUTOCREATE_PARAMS.g_document_subtype = 'STANDARD'

2584:
2585: /* GA FPI end */
2586: -- If we are Autocreating a Standard PO,
2587: -- then setup the Interface tables to copy over Price Differentials.
2588: IF ( PO_AUTOCREATE_PARAMS.g_document_subtype = 'STANDARD'
2589: AND PO_AUTOCREATE_PARAMS.g_interface_source_code NOT IN ('SOURCING', 'CONSUMPTION_ADVICE')
2590: AND (NOT po_autocreate_params.g_is_complex_work_po)) THEN
2591:
2592: l_progress := '340';

Line 2727: IF ( PO_AUTOCREATE_PARAMS.g_document_subtype ='STANDARD'

2723: END;
2724:
2725: --
2726: -- IF secondary quantity is null and item is dual uom control , default the secondary qty.
2727: IF ( PO_AUTOCREATE_PARAMS.g_document_subtype ='STANDARD'
2728: OR PO_AUTOCREATE_PARAMS.g_document_subtype='PLANNED'
2729: OR PO_AUTOCREATE_PARAMS.g_document_type = 'PA') THEN
2730: l_progress := '410';
2731: IF p_lines.item_id_tbl(i) IS NOT NULL THEN

Line 3085: IF( PO_AUTOCREATE_PARAMS.g_document_subtype IN ('STANDARD','PLANNED','BLANKET') ) THEN

3081: p_lines.clm_exhibit_name_tbl(i),
3082: p_lines.clm_delivery_event_code_tbl(i)
3083: );
3084:
3085: IF( PO_AUTOCREATE_PARAMS.g_document_subtype IN ('STANDARD','PLANNED','BLANKET') ) THEN
3086: PO_AUTOCREATE_PVT.calculate_local( PO_AUTOCREATE_PARAMS.g_document_subtype, 'LINE', p_lines.po_line_id_tbl(i));
3087: END IF;
3088:
3089: END IF;

Line 3141: IF (PO_AUTOCREATE_PARAMS.g_document_subtype='STANDARD')

3137: END IF;
3138: /*Autocreate grouping end*/
3139:
3140: IF (PO_AUTOCREATE_PARAMS.g_document_type = 'PO') THEN
3141: IF (PO_AUTOCREATE_PARAMS.g_document_subtype='STANDARD')
3142: AND nvl(l_manual_price_change_flag, 'N') <> 'Y'
3143: AND (p_lines.from_line_id_tbl(i) IS NOT NULL OR
3144: --
3145: p_lines.contract_id_tbl(i) IS NOT NULL OR

Line 3303: --new price as on the line for Standard POs.

3299: AND po_line_id = x_po_line_id;
3300:
3301: --- Need to modify the following code to update the proper table. -- serukull
3302: --All the shipments which have been created need to get the
3303: --new price as on the line for Standard POs.
3304: UPDATE po_line_locations_draft_all
3305: SET price_override = nvl(x_unit_price, price_override)
3306: WHERE po_line_id = x_po_line_id
3307: AND draft_id = po_autocreate_params.g_draft_id;