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 279: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,

275: FROM po_headers_interface
276: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
277: AND processing_round_num = PO_PDOI_PARAMS.g_current_round_num
278: AND interface_header_id > p_max_intf_header_id
279: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
280: PO_PDOI_CONSTANTS.g_ACTION_REPLACE)
281: ORDER by interface_header_id;
282:
283: IF (PO_LOG.d_proc) THEN

Line 280: PO_PDOI_CONSTANTS.g_ACTION_REPLACE)

276: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
277: AND processing_round_num = PO_PDOI_PARAMS.g_current_round_num
278: AND interface_header_id > p_max_intf_header_id
279: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
280: PO_PDOI_CONSTANTS.g_ACTION_REPLACE)
281: ORDER by interface_header_id;
282:
283: IF (PO_LOG.d_proc) THEN
284: PO_LOG.proc_end (d_module);

Line 457: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;

453: x_headers.tax_attribute_update_code_tbl,
454:
455: -- blanket dist columns
456: x_headers.po_dist_id_tbl -- bug5252250
457: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
458:
459: IF (PO_LOG.d_proc) THEN
460: PO_LOG.proc_end (d_module);
461: END IF;

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

520: IF (PO_LOG.d_proc) THEN
521: PO_LOG.proc_begin(d_module, 'header_count', x_headers.rec_count);
522: END IF;
523:
524: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_HEADER_DERIVE);
525:
526: -- pick a new key which will be used in all derive logic
527: l_key := PO_CORE_S.get_session_gt_nextval;
528:

Line 646: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN

642: d_position := 90;
643:
644: -- derive from_header_id from from_rfq_num for QUOTATION
645: IF (PO_PDOI_PARAMS.g_request.document_type =
646: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
647: IF (PO_LOG.d_stmt) THEN
648: PO_LOG.stmt(d_module, d_position, 'derive from header id');
649: END IF;
650:

Line 894: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN

890: x_headers.error_flag_tbl(i) := FND_API.g_TRUE;
891: END IF;
892:
893: IF (PO_PDOI_PARAMS.g_request.document_type =
894: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
895: IF (x_headers.from_rfq_num_tbl(i) IS NOT NULL AND
896: x_headers.from_header_id_tbl(i) IS NULL) THEN
897: IF (PO_LOG.d_stmt) THEN
898: PO_LOG.stmt(d_module, d_position, 'from header id derivation failed');

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

920: IF (PO_LOG.d_stmt) THEN
921: PO_LOG.stmt(d_module, d_position, 'end of processing derivation errors');
922: END IF;
923:
924: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_HEADER_DERIVE);
925:
926: IF (PO_LOG.d_proc) THEN
927: PO_LOG.proc_end (d_module);
928: END IF;

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

1006: IF (PO_LOG.d_proc) THEN
1007: PO_LOG.proc_begin(d_module);
1008: END IF;
1009:
1010: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_HEADER_DEFAULT);
1011:
1012: -- pick a new key which will be used in all derive logic
1013: l_key := PO_CORE_S.get_session_gt_nextval;
1014:

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

1079:
1080:
1081: -- default created_language for Blanket and Quotation
1082: IF (PO_PDOI_PARAMS.g_request.document_type IN
1083: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET, PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN
1084: x_headers.created_language_tbl(i) :=
1085: NVL(x_headers.created_language_tbl(i), USERENV('LANG'));
1086: END IF;
1087:

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

1172:
1173: d_position := 60;
1174:
1175: -- default attributes for each document type
1176: IF (x_headers.doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
1177: -- default document sub-type
1178: x_headers.doc_subtype_tbl(i) :=
1179: NVL(x_headers.doc_subtype_tbl(i), PO_PDOI_PARAMS.g_request.document_subtype);
1180:

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

1260: x_headers.document_num_tbl(i));
1261: END IF;
1262:
1263: END IF;
1264: ELSIF (x_headers.doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
1265:
1266: d_position := 90;
1267:
1268: -- default revision_num

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

1332: PO_LOG.stmt(d_module, d_position, 'temp doc num',
1333: x_headers.document_num_tbl(i));
1334: END IF;
1335: END IF;
1336: ELSIF (x_headers.doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
1337:
1338: d_position := 130;
1339:
1340: -- default revision_num

Line 1466: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET AND

1462:
1463: -- default the distribution related fields for a Blanket if
1464: -- encumbrance is required on this document
1465: IF (PO_PDOI_PARAMS.g_request.document_type =
1466: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET AND
1467: PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND
1468: PO_PDOI_PARAMS.g_sys.req_encumbrance_flag = 'Y') THEN
1469: IF (PO_LOG.d_stmt) THEN
1470: PO_LOG.stmt(d_module, d_position, 'create distribution for blanket' ||

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

1492: x_program_id_tbl => x_headers.program_id_tbl,
1493: x_program_update_date_tbl => x_headers.program_update_date_tbl
1494: );
1495:
1496: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_HEADER_DEFAULT);
1497:
1498: IF (PO_LOG.d_proc) THEN
1499: PO_LOG.proc_end (d_module);
1500: END IF;

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

1546: IF (PO_LOG.d_proc) THEN
1547: PO_LOG.proc_begin(d_module, 'x_headers', x_headers.intf_header_id_tbl);
1548: END IF;
1549:
1550: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_HEADER_VALIDATE);
1551:
1552: l_headers.interface_id := x_headers.intf_header_id_tbl;
1553: l_headers.po_header_id := x_headers.po_header_id_tbl;
1554: l_headers.start_date := x_headers.effective_date_tbl;

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

1654: END IF;
1655:
1656: d_position := 50;
1657:
1658: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_HEADER_VALIDATE);
1659:
1660: IF (PO_LOG.d_proc) THEN
1661: PO_LOG.proc_end (d_module);
1662: END IF;

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

2519: FROM po_headers
2520: WHERE x_from_header_id_tbl(i) IS NULL
2521: AND p_from_rfq_num_tbl(i) IS NOT NULL
2522: AND segment1 = p_from_rfq_num_tbl(i)
2523: AND type_lookup_code = 'RFQ'; -- PO_PDOI_CONSTANTS.g_DOC_TYPE_RFQ;
2524:
2525: d_position := 10;
2526:
2527: DELETE FROM po_session_gt

Line 2814: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION, 'N',

2810: AND vendor_id = p_vendor_id_tbl(i)
2811: AND purchasing_site_flag = 'Y'
2812: AND (sysdate) < nvl(inactive_date, TRUNC(sysdate + 1))
2813: AND DECODE(PO_PDOI_PARAMS.g_request.document_type,
2814: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION, 'N',
2815: NVL(rfq_only_site_flag, 'N')) <> 'Y'
2816: GROUP BY vendor_id
2817: HAVING count(vendor_site_id) = 1;
2818: