DBA Data[Home] [Help]

APPS.PO_PDOI_PREPROC_PVT dependencies on STANDARD

Line 118: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD

114:
115: PO_TIMING_UTL.start_time (PO_PDOI_CONSTANTS.g_T_PREPROCESSING);
116:
117: IF (PO_PDOI_PARAMS.g_request.document_type <>
118: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD
119: AND
120: PO_PDOI_PARAMS.g_request.process_code =
121: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED) THEN
122:

Line 524: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

520: END IF;
521:
522: d_position := 70;
523: IF (PO_PDOI_PARAMS.g_request.document_type =
524: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
525: FORALL i IN 1..l_intf_line_id_tbl.COUNT
526: UPDATE po_distributions_interface
527: SET processing_id = PO_PDOI_PARAMS.g_processing_id
528: WHERE interface_line_id = l_intf_line_id_tbl(i);

Line 538: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

534: END IF;
535:
536: d_position := 80;
537: IF (PO_PDOI_PARAMS.g_request.document_type <>
538: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
539:
540: d_position := 90;
541: FORALL i IN 1..l_intf_line_id_tbl.COUNT
542: UPDATE po_attr_values_interface

Line 714: (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD AND

710: PO_PDOI_CONSTANTS.g_ACTION_ADD,
711: PO_PDOI_CONSTANTS.g_ACTION_REPLACE,
712: PO_PDOI_CONSTANTS.g_ACTION_UPDATE))
713: OR
714: (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD AND
715: action NOT IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
716: PO_PDOI_CONSTANTS.g_ACTION_ADD,
717: PO_PDOI_CONSTANTS.g_ACTION_UPDATE)));
718:

Line 727: IF (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD

723: l_reject_tbl.COUNT);
724: END IF;
725:
726: FOR i IN 1..l_reject_tbl.COUNT LOOP
727: IF (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD
728: AND
729: l_action_tbl(i) = PO_PDOI_CONSTANTS.g_ACTION_REPLACE) THEN
730:
731: l_message_name := 'PO_PDOI_STD_ACTION';

Line 1457: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN

1453:
1454: IF (l_valid = FND_API.g_TRUE) THEN
1455: IF (PO_PDOI_PARAMS.g_request.document_type IN
1456: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1457: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN
1458:
1459: d_position := 40;
1460:
1461: PO_PDOI_UTL.get_processing_doctype_info

Line 1495: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

1491: IF (l_valid <> FND_API.g_TRUE) THEN
1492: d_position := 70;
1493:
1494: IF (PO_PDOI_PARAMS.g_request.document_type =
1495: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
1496: l_message_name := 'PO_PDOI_INVALID_ORIG_STD_PO';
1497: ELSE
1498: l_message_name := 'PO_PDOI_INVALID_ORIG_CATALOG';
1499: END IF;

Line 1537: (PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,

1533: IF (l_vendor_doc_num_tbl(i) IS NOT NULL) THEN
1534: -- Definitely need to match vendor doc num. Matching document num
1535: -- will be performed, if provided
1536: IF (PO_PDOI_PARAMS.g_request.document_type IN
1537: (PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
1538: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET)) THEN
1539:
1540: d_position := 90;
1541: SELECT POH.po_header_id,

Line 1551: AND (POH.type_lookup_code = 'STANDARD'

1547: WHERE POH.vendor_id = l_vendor_id_tbl(i)
1548: AND POH.vendor_order_num = l_vendor_doc_num_tbl(i)
1549: AND POH.segment1 = NVL(l_document_num_tbl(i), POH.segment1)
1550: AND POH.type_lookup_code = PO_PDOI_PARAMS.g_request.document_type
1551: AND (POH.type_lookup_code = 'STANDARD'
1552: OR
1553: (POH.type_lookup_code = 'BLANKET'
1554: AND TRUNC(NVL(l_start_date_tbl(i), SYSDATE)) >=
1555: TRUNC(NVL(POH.start_date, SYSDATE))

Line 1590: (PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,

1586: -- Definitely need to match document num. Matching vendor doc num
1587: -- will be performed, if provided
1588:
1589: IF (PO_PDOI_PARAMS.g_request.document_type IN
1590: (PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
1591: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET)) THEN
1592:
1593: SELECT POH.po_header_id,
1594: NVL(POH.consigned_consumption_flag, 'N')

Line 1605: AND (POH.type_lookup_code = 'STANDARD'

1601: NVL(l_vendor_doc_num_tbl(i),
1602: NVL(POH.vendor_order_num, FND_API.G_MISS_CHAR))
1603: AND POH.segment1 = l_document_num_tbl(i)
1604: AND POH.type_lookup_code = PO_PDOI_PARAMS.g_request.document_type
1605: AND (POH.type_lookup_code = 'STANDARD'
1606: OR
1607: (POH.type_lookup_code = 'BLANKET'
1608: AND TRUNC(NVL(l_start_date_tbl(i), SYSDATE)) >=
1609: TRUNC(NVL(POH.start_date, SYSDATE))

Line 1659: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

1655:
1656: IF (l_orig_po_header_id_tbl.COUNT <> 1) THEN
1657: IF (l_orig_po_header_id_tbl.COUNT = 0) THEN
1658: IF (PO_PDOI_PARAMS.g_request.document_type =
1659: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
1660: l_message_name := 'PO_PDOI_INVALID_ORIG_STD_PO';
1661: ELSE
1662: l_message_name := 'PO_PDOI_INVALID_ORIG_CATALOG';
1663: END IF;

Line 1666: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

1662: l_message_name := 'PO_PDOI_INVALID_ORIG_CATALOG';
1663: END IF;
1664: ELSE
1665: IF (PO_PDOI_PARAMS.g_request.document_type =
1666: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
1667: l_message_name := 'PO_PDOI_MULTIPLE_STD_PO';
1668: ELSE
1669: l_message_name := 'PO_PDOI_INVALID_MULT_ORIG_CATG';
1670: END IF;

Line 1690: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN

1686:
1687: IF (l_valid = FND_API.g_TRUE) THEN
1688: IF (PO_PDOI_PARAMS.g_request.document_type IN
1689: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1690: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN
1691:
1692: d_position := 140;
1693:
1694: PO_PDOI_UTL.get_processing_doctype_info

Line 1720: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

1716: IF (l_orig_consumption_flag_tbl(1) = 'Y' OR
1717: l_status_rec.updatable_flag(1) = 'N') THEN
1718:
1719: IF (PO_PDOI_PARAMS.g_request.document_type =
1720: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
1721: l_message_name := 'PO_PDOI_STD_PO_INVALID_STATUS';
1722: ELSE
1723: l_message_name := 'PO_PDOI_INVALID_ORIG_CATALOG';
1724: END IF;

Line 2912: 'STANDARD', -- shipment_type

2908: PLI.interface_line_id,
2909: PLI.processing_id,
2910: PLI.process_code,
2911: PLI.line_location_id,
2912: 'STANDARD', -- shipment_type
2913: 1, -- shipment_num
2914: PLI.ship_to_organization_id,
2915: PLI.ship_to_organization_code,
2916: PLI.ship_to_location_id,