DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_MAINPROC_PVT dependencies on STANDARD

Line 295: IF((PO_AUTOCREATE_PARAMS.g_document_subtype = 'STANDARD' OR PO_AUTOCREATE_PARAMS.g_document_subtype = 'PLANNED') AND PO_AUTOCREATE_PARAMS.g_document_type = 'PO')THEN

291: l_progress := '020';
292: x_ship_to_location_id := get_ship_to_loc(x_deliver_to_location_id); -- FPI
293: x_po_shipment_num := -1;
294:
295: IF((PO_AUTOCREATE_PARAMS.g_document_subtype = 'STANDARD' OR PO_AUTOCREATE_PARAMS.g_document_subtype = 'PLANNED') AND PO_AUTOCREATE_PARAMS.g_document_type = 'PO')THEN
296: l_progress := '030';
297: /* Consigned FPI start : split the following select to determine if a new line
298: is to be created or just a new shipment */
299:

Line 416: AND PLL.SHIPMENT_TYPE IN('STANDARD', 'SCHEDULED', 'BLANKET')

412: WHERE PLL.LINE_LOCATION_ID = x_line_location_to_check
413: AND pll.draft_id =PO_AUTOCREATE_PARAMS.g_draft_id
414: AND PRL.REQUISITION_LINE_ID = x_requisition_line_id
415: AND rtrim(NVL(PLL.note_to_receiver, '99')) = rtrim(NVL(x_note_to_receiver, '99'))
416: AND PLL.SHIPMENT_TYPE IN('STANDARD', 'SCHEDULED', 'BLANKET')
417: AND NVL(PLL.ENCUMBERED_FLAG, 'N') = 'N'
418: AND NVL(PLL.CANCEL_FLAG, 'N') = 'N'
419: AND NVL(psp.org_id, -99) = NVL(po_autocreate_params.g_purchasing_ou_id, -99)
420: AND PLL.ACCRUE_ON_RECEIPT_FLAG = DECODE(l_intf_txn_flow_header_id, NULL, --

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

754: /*
755: ** Get the maximum shipment number in the po tables
756: */
757: l_progress := '020';
758: IF ( PO_AUTOCREATE_PARAMS.g_document_subtype = 'STANDARD'
759: OR PO_AUTOCREATE_PARAMS.g_document_subtype = 'PLANNED'
760: OR PO_AUTOCREATE_PARAMS.g_document_type = 'RFQ' ) THEN
761: /* GA FPI start : if create new line parameter is 'Y' then we need to reset
762: the shipment number and create a new line with one shipment */

Line 763: IF NVL (x_create_new_line, 'N') = 'Y' AND PO_AUTOCREATE_PARAMS.g_document_subtype = 'STANDARD' THEN

759: OR PO_AUTOCREATE_PARAMS.g_document_subtype = 'PLANNED'
760: OR PO_AUTOCREATE_PARAMS.g_document_type = 'RFQ' ) THEN
761: /* GA FPI start : if create new line parameter is 'Y' then we need to reset
762: the shipment number and create a new line with one shipment */
763: IF NVL (x_create_new_line, 'N') = 'Y' AND PO_AUTOCREATE_PARAMS.g_document_subtype = 'STANDARD' THEN
764: x_int_shipment_num := 0;
765: x_shipment_num := 0;
766: l_progress := '030';
767:

Line 802: AND poll.shipment_type IN ('STANDARD', 'PLANNED', 'RFQ');

798: SELECT NVL (MAX (shipment_num), 0)
799: INTO x_shipment_num
800: FROM po_line_locations_all poll --
801: WHERE poll.po_line_id = x_po_line_id
802: AND poll.shipment_type IN ('STANDARD', 'PLANNED', 'RFQ');
803:
804: -- We now check to see if the line_num matches as well by
805: -- appending an AND condition in the WHERE clause.
806: l_progress := '070';

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

949: PO_AUTO_HEADER_PROCESS_PVT.merge_to_org_assign_draft(x_headers);
950:
951: l_progress := '060';
952:
953: IF (PO_AUTOCREATE_PARAMS.g_document_subtype IN ('STANDARD','PLANNED','BLANKET')) THEN
954: PO_AUTOCREATE_PVT.calculate_local(PO_AUTOCREATE_PARAMS.g_document_subtype, 'HEADER', x_headers.po_header_id);
955: END IF;
956:
957: IF g_debug_stmt THEN

Line 1334: IF (x_document_subtype IN ('STANDARD', 'PLANNED')) THEN

1330: -- that we need to get the req line number from.
1331: -- We need to update the shipment number to 1.
1332:
1333: l_progress := '030';
1334: IF (x_document_subtype IN ('STANDARD', 'PLANNED')) THEN
1335: -- For Standard and Planned POs, the line number
1336: -- will be the same as the req line number if the profile
1337: -- is set to 'Y' otherwise use sequential numbers
1338: IF (fnd_profile.VALUE ('PO_USE_REQ_NUM_IN_AUTOCREATE') = 'Y' AND po_autocreate_params.g_interface_source_code <> 'SOURCING') THEN

