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_PDOI_HEADER_PROCESS_PVT dependencies on PO_PDOI_CONSTANTS

Line 351: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,

347: FROM po_headers_interface
348: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
349: AND processing_round_num = PO_PDOI_PARAMS.g_current_round_num
350: AND interface_header_id > p_max_intf_header_id
351: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
352: PO_PDOI_CONSTANTS.g_ACTION_REPLACE)
353: ORDER by interface_header_id;
354:
355: IF (PO_LOG.d_proc) THEN

Line 352: PO_PDOI_CONSTANTS.g_ACTION_REPLACE)

348: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
349: AND processing_round_num = PO_PDOI_PARAMS.g_current_round_num
350: AND interface_header_id > p_max_intf_header_id
351: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
352: PO_PDOI_CONSTANTS.g_ACTION_REPLACE)
353: ORDER by interface_header_id;
354:
355: IF (PO_LOG.d_proc) THEN
356: PO_LOG.proc_end (d_module);

Line 565: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,

561: FROM po_headers_interface
562: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
563: AND processing_round_num = PO_PDOI_PARAMS.g_current_round_num
564: AND po_header_id = p_intf_po_header_id
565: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
566: PO_PDOI_CONSTANTS.g_ACTION_REPLACE)
567: ORDER by interface_header_id;
568:
569: IF (PO_LOG.d_proc) THEN

Line 566: PO_PDOI_CONSTANTS.g_ACTION_REPLACE)

562: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
563: AND processing_round_num = PO_PDOI_PARAMS.g_current_round_num
564: AND po_header_id = p_intf_po_header_id
565: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
566: PO_PDOI_CONSTANTS.g_ACTION_REPLACE)
567: ORDER by interface_header_id;
568:
569: IF (PO_LOG.d_proc) THEN
570: PO_LOG.proc_end (d_module);

Line 771: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;

767: x_headers.clm_source_document_disp_tbl,
768: x_headers.draft_type_tbl
769:
770:
771: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
772:
773: IF (PO_LOG.d_proc) THEN
774: PO_LOG.proc_end (d_module);
775: END IF;

Line 838: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_HEADER_DERIVE);

834: IF (PO_LOG.d_proc) THEN
835: PO_LOG.proc_begin(d_module, 'header_count', x_headers.rec_count);
836: END IF;
837:
838: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_HEADER_DERIVE);
839:
840: -- pick a new key which will be used in all derive logic
841: l_key := PO_CORE_S.get_session_gt_nextval;
842:

Line 960: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN

956: d_position := 90;
957:
958: -- derive from_header_id from from_rfq_num for QUOTATION
959: IF (PO_PDOI_PARAMS.g_request.document_type =
960: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
961: IF (PO_LOG.d_stmt) THEN
962: PO_LOG.stmt(d_module, d_position, 'derive from header id');
963: END IF;
964:

Line 1265: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN

1261: x_headers.error_flag_tbl(i) := FND_API.g_TRUE;
1262: END IF;
1263:
1264: IF (PO_PDOI_PARAMS.g_request.document_type =
1265: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
1266: IF (x_headers.from_rfq_num_tbl(i) IS NOT NULL AND
1267: x_headers.from_header_id_tbl(i) IS NULL) THEN
1268: IF (PO_LOG.d_stmt) THEN
1269: PO_LOG.stmt(d_module, d_position, 'from header id derivation failed');

Line 1393: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_HEADER_DERIVE);

1389: IF (PO_LOG.d_stmt) THEN
1390: PO_LOG.stmt(d_module, d_position, 'end of processing derivation errors');
1391: END IF;
1392:
1393: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_HEADER_DERIVE);
1394:
1395: IF (PO_LOG.d_proc) THEN
1396: PO_LOG.proc_end (d_module);
1397: END IF;

Line 1479: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_HEADER_DEFAULT);

1475: IF (PO_LOG.d_proc) THEN
1476: PO_LOG.proc_begin(d_module);
1477: END IF;
1478:
1479: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_HEADER_DEFAULT);
1480:
1481: -- pick a new key which will be used in all derive logic
1482: l_key := PO_CORE_S.get_session_gt_nextval;
1483:

Line 1552: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET, PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN

1548:
1549:
1550: -- default created_language for Blanket and Quotation
1551: IF (PO_PDOI_PARAMS.g_request.document_type IN
1552: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET, PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN
1553: x_headers.created_language_tbl(i) :=
1554: NVL(x_headers.created_language_tbl(i), USERENV('LANG'));
1555: END IF;
1556:

Line 1651: IF (x_headers.doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN

1647:
1648: d_position := 60;
1649:
1650: -- default attributes for each document type
1651: IF (x_headers.doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
1652: -- default document sub-type
1653: x_headers.doc_subtype_tbl(i) :=
1654: NVL(x_headers.doc_subtype_tbl(i), PO_PDOI_PARAMS.g_request.document_subtype);
1655:

Line 1739: ELSIF (x_headers.doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN

1735: x_headers.document_num_tbl(i));
1736: END IF;
1737:
1738: END IF;
1739: ELSIF (x_headers.doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
1740:
1741: d_position := 90;
1742:
1743: -- default revision_num

Line 1811: ELSIF (x_headers.doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

1807: PO_LOG.stmt(d_module, d_position, 'temp doc num',
1808: x_headers.document_num_tbl(i));
1809: END IF;
1810: END IF;
1811: ELSIF (x_headers.doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
1812:
1813: d_position := 130;
1814:
1815: -- default revision_num

Line 1949: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET AND

1945:
1946: -- default the distribution related fields for a Blanket if
1947: -- encumbrance is required on this document
1948: IF (PO_PDOI_PARAMS.g_request.document_type =
1949: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET AND
1950: PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND
1951: PO_PDOI_PARAMS.g_sys.req_encumbrance_flag = 'Y') THEN
1952: IF (PO_LOG.d_stmt) THEN
1953: PO_LOG.stmt(d_module, d_position, 'create distribution for blanket' ||

Line 1994: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_HEADER_DEFAULT);

1990: );
1991: END IF;
1992: --CLM PDOI Integration Ends
1993:
1994: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_HEADER_DEFAULT);
1995:
1996: IF (PO_LOG.d_proc) THEN
1997: PO_LOG.proc_end (d_module);
1998: END IF;

Line 2048: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_HEADER_VALIDATE);

2044: IF (PO_LOG.d_proc) THEN
2045: PO_LOG.proc_begin(d_module, 'x_headers', x_headers.intf_header_id_tbl);
2046: END IF;
2047:
2048: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_HEADER_VALIDATE);
2049:
2050: l_headers.interface_id := x_headers.intf_header_id_tbl;
2051: l_headers.po_header_id := x_headers.po_header_id_tbl;
2052: l_headers.start_date := x_headers.effective_date_tbl;

Line 2167: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_HEADER_VALIDATE);

2163: END IF;
2164:
2165: d_position := 50;
2166:
2167: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_HEADER_VALIDATE);
2168:
2169: IF (PO_LOG.d_proc) THEN
2170: PO_LOG.proc_end (d_module);
2171: END IF;

Line 3032: AND type_lookup_code = 'RFQ'; -- PO_PDOI_CONSTANTS.g_DOC_TYPE_RFQ;

3028: FROM po_headers
3029: WHERE x_from_header_id_tbl(i) IS NULL
3030: AND p_from_rfq_num_tbl(i) IS NOT NULL
3031: AND segment1 = p_from_rfq_num_tbl(i)
3032: AND type_lookup_code = 'RFQ'; -- PO_PDOI_CONSTANTS.g_DOC_TYPE_RFQ;
3033:
3034: d_position := 10;
3035:
3036: DELETE FROM po_session_gt

Line 3323: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION, 'N',

3319: AND vendor_id = p_vendor_id_tbl(i)
3320: AND purchasing_site_flag = 'Y'
3321: AND (sysdate) < nvl(inactive_date, TRUNC(sysdate + 1))
3322: AND DECODE(PO_PDOI_PARAMS.g_request.document_type,
3323: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION, 'N',
3324: NVL(rfq_only_site_flag, 'N')) <> 'Y'
3325: GROUP BY vendor_id
3326: HAVING count(vendor_site_id) = 1;
3327:

Line 3774: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,

3770: FORALL i IN 1..p_index_tbl.COUNT
3771: UPDATE po_session_gt
3772: SET char1 = ( SELECT standard_form
3773: FROM PO_PRINT_FORM_FORMATS
3774: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
3775: decode(char3,
3776: 'BPA_CALL', 'PO_DEL_ORD_STD_FORM',
3777: 'DELIVERY_ORD', 'PO_DEL_ORD_STD_FORM',
3778: 'PO_AWARD_STD_FORM'),

Line 3787: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,

3783: ),
3784:
3785: char2 = ( SELECT document_format
3786: FROM PO_PRINT_FORM_FORMATS
3787: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
3788: decode(char3,
3789: 'BPA_CALL', 'PO_DEL_ORD_STD_FORM',
3790: 'DELIVERY_ORD', 'PO_DEL_ORD_STD_FORM',
3791: 'PO_AWARD_STD_FORM'),

Line 3808: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,

3804: FORALL i IN 1..p_index_tbl.COUNT
3805: UPDATE po_session_gt
3806: SET char2 = ( SELECT document_format
3807: FROM PO_PRINT_FORM_FORMATS
3808: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
3809: decode(char3,
3810: 'BPA_CALL', 'PO_DEL_ORD_STD_FORM',
3811: 'DELIVERY_ORD', 'PO_DEL_ORD_STD_FORM',
3812: 'PO_AWARD_STD_FORM'),

Line 3819: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,

3815: AND trunc(sysdate) <= trunc(nvl(inactive_date, sysdate +1))
3816: AND style_id = num2
3817: AND ( Nvl(default_flag,'N') = 'Y' OR 1 = (SELECT Count(document_format)
3818: FROM PO_PRINT_FORM_FORMATS
3819: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
3820: decode(char3,
3821: 'BPA_CALL', 'PO_DEL_ORD_STD_FORM',
3822: 'DELIVERY_ORD', 'PO_DEL_ORD_STD_FORM',
3823: 'PO_AWARD_STD_FORM'),

Line 4183: AND p_doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD;

4179: FROM po_headers_all
4180: WHERE x_vendor_id_tbl(i) IS NULL
4181: AND p_clm_source_document_id_tbl(i) IS NOT NULL
4182: AND po_header_id = p_clm_source_document_id_tbl(i)
4183: AND p_doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD;
4184:
4185: d_position := 10;
4186:
4187: DELETE FROM po_session_gt

Line 4251: AND p_doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD;

4247: FROM po_headers_all
4248: WHERE x_vendor_site_id_tbl(i) IS NULL
4249: AND p_clm_source_document_id_tbl(i) IS NOT NULL
4250: AND po_header_id = p_clm_source_document_id_tbl(i)
4251: AND p_doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD;
4252:
4253: d_position := 10;
4254:
4255: DELETE FROM po_session_gt