Line 1335: -- For Standard and Planned POs, the line number

1331: -- We need to update the shipment number to 1.
1332:
1333: l_progress := '030';
1334: IF (x_document_subtype IN ('STANDARD', 'PLANNED')) THEN
1335: -- For Standard and Planned POs, the line number
1336: -- will be the same as the req line number if the profile
1337: -- is set to 'Y' otherwise use sequential numbers
1338: IF (fnd_profile.VALUE ('PO_USE_REQ_NUM_IN_AUTOCREATE') = 'Y' AND po_autocreate_params.g_interface_source_code <> 'SOURCING') THEN
1339:

Line 1411: END IF; -- x_document_subtype IN ('STANDARD', 'PLANNED')

1407: l_sourcing_temp_num := l_sourcing_temp_num + 1;
1408: END LOOP;
1409: END IF; -- po_autocreate_params.g_interface_source_code <> 'SOURCING
1410: END IF; -- if fnd_profile.value(PO_USE_REQ_NUM...) = 'Y'
1411: END IF; -- x_document_subtype IN ('STANDARD', 'PLANNED')
1412:
1413: ELSE
1414: -- mode = 'ADD'
1415: -- add to a po with the same order as on the req.

Line 1416: IF (x_document_subtype IN ('STANDARD', 'PLANNED')) THEN

1412:
1413: ELSE
1414: -- mode = 'ADD'
1415: -- add to a po with the same order as on the req.
1416: IF (x_document_subtype IN ('STANDARD', 'PLANNED')) THEN
1417: -- The inteface table will hold the requisition line id that we
1418: -- will use to get the line number. Select the maximum line number
1419: -- that exists on the purchase order. Update the line number in
1420: -- the interface talbe to be the req. line number + max po line num.

Line 1472: IF (x_document_subtype IN ('STANDARD', 'PLANNED', 'BLANKET')) THEN

1468:
1469: ELSE
1470:
1471: -- g_group_code = 'DEFAULT'
1472: IF (x_document_subtype IN ('STANDARD', 'PLANNED', 'BLANKET')) THEN
1473:
1474: l_progress := '230';
1475: IF g_debug_stmt THEN
1476: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress, p_message => 'Before open interface: Grouping is default' );

Line 2165: END IF; -- If STANDARD/PLANNED/RELEASE

2161: END IF; -- matching line vs. no matching line
2162: END IF; -- Action Type Code
2163: END LOOP;
2164: CLOSE interface_lines;
2165: END IF; -- If STANDARD/PLANNED/RELEASE
2166: END IF; -- of same as REQUISITION mode
2167: END IF; -- of PO mode
2168:
2169: IF g_debug_stmt THEN

Line 2297: PO_AUTO_LINE_LOC_PROCESS_PVT.derive_and_default_line_loc : most for standard po / complex order

2293: NAME: process_line_locations
2294: DESC: Handle the logic to derive, default, validate records from po_line_locations_interface
2295: table and insert records into po_line_locations_draft_all table.
2296: PO_AUTO_LINE_LOC_PROCESS_PVT.fetch_line_loc
2297: PO_AUTO_LINE_LOC_PROCESS_PVT.derive_and_default_line_loc : most for standard po / complex order
2298: (Country of Origin,Inspection Required,Receipt required,match option)
2299: PO_AUTO_LINE_LOC_PROCESS_PVT.validate_line_loc (??)
2300: PO_AUTO_LINE_LOC_PROCESS_PVT.merge_to_line_loc_draft
2301: (Shipments, Pay Items, Price Breaks they can be handled separetly);

Line 2692: p_doc_type => 'STANDARD' ,

2688:
2689: l_progress := '030';
2690: l_target_template_id := PO_UDA_AUTOCREATE_PKG.get_uda_template_id
2691: (p_functional_area => 'PURCHASING' ,
2692: p_doc_type => 'STANDARD' ,
2693: p_doc_level => 'LINE' ,
2694: p_doc_style_id => p_style_id );
2695: IF g_debug_stmt THEN
2696: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name , p_token => l_progress , p_message => 'Target Tempalte ID :' || l_target_template_id );

Line 2831: p_doc_type => 'STANDARD' ,

2827:
2828: l_progress := '020';
2829: l_template_id := PO_UDA_AUTOCREATE_PKG.get_uda_template_id
2830: (p_functional_area => 'PURCHASING' ,
2831: p_doc_type => 'STANDARD' ,
2832: p_doc_level => p_level ,
2833: p_doc_style_id => p_style_id );
2834: IF g_debug_stmt THEN
2835: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'l_template_id : '||l_template_id);