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_R12_CAT_UPG_UTL dependencies on PO_R12_CAT_UPG_PVT

Line 8: g_err_num NUMBER := PO_R12_CAT_UPG_PVT.g_application_err_num;

4: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_R12_CAT_UPG_UTL';
5: g_module_prefix CONSTANT VARCHAR2(100) := 'po.plsql.' || g_pkg_name || '.';
6:
7: g_debug BOOLEAN := PO_R12_CAT_UPG_DEBUG.is_logging_enabled;
8: g_err_num NUMBER := PO_R12_CAT_UPG_PVT.g_application_err_num;
9:
10: g_base_language FND_LANGUAGES.language_code%TYPE := NULL;
11:
12: --------------------------------------------------------------------------------

Line 78: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'batch_id='|| PO_R12_CAT_UPG_PVT.g_job.batch_id);

74:
75: IF g_debug THEN
76: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'interface_type='||'PO_DOCS_OPEN_INTERFACE');
77: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'error_type='||'FATAL');
78: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'batch_id='|| PO_R12_CAT_UPG_PVT.g_job.batch_id);
79: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'interface_header_id='|| p_interface_header_id);
80: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'interface_line_id='|| p_interface_line_id);
81: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'error_message_name='|| p_error_message_name);
82: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'table_name='|| p_table_name);

Line 107: x_batch_id => PO_R12_CAT_UPG_PVT.g_job.batch_id,

103: PO_INTERFACE_ERRORS_SV1.handle_interface_errors
104: (
105: x_interface_type => 'PO_DOCS_OPEN_INTERFACE',
106: x_error_type => 'FATAL',
107: x_batch_id => PO_R12_CAT_UPG_PVT.g_job.batch_id,
108: x_interface_header_id => p_interface_header_id,
109: x_interface_line_id => p_interface_line_id,
110: x_error_message_name => p_error_message_name,
111: x_table_name => p_table_name,

Line 201: PO_R12_CAT_UPG_PVT.g_job.batch_id

197: FND_GLOBAL.conc_request_id,
198: FND_GLOBAL.prog_appl_id,
199: FND_GLOBAL.conc_program_id,
200: sysdate,
201: PO_R12_CAT_UPG_PVT.g_job.batch_id
202: );
203:
204: l_progress := '030';
205: -- Have to commit at the end of a successful autonomous transaction

Line 264: SET process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED

260: -- downstream flows.
261: -- SQL Join: interface_header_id
262: FORALL i IN 1..p_id_tbl.COUNT
263: UPDATE po_headers_interface
264: SET process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
265: --processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id
266: WHERE interface_header_id = p_id_tbl(i);
267: ELSE
268: l_progress := '030';

Line 265: --processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id

261: -- SQL Join: interface_header_id
262: FORALL i IN 1..p_id_tbl.COUNT
263: UPDATE po_headers_interface
264: SET process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
265: --processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id
266: WHERE interface_header_id = p_id_tbl(i);
267: ELSE
268: l_progress := '030';
269: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'param_type is not INTERFACE_HEADER_ID'); END IF;

Line 349: SET process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED

345: -- downstream flows.
346: -- SQL Join: interface_header_id
347: FORALL i IN 1..p_id_tbl.COUNT
348: UPDATE po_lines_interface
349: SET process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
350: --processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id
351: WHERE interface_header_id = p_id_tbl(i)
352: RETURNING interface_header_id, interface_line_id
353: BULK COLLECT INTO l_processed_intf_hdr_id_tbl, l_intf_line_id_tbl;

Line 350: --processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id

346: -- SQL Join: interface_header_id
347: FORALL i IN 1..p_id_tbl.COUNT
348: UPDATE po_lines_interface
349: SET process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
350: --processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id
351: WHERE interface_header_id = p_id_tbl(i)
352: RETURNING interface_header_id, interface_line_id
353: BULK COLLECT INTO l_processed_intf_hdr_id_tbl, l_intf_line_id_tbl;
354:

Line 365: SET process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED

361: -- downstream flows.
362: -- SQL Join: interface_line_id
363: FORALL i IN 1..p_id_tbl.COUNT
364: UPDATE po_lines_interface
365: SET process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
366: --processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id
367: WHERE interface_line_id = p_id_tbl(i)
368: RETURNING interface_header_id, interface_line_id
369: BULK COLLECT INTO l_processed_intf_hdr_id_tbl, l_intf_line_id_tbl;

Line 366: --processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id

362: -- SQL Join: interface_line_id
363: FORALL i IN 1..p_id_tbl.COUNT
364: UPDATE po_lines_interface
365: SET process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
366: --processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id
367: WHERE interface_line_id = p_id_tbl(i)
368: RETURNING interface_header_id, interface_line_id
369: BULK COLLECT INTO l_processed_intf_hdr_id_tbl, l_intf_line_id_tbl;
370:

Line 464: SET POATRI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED,

460: -- Bug 5417386: Added hint, removed join with hdr_id
461: FORALL i IN 1..p_id_tbl.COUNT
462: UPDATE /*+ INDEX(POATRI, PO_ATTR_VALUES_INT_N1) */
463: PO_ATTR_VALUES_INTERFACE POATRI
464: SET POATRI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED,
465: POATRI.processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id
466: WHERE POATRI.interface_line_id = p_id_tbl(i);
467:
468: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows REJECTED in PO_ATTR_VALUES_INTERFACE='||SQL%rowcount); END IF;

Line 465: POATRI.processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id

461: FORALL i IN 1..p_id_tbl.COUNT
462: UPDATE /*+ INDEX(POATRI, PO_ATTR_VALUES_INT_N1) */
463: PO_ATTR_VALUES_INTERFACE POATRI
464: SET POATRI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED,
465: POATRI.processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id
466: WHERE POATRI.interface_line_id = p_id_tbl(i);
467:
468: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows REJECTED in PO_ATTR_VALUES_INTERFACE='||SQL%rowcount); END IF;
469: ELSIF (p_id_param_type = 'INTERFACE_ATTR_VALUES_ID') THEN

Line 481: SET POATRI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED,

477: --
478: -- No need of hint as the join is using the primary key interface_attr_values_id.
479: FORALL i IN 1..p_id_tbl.COUNT
480: UPDATE PO_ATTR_VALUES_INTERFACE POATRI
481: SET POATRI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED,
482: POATRI.processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id
483: WHERE POATRI.interface_attr_values_id = p_id_tbl(i);
484:
485: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows REJECTED in PO_ATTR_VALUES_INTERFACE='||SQL%rowcount); END IF;

Line 482: POATRI.processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id

478: -- No need of hint as the join is using the primary key interface_attr_values_id.
479: FORALL i IN 1..p_id_tbl.COUNT
480: UPDATE PO_ATTR_VALUES_INTERFACE POATRI
481: SET POATRI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED,
482: POATRI.processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id
483: WHERE POATRI.interface_attr_values_id = p_id_tbl(i);
484:
485: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows REJECTED in PO_ATTR_VALUES_INTERFACE='||SQL%rowcount); END IF;
486: ELSE

Line 554: SET POTLPI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED,

550: -- Bug 5417386: Added hint, removed join with hdr_id
551: FORALL i IN 1..p_id_tbl.COUNT
552: UPDATE /*+ INDEX(POTLPI, PO_ATTR_VALUES_TLP_INT_N1) */
553: PO_ATTR_VALUES_TLP_INTERFACE POTLPI
554: SET POTLPI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED,
555: POTLPI.processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id
556: WHERE POTLPI.interface_line_id = p_id_tbl(i);
557:
558: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows REJECTED in PO_ATTR_VALUES_TLP_INTERFACE='||SQL%rowcount); END IF;

Line 555: POTLPI.processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id

551: FORALL i IN 1..p_id_tbl.COUNT
552: UPDATE /*+ INDEX(POTLPI, PO_ATTR_VALUES_TLP_INT_N1) */
553: PO_ATTR_VALUES_TLP_INTERFACE POTLPI
554: SET POTLPI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED,
555: POTLPI.processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id
556: WHERE POTLPI.interface_line_id = p_id_tbl(i);
557:
558: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows REJECTED in PO_ATTR_VALUES_TLP_INTERFACE='||SQL%rowcount); END IF;
559: ELSIF (p_id_param_type = 'INTERFACE_ATTR_VALUES_TLP_ID') THEN

Line 571: SET process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED,

567: --
568: -- No need of hint as the join is using the primary key interface_attr_values_tlp_id.
569: FORALL i IN 1..p_id_tbl.COUNT
570: UPDATE po_attr_values_tlp_interface
571: SET process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED,
572: processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id
573: WHERE interface_attr_values_tlp_id = p_id_tbl(i);
574:
575: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows REJECTED in PO_ATTR_VALUES_TLP_INTERFACE='||SQL%rowcount); END IF;

Line 572: processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id

568: -- No need of hint as the join is using the primary key interface_attr_values_tlp_id.
569: FORALL i IN 1..p_id_tbl.COUNT
570: UPDATE po_attr_values_tlp_interface
571: SET process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED,
572: processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id
573: WHERE interface_attr_values_tlp_id = p_id_tbl(i);
574:
575: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows REJECTED in PO_ATTR_VALUES_TLP_INTERFACE='||SQL%rowcount); END IF;
576: ELSE

Line 648: -- The PO_R12_CAT_UPG_PVT.g_job structure is populated with valid

644: --------------------------------------------------------------------------------
645: --Start of Comments
646: --Name: assign_processing_id
647: --Pre-reqs:
648: -- The PO_R12_CAT_UPG_PVT.g_job structure is populated with valid
649: -- data.
650: --Modifies:
651: -- a) PO interface tables
652: -- b) FND_MSG_PUB on unhandled exceptions.

Line 680: WHERE PHI.batch_id = PO_R12_CAT_UPG_PVT.g_job.batch_id

676: -- SQL Join: batch_id, org_id, process_code, document_type.
677: CURSOR interface_headers_csr IS
678: SELECT PHI.interface_header_id
679: FROM po_headers_interface PHI
680: WHERE PHI.batch_id = PO_R12_CAT_UPG_PVT.g_job.batch_id
681: AND (PHI.org_id = PO_R12_CAT_UPG_PVT.g_job.org_id OR
682: PO_R12_CAT_UPG_PVT.g_job.org_id IS NULL)
683: AND PHI.processing_id IS NULL
684: AND PHI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_NEW;

Line 681: AND (PHI.org_id = PO_R12_CAT_UPG_PVT.g_job.org_id OR

677: CURSOR interface_headers_csr IS
678: SELECT PHI.interface_header_id
679: FROM po_headers_interface PHI
680: WHERE PHI.batch_id = PO_R12_CAT_UPG_PVT.g_job.batch_id
681: AND (PHI.org_id = PO_R12_CAT_UPG_PVT.g_job.org_id OR
682: PO_R12_CAT_UPG_PVT.g_job.org_id IS NULL)
683: AND PHI.processing_id IS NULL
684: AND PHI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_NEW;
685:

Line 682: PO_R12_CAT_UPG_PVT.g_job.org_id IS NULL)

678: SELECT PHI.interface_header_id
679: FROM po_headers_interface PHI
680: WHERE PHI.batch_id = PO_R12_CAT_UPG_PVT.g_job.batch_id
681: AND (PHI.org_id = PO_R12_CAT_UPG_PVT.g_job.org_id OR
682: PO_R12_CAT_UPG_PVT.g_job.org_id IS NULL)
683: AND PHI.processing_id IS NULL
684: AND PHI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_NEW;
685:
686: l_intf_header_id_tbl PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 684: AND PHI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_NEW;

680: WHERE PHI.batch_id = PO_R12_CAT_UPG_PVT.g_job.batch_id
681: AND (PHI.org_id = PO_R12_CAT_UPG_PVT.g_job.org_id OR
682: PO_R12_CAT_UPG_PVT.g_job.org_id IS NULL)
683: AND PHI.processing_id IS NULL
684: AND PHI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_NEW;
685:
686: l_intf_header_id_tbl PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
687: l_intf_line_id_tbl PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
688:

Line 703: LIMIT PO_R12_CAT_UPG_PVT.g_job.batch_size;

699: l_progress := '030';
700:
701: FETCH interface_headers_csr
702: BULK COLLECT INTO l_intf_header_id_tbl
703: LIMIT PO_R12_CAT_UPG_PVT.g_job.batch_size;
704:
705: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'PO_R12_CAT_UPG_PVT.g_processing_id='||PO_R12_CAT_UPG_PVT.g_processing_id); END IF;
706: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'l_intf_header_id_tbl.COUNT='||l_intf_header_id_tbl.COUNT); END IF;
707:

Line 705: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'PO_R12_CAT_UPG_PVT.g_processing_id='||PO_R12_CAT_UPG_PVT.g_processing_id); END IF;

701: FETCH interface_headers_csr
702: BULK COLLECT INTO l_intf_header_id_tbl
703: LIMIT PO_R12_CAT_UPG_PVT.g_job.batch_size;
704:
705: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'PO_R12_CAT_UPG_PVT.g_processing_id='||PO_R12_CAT_UPG_PVT.g_processing_id); END IF;
706: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'l_intf_header_id_tbl.COUNT='||l_intf_header_id_tbl.COUNT); END IF;
707:
708: l_progress := '040';
709: EXIT WHEN l_intf_header_id_tbl.COUNT = 0;

Line 717: SET processing_id = PO_R12_CAT_UPG_PVT.g_processing_id

713: -- SQL Why : So that these rows are picked up for processing.
714: -- SQL Join: interface_header_id
715: FORALL i IN 1..l_intf_header_id_tbl.COUNT
716: UPDATE po_headers_interface
717: SET processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
718: WHERE interface_header_id = l_intf_header_id_tbl(i)
719: AND processing_id IS NULL;
720:
721: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows updated in Headers Interface='||SQL%rowcount); END IF;

Line 729: SET processing_id = PO_R12_CAT_UPG_PVT.g_processing_id

725: -- SQL Why : So that these rows are picked up for processing.
726: -- SQL Join: interface_header_id
727: FORALL i IN 1..l_intf_header_id_tbl.COUNT
728: UPDATE po_lines_interface
729: SET processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
730: WHERE interface_header_id = l_intf_header_id_tbl(i)
731: AND processing_id IS NULL
732: RETURNING interface_header_id, interface_line_id
733: BULK COLLECT INTO l_processed_intf_hdr_id_tbl, l_intf_line_id_tbl;

Line 740: -- SET processing_id = PO_R12_CAT_UPG_PVT.g_processing_id

736:
737: l_progress := '070';
738: --FORALL i IN 1..l_intf_line_id_tbl.COUNT
739: -- UPDATE po_line_locations_interface
740: -- SET processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
741: -- WHERE interface_line_id = l_intf_line_id_tbl(i);
742:
743: --FORALL i IN 1..l_intf_line_id_tbl.COUNT
744: -- UPDATE po_price_diff_interface

Line 745: -- SET processing_id = PO_R12_CAT_UPG_PVT.g_processing_id

741: -- WHERE interface_line_id = l_intf_line_id_tbl(i);
742:
743: --FORALL i IN 1..l_intf_line_id_tbl.COUNT
744: -- UPDATE po_price_diff_interface
745: -- SET processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
746: -- WHERE interface_line_id = l_intf_line_id_tbl(i);
747:
748: --IF (PO_R12_CAT_UPG_PVT.g_job.document_type =
749: -- PO_R12_CAT_UPG_PVT.g_DOC_TYPE_STANDARD) THEN

Line 748: --IF (PO_R12_CAT_UPG_PVT.g_job.document_type =

744: -- UPDATE po_price_diff_interface
745: -- SET processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
746: -- WHERE interface_line_id = l_intf_line_id_tbl(i);
747:
748: --IF (PO_R12_CAT_UPG_PVT.g_job.document_type =
749: -- PO_R12_CAT_UPG_PVT.g_DOC_TYPE_STANDARD) THEN
750: -- FORALL i IN 1..l_intf_line_id_tbl.COUNT
751: -- UPDATE po_distributions_interface
752: -- SET processing_id = PO_R12_CAT_UPG_PVT.g_processing_id

Line 749: -- PO_R12_CAT_UPG_PVT.g_DOC_TYPE_STANDARD) THEN

745: -- SET processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
746: -- WHERE interface_line_id = l_intf_line_id_tbl(i);
747:
748: --IF (PO_R12_CAT_UPG_PVT.g_job.document_type =
749: -- PO_R12_CAT_UPG_PVT.g_DOC_TYPE_STANDARD) THEN
750: -- FORALL i IN 1..l_intf_line_id_tbl.COUNT
751: -- UPDATE po_distributions_interface
752: -- SET processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
753: -- WHERE interface_line_id = l_intf_line_id_tbl(i);

Line 752: -- SET processing_id = PO_R12_CAT_UPG_PVT.g_processing_id

748: --IF (PO_R12_CAT_UPG_PVT.g_job.document_type =
749: -- PO_R12_CAT_UPG_PVT.g_DOC_TYPE_STANDARD) THEN
750: -- FORALL i IN 1..l_intf_line_id_tbl.COUNT
751: -- UPDATE po_distributions_interface
752: -- SET processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
753: -- WHERE interface_line_id = l_intf_line_id_tbl(i);
754: --END IF;
755:
756: l_progress := '080';

Line 763: SET POATRI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id

759: -- SQL Join: interface_line_id
760: FORALL i IN 1..l_intf_line_id_tbl.COUNT
761: UPDATE /*+ INDEX(POATRI, PO_ATTR_VALUES_INT_N1) */
762: PO_ATTR_VALUES_INTERFACE POATRI
763: SET POATRI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
764: WHERE POATRI.interface_line_id = l_intf_line_id_tbl(i)
765: -- Bug 5345544: Start
766: -- Bug 5417386: Not required after index column re-ordering
767: --AND POATRI.interface_header_id = l_processed_intf_hdr_id_tbl(i)

Line 781: SET POTLPI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id

777: -- Bug 5417386: Added hint
778: FORALL i IN 1..l_intf_line_id_tbl.COUNT
779: UPDATE /*+ INDEX(POTLPI, PO_ATTR_VALUES_TLP_INT_N1) */
780: PO_ATTR_VALUES_TLP_INTERFACE POTLPI
781: SET POTLPI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
782: WHERE POTLPI.interface_line_id = l_intf_line_id_tbl(i)
783: -- Bug 5345544: Start
784: -- Bug 5417386: Not required after index column re-ordering
785: --AND POTLPI.interface_header_id = l_processed_intf_hdr_id_tbl(i)

Line 837: -- Populates the PO_R12_CAT_UPG_PVT.g_job structure using the

833: -- a) FND_MSG_PUB on unhandled exceptions.
834: --Locks:
835: -- None.
836: --Function:
837: -- Populates the PO_R12_CAT_UPG_PVT.g_job structure using the
838: -- input parameters. Also fetches the next processing_id from the sequence.
839: --
840: --Parameters:
841: --IN:

Line 875: PO_R12_CAT_UPG_PVT.g_job.commit_work := p_commit;

871: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
872:
873: l_progress := '020';
874: -- Setup g_job param
875: PO_R12_CAT_UPG_PVT.g_job.commit_work := p_commit;
876: PO_R12_CAT_UPG_PVT.g_job.batch_id := p_selected_batch_id;
877: PO_R12_CAT_UPG_PVT.g_job.batch_size := p_batch_size;
878: PO_R12_CAT_UPG_PVT.g_job.buyer_id := p_buyer_id;
879: PO_R12_CAT_UPG_PVT.g_job.document_type := p_document_type;

Line 876: PO_R12_CAT_UPG_PVT.g_job.batch_id := p_selected_batch_id;

872:
873: l_progress := '020';
874: -- Setup g_job param
875: PO_R12_CAT_UPG_PVT.g_job.commit_work := p_commit;
876: PO_R12_CAT_UPG_PVT.g_job.batch_id := p_selected_batch_id;
877: PO_R12_CAT_UPG_PVT.g_job.batch_size := p_batch_size;
878: PO_R12_CAT_UPG_PVT.g_job.buyer_id := p_buyer_id;
879: PO_R12_CAT_UPG_PVT.g_job.document_type := p_document_type;
880: PO_R12_CAT_UPG_PVT.g_job.document_subtype := p_document_subtype;

Line 877: PO_R12_CAT_UPG_PVT.g_job.batch_size := p_batch_size;

873: l_progress := '020';
874: -- Setup g_job param
875: PO_R12_CAT_UPG_PVT.g_job.commit_work := p_commit;
876: PO_R12_CAT_UPG_PVT.g_job.batch_id := p_selected_batch_id;
877: PO_R12_CAT_UPG_PVT.g_job.batch_size := p_batch_size;
878: PO_R12_CAT_UPG_PVT.g_job.buyer_id := p_buyer_id;
879: PO_R12_CAT_UPG_PVT.g_job.document_type := p_document_type;
880: PO_R12_CAT_UPG_PVT.g_job.document_subtype := p_document_subtype;
881: PO_R12_CAT_UPG_PVT.g_job.error_threshold := p_error_threshold;

Line 878: PO_R12_CAT_UPG_PVT.g_job.buyer_id := p_buyer_id;

874: -- Setup g_job param
875: PO_R12_CAT_UPG_PVT.g_job.commit_work := p_commit;
876: PO_R12_CAT_UPG_PVT.g_job.batch_id := p_selected_batch_id;
877: PO_R12_CAT_UPG_PVT.g_job.batch_size := p_batch_size;
878: PO_R12_CAT_UPG_PVT.g_job.buyer_id := p_buyer_id;
879: PO_R12_CAT_UPG_PVT.g_job.document_type := p_document_type;
880: PO_R12_CAT_UPG_PVT.g_job.document_subtype := p_document_subtype;
881: PO_R12_CAT_UPG_PVT.g_job.error_threshold := p_error_threshold;
882: PO_R12_CAT_UPG_PVT.g_job.validate_only_mode := p_validate_only_mode;

Line 879: PO_R12_CAT_UPG_PVT.g_job.document_type := p_document_type;

875: PO_R12_CAT_UPG_PVT.g_job.commit_work := p_commit;
876: PO_R12_CAT_UPG_PVT.g_job.batch_id := p_selected_batch_id;
877: PO_R12_CAT_UPG_PVT.g_job.batch_size := p_batch_size;
878: PO_R12_CAT_UPG_PVT.g_job.buyer_id := p_buyer_id;
879: PO_R12_CAT_UPG_PVT.g_job.document_type := p_document_type;
880: PO_R12_CAT_UPG_PVT.g_job.document_subtype := p_document_subtype;
881: PO_R12_CAT_UPG_PVT.g_job.error_threshold := p_error_threshold;
882: PO_R12_CAT_UPG_PVT.g_job.validate_only_mode := p_validate_only_mode;
883:

Line 880: PO_R12_CAT_UPG_PVT.g_job.document_subtype := p_document_subtype;

876: PO_R12_CAT_UPG_PVT.g_job.batch_id := p_selected_batch_id;
877: PO_R12_CAT_UPG_PVT.g_job.batch_size := p_batch_size;
878: PO_R12_CAT_UPG_PVT.g_job.buyer_id := p_buyer_id;
879: PO_R12_CAT_UPG_PVT.g_job.document_type := p_document_type;
880: PO_R12_CAT_UPG_PVT.g_job.document_subtype := p_document_subtype;
881: PO_R12_CAT_UPG_PVT.g_job.error_threshold := p_error_threshold;
882: PO_R12_CAT_UPG_PVT.g_job.validate_only_mode := p_validate_only_mode;
883:
884: IF g_debug THEN

Line 881: PO_R12_CAT_UPG_PVT.g_job.error_threshold := p_error_threshold;

877: PO_R12_CAT_UPG_PVT.g_job.batch_size := p_batch_size;
878: PO_R12_CAT_UPG_PVT.g_job.buyer_id := p_buyer_id;
879: PO_R12_CAT_UPG_PVT.g_job.document_type := p_document_type;
880: PO_R12_CAT_UPG_PVT.g_job.document_subtype := p_document_subtype;
881: PO_R12_CAT_UPG_PVT.g_job.error_threshold := p_error_threshold;
882: PO_R12_CAT_UPG_PVT.g_job.validate_only_mode := p_validate_only_mode;
883:
884: IF g_debug THEN
885: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param commit_work='||PO_R12_CAT_UPG_PVT.g_job.commit_work);

Line 882: PO_R12_CAT_UPG_PVT.g_job.validate_only_mode := p_validate_only_mode;

878: PO_R12_CAT_UPG_PVT.g_job.buyer_id := p_buyer_id;
879: PO_R12_CAT_UPG_PVT.g_job.document_type := p_document_type;
880: PO_R12_CAT_UPG_PVT.g_job.document_subtype := p_document_subtype;
881: PO_R12_CAT_UPG_PVT.g_job.error_threshold := p_error_threshold;
882: PO_R12_CAT_UPG_PVT.g_job.validate_only_mode := p_validate_only_mode;
883:
884: IF g_debug THEN
885: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param commit_work='||PO_R12_CAT_UPG_PVT.g_job.commit_work);
886: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param batch_id='||PO_R12_CAT_UPG_PVT.g_job.batch_id);

Line 885: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param commit_work='||PO_R12_CAT_UPG_PVT.g_job.commit_work);

881: PO_R12_CAT_UPG_PVT.g_job.error_threshold := p_error_threshold;
882: PO_R12_CAT_UPG_PVT.g_job.validate_only_mode := p_validate_only_mode;
883:
884: IF g_debug THEN
885: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param commit_work='||PO_R12_CAT_UPG_PVT.g_job.commit_work);
886: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param batch_id='||PO_R12_CAT_UPG_PVT.g_job.batch_id);
887: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param batch_size='||PO_R12_CAT_UPG_PVT.g_job.batch_size);
888: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param buyer_id='||PO_R12_CAT_UPG_PVT.g_job.buyer_id);
889: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param document_type='||PO_R12_CAT_UPG_PVT.g_job.document_type);

Line 886: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param batch_id='||PO_R12_CAT_UPG_PVT.g_job.batch_id);

882: PO_R12_CAT_UPG_PVT.g_job.validate_only_mode := p_validate_only_mode;
883:
884: IF g_debug THEN
885: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param commit_work='||PO_R12_CAT_UPG_PVT.g_job.commit_work);
886: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param batch_id='||PO_R12_CAT_UPG_PVT.g_job.batch_id);
887: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param batch_size='||PO_R12_CAT_UPG_PVT.g_job.batch_size);
888: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param buyer_id='||PO_R12_CAT_UPG_PVT.g_job.buyer_id);
889: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param document_type='||PO_R12_CAT_UPG_PVT.g_job.document_type);
890: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param document_subtype='||PO_R12_CAT_UPG_PVT.g_job.document_subtype);

Line 887: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param batch_size='||PO_R12_CAT_UPG_PVT.g_job.batch_size);

883:
884: IF g_debug THEN
885: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param commit_work='||PO_R12_CAT_UPG_PVT.g_job.commit_work);
886: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param batch_id='||PO_R12_CAT_UPG_PVT.g_job.batch_id);
887: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param batch_size='||PO_R12_CAT_UPG_PVT.g_job.batch_size);
888: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param buyer_id='||PO_R12_CAT_UPG_PVT.g_job.buyer_id);
889: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param document_type='||PO_R12_CAT_UPG_PVT.g_job.document_type);
890: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param document_subtype='||PO_R12_CAT_UPG_PVT.g_job.document_subtype);
891: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param error_threshold='||PO_R12_CAT_UPG_PVT.g_job.error_threshold);

Line 888: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param buyer_id='||PO_R12_CAT_UPG_PVT.g_job.buyer_id);

884: IF g_debug THEN
885: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param commit_work='||PO_R12_CAT_UPG_PVT.g_job.commit_work);
886: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param batch_id='||PO_R12_CAT_UPG_PVT.g_job.batch_id);
887: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param batch_size='||PO_R12_CAT_UPG_PVT.g_job.batch_size);
888: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param buyer_id='||PO_R12_CAT_UPG_PVT.g_job.buyer_id);
889: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param document_type='||PO_R12_CAT_UPG_PVT.g_job.document_type);
890: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param document_subtype='||PO_R12_CAT_UPG_PVT.g_job.document_subtype);
891: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param error_threshold='||PO_R12_CAT_UPG_PVT.g_job.error_threshold);
892: END IF;

Line 889: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param document_type='||PO_R12_CAT_UPG_PVT.g_job.document_type);

885: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param commit_work='||PO_R12_CAT_UPG_PVT.g_job.commit_work);
886: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param batch_id='||PO_R12_CAT_UPG_PVT.g_job.batch_id);
887: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param batch_size='||PO_R12_CAT_UPG_PVT.g_job.batch_size);
888: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param buyer_id='||PO_R12_CAT_UPG_PVT.g_job.buyer_id);
889: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param document_type='||PO_R12_CAT_UPG_PVT.g_job.document_type);
890: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param document_subtype='||PO_R12_CAT_UPG_PVT.g_job.document_subtype);
891: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param error_threshold='||PO_R12_CAT_UPG_PVT.g_job.error_threshold);
892: END IF;
893:

Line 890: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param document_subtype='||PO_R12_CAT_UPG_PVT.g_job.document_subtype);

886: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param batch_id='||PO_R12_CAT_UPG_PVT.g_job.batch_id);
887: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param batch_size='||PO_R12_CAT_UPG_PVT.g_job.batch_size);
888: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param buyer_id='||PO_R12_CAT_UPG_PVT.g_job.buyer_id);
889: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param document_type='||PO_R12_CAT_UPG_PVT.g_job.document_type);
890: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param document_subtype='||PO_R12_CAT_UPG_PVT.g_job.document_subtype);
891: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param error_threshold='||PO_R12_CAT_UPG_PVT.g_job.error_threshold);
892: END IF;
893:
894: l_progress := '030';

Line 891: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param error_threshold='||PO_R12_CAT_UPG_PVT.g_job.error_threshold);

887: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param batch_size='||PO_R12_CAT_UPG_PVT.g_job.batch_size);
888: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param buyer_id='||PO_R12_CAT_UPG_PVT.g_job.buyer_id);
889: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param document_type='||PO_R12_CAT_UPG_PVT.g_job.document_type);
890: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param document_subtype='||PO_R12_CAT_UPG_PVT.g_job.document_subtype);
891: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Job param error_threshold='||PO_R12_CAT_UPG_PVT.g_job.error_threshold);
892: END IF;
893:
894: l_progress := '030';
895: -- Setup g_sys param

Line 902: --PO_R12_CAT_UPG_PVT.g_out.processed_rec_count := 0;

898: -- Setup profile param
899: --init_profile_parameters;
900:
901: -- setup g_out param
902: --PO_R12_CAT_UPG_PVT.g_out.processed_rec_count := 0;
903: --PO_R12_CAT_UPG_PVT.g_out.rejected_rec_count := 0;
904: --PO_R12_CAT_UPG_PVT.g_out.error_tolerance_exceeded := FND_API.G_FALSE;
905:
906: l_progress := '040';

Line 903: --PO_R12_CAT_UPG_PVT.g_out.rejected_rec_count := 0;

899: --init_profile_parameters;
900:
901: -- setup g_out param
902: --PO_R12_CAT_UPG_PVT.g_out.processed_rec_count := 0;
903: --PO_R12_CAT_UPG_PVT.g_out.rejected_rec_count := 0;
904: --PO_R12_CAT_UPG_PVT.g_out.error_tolerance_exceeded := FND_API.G_FALSE;
905:
906: l_progress := '040';
907: -- SQL What: Default processing_id from sequence

Line 904: --PO_R12_CAT_UPG_PVT.g_out.error_tolerance_exceeded := FND_API.G_FALSE;

900:
901: -- setup g_out param
902: --PO_R12_CAT_UPG_PVT.g_out.processed_rec_count := 0;
903: --PO_R12_CAT_UPG_PVT.g_out.rejected_rec_count := 0;
904: --PO_R12_CAT_UPG_PVT.g_out.error_tolerance_exceeded := FND_API.G_FALSE;
905:
906: l_progress := '040';
907: -- SQL What: Default processing_id from sequence
908: -- SQL Why : To assign processing id's to the interface table rows.

Line 911: INTO PO_R12_CAT_UPG_PVT.g_processing_id

907: -- SQL What: Default processing_id from sequence
908: -- SQL Why : To assign processing id's to the interface table rows.
909: -- SQL Join: none
910: SELECT PO_PDOI_PROCESSING_ID_S.nextval
911: INTO PO_R12_CAT_UPG_PVT.g_processing_id
912: FROM DUAL;
913:
914: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'processing_id='||PO_R12_CAT_UPG_PVT.g_processing_id); END IF;
915:

Line 914: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'processing_id='||PO_R12_CAT_UPG_PVT.g_processing_id); END IF;

910: SELECT PO_PDOI_PROCESSING_ID_S.nextval
911: INTO PO_R12_CAT_UPG_PVT.g_processing_id
912: FROM DUAL;
913:
914: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'processing_id='||PO_R12_CAT_UPG_PVT.g_processing_id); END IF;
915:
916: l_progress := '050';
917: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'END'); END IF;
918: EXCEPTION

Line 930: -- a) PO_R12_CAT_UPG_PVT.g_sys structure.

926: --Name: init_sys_parameters
927: --Pre-reqs:
928: -- None
929: --Modifies:
930: -- a) PO_R12_CAT_UPG_PVT.g_sys structure.
931: -- b) FND_MSG_PUB on unhandled exceptions.
932: --Locks:
933: -- None.
934: --Function:

Line 935: -- Populates the PO_R12_CAT_UPG_PVT.g_sys structure by calling

931: -- b) FND_MSG_PUB on unhandled exceptions.
932: --Locks:
933: -- None.
934: --Function:
935: -- Populates the PO_R12_CAT_UPG_PVT.g_sys structure by calling
936: -- PO_CORE_S.get_po_parameters() procedure.
937: --
938: --Parameters:
939: --IN:

Line 1007: PO_R12_CAT_UPG_PVT.g_sys.currency_code,

1003: PSPA.manual_rfq_num_type,
1004: FSPA.ship_via_lookup_code,
1005: rcv.qty_rcv_tolerance
1006: INTO
1007: PO_R12_CAT_UPG_PVT.g_sys.currency_code,
1008: PO_R12_CAT_UPG_PVT.g_sys.coa_id,
1009: PO_R12_CAT_UPG_PVT.g_sys.po_encumberance_flag,
1010: PO_R12_CAT_UPG_PVT.g_sys.req_encumberance_flag,
1011: PO_R12_CAT_UPG_PVT.g_sys.sob_id,

Line 1008: PO_R12_CAT_UPG_PVT.g_sys.coa_id,

1004: FSPA.ship_via_lookup_code,
1005: rcv.qty_rcv_tolerance
1006: INTO
1007: PO_R12_CAT_UPG_PVT.g_sys.currency_code,
1008: PO_R12_CAT_UPG_PVT.g_sys.coa_id,
1009: PO_R12_CAT_UPG_PVT.g_sys.po_encumberance_flag,
1010: PO_R12_CAT_UPG_PVT.g_sys.req_encumberance_flag,
1011: PO_R12_CAT_UPG_PVT.g_sys.sob_id,
1012: PO_R12_CAT_UPG_PVT.g_sys.ship_to_location_id,

Line 1009: PO_R12_CAT_UPG_PVT.g_sys.po_encumberance_flag,

1005: rcv.qty_rcv_tolerance
1006: INTO
1007: PO_R12_CAT_UPG_PVT.g_sys.currency_code,
1008: PO_R12_CAT_UPG_PVT.g_sys.coa_id,
1009: PO_R12_CAT_UPG_PVT.g_sys.po_encumberance_flag,
1010: PO_R12_CAT_UPG_PVT.g_sys.req_encumberance_flag,
1011: PO_R12_CAT_UPG_PVT.g_sys.sob_id,
1012: PO_R12_CAT_UPG_PVT.g_sys.ship_to_location_id,
1013: PO_R12_CAT_UPG_PVT.g_sys.bill_to_location_id,

Line 1010: PO_R12_CAT_UPG_PVT.g_sys.req_encumberance_flag,

1006: INTO
1007: PO_R12_CAT_UPG_PVT.g_sys.currency_code,
1008: PO_R12_CAT_UPG_PVT.g_sys.coa_id,
1009: PO_R12_CAT_UPG_PVT.g_sys.po_encumberance_flag,
1010: PO_R12_CAT_UPG_PVT.g_sys.req_encumberance_flag,
1011: PO_R12_CAT_UPG_PVT.g_sys.sob_id,
1012: PO_R12_CAT_UPG_PVT.g_sys.ship_to_location_id,
1013: PO_R12_CAT_UPG_PVT.g_sys.bill_to_location_id,
1014: PO_R12_CAT_UPG_PVT.g_sys.fob_lookup_code,

Line 1011: PO_R12_CAT_UPG_PVT.g_sys.sob_id,

1007: PO_R12_CAT_UPG_PVT.g_sys.currency_code,
1008: PO_R12_CAT_UPG_PVT.g_sys.coa_id,
1009: PO_R12_CAT_UPG_PVT.g_sys.po_encumberance_flag,
1010: PO_R12_CAT_UPG_PVT.g_sys.req_encumberance_flag,
1011: PO_R12_CAT_UPG_PVT.g_sys.sob_id,
1012: PO_R12_CAT_UPG_PVT.g_sys.ship_to_location_id,
1013: PO_R12_CAT_UPG_PVT.g_sys.bill_to_location_id,
1014: PO_R12_CAT_UPG_PVT.g_sys.fob_lookup_code,
1015: PO_R12_CAT_UPG_PVT.g_sys.freight_terms_lookup_code,

Line 1012: PO_R12_CAT_UPG_PVT.g_sys.ship_to_location_id,

1008: PO_R12_CAT_UPG_PVT.g_sys.coa_id,
1009: PO_R12_CAT_UPG_PVT.g_sys.po_encumberance_flag,
1010: PO_R12_CAT_UPG_PVT.g_sys.req_encumberance_flag,
1011: PO_R12_CAT_UPG_PVT.g_sys.sob_id,
1012: PO_R12_CAT_UPG_PVT.g_sys.ship_to_location_id,
1013: PO_R12_CAT_UPG_PVT.g_sys.bill_to_location_id,
1014: PO_R12_CAT_UPG_PVT.g_sys.fob_lookup_code,
1015: PO_R12_CAT_UPG_PVT.g_sys.freight_terms_lookup_code,
1016: PO_R12_CAT_UPG_PVT.g_sys.terms_id,

Line 1013: PO_R12_CAT_UPG_PVT.g_sys.bill_to_location_id,

1009: PO_R12_CAT_UPG_PVT.g_sys.po_encumberance_flag,
1010: PO_R12_CAT_UPG_PVT.g_sys.req_encumberance_flag,
1011: PO_R12_CAT_UPG_PVT.g_sys.sob_id,
1012: PO_R12_CAT_UPG_PVT.g_sys.ship_to_location_id,
1013: PO_R12_CAT_UPG_PVT.g_sys.bill_to_location_id,
1014: PO_R12_CAT_UPG_PVT.g_sys.fob_lookup_code,
1015: PO_R12_CAT_UPG_PVT.g_sys.freight_terms_lookup_code,
1016: PO_R12_CAT_UPG_PVT.g_sys.terms_id,
1017: PO_R12_CAT_UPG_PVT.g_sys.default_rate_type,

Line 1014: PO_R12_CAT_UPG_PVT.g_sys.fob_lookup_code,

1010: PO_R12_CAT_UPG_PVT.g_sys.req_encumberance_flag,
1011: PO_R12_CAT_UPG_PVT.g_sys.sob_id,
1012: PO_R12_CAT_UPG_PVT.g_sys.ship_to_location_id,
1013: PO_R12_CAT_UPG_PVT.g_sys.bill_to_location_id,
1014: PO_R12_CAT_UPG_PVT.g_sys.fob_lookup_code,
1015: PO_R12_CAT_UPG_PVT.g_sys.freight_terms_lookup_code,
1016: PO_R12_CAT_UPG_PVT.g_sys.terms_id,
1017: PO_R12_CAT_UPG_PVT.g_sys.default_rate_type,
1018: PO_R12_CAT_UPG_PVT.g_sys.taxable_flag,

Line 1015: PO_R12_CAT_UPG_PVT.g_sys.freight_terms_lookup_code,

1011: PO_R12_CAT_UPG_PVT.g_sys.sob_id,
1012: PO_R12_CAT_UPG_PVT.g_sys.ship_to_location_id,
1013: PO_R12_CAT_UPG_PVT.g_sys.bill_to_location_id,
1014: PO_R12_CAT_UPG_PVT.g_sys.fob_lookup_code,
1015: PO_R12_CAT_UPG_PVT.g_sys.freight_terms_lookup_code,
1016: PO_R12_CAT_UPG_PVT.g_sys.terms_id,
1017: PO_R12_CAT_UPG_PVT.g_sys.default_rate_type,
1018: PO_R12_CAT_UPG_PVT.g_sys.taxable_flag,
1019: PO_R12_CAT_UPG_PVT.g_sys.receiving_flag,

Line 1016: PO_R12_CAT_UPG_PVT.g_sys.terms_id,

1012: PO_R12_CAT_UPG_PVT.g_sys.ship_to_location_id,
1013: PO_R12_CAT_UPG_PVT.g_sys.bill_to_location_id,
1014: PO_R12_CAT_UPG_PVT.g_sys.fob_lookup_code,
1015: PO_R12_CAT_UPG_PVT.g_sys.freight_terms_lookup_code,
1016: PO_R12_CAT_UPG_PVT.g_sys.terms_id,
1017: PO_R12_CAT_UPG_PVT.g_sys.default_rate_type,
1018: PO_R12_CAT_UPG_PVT.g_sys.taxable_flag,
1019: PO_R12_CAT_UPG_PVT.g_sys.receiving_flag,
1020: PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_name_flag,

Line 1017: PO_R12_CAT_UPG_PVT.g_sys.default_rate_type,

1013: PO_R12_CAT_UPG_PVT.g_sys.bill_to_location_id,
1014: PO_R12_CAT_UPG_PVT.g_sys.fob_lookup_code,
1015: PO_R12_CAT_UPG_PVT.g_sys.freight_terms_lookup_code,
1016: PO_R12_CAT_UPG_PVT.g_sys.terms_id,
1017: PO_R12_CAT_UPG_PVT.g_sys.default_rate_type,
1018: PO_R12_CAT_UPG_PVT.g_sys.taxable_flag,
1019: PO_R12_CAT_UPG_PVT.g_sys.receiving_flag,
1020: PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_name_flag,
1021: PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_auth_flag,

Line 1018: PO_R12_CAT_UPG_PVT.g_sys.taxable_flag,

1014: PO_R12_CAT_UPG_PVT.g_sys.fob_lookup_code,
1015: PO_R12_CAT_UPG_PVT.g_sys.freight_terms_lookup_code,
1016: PO_R12_CAT_UPG_PVT.g_sys.terms_id,
1017: PO_R12_CAT_UPG_PVT.g_sys.default_rate_type,
1018: PO_R12_CAT_UPG_PVT.g_sys.taxable_flag,
1019: PO_R12_CAT_UPG_PVT.g_sys.receiving_flag,
1020: PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_name_flag,
1021: PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_auth_flag,
1022: PO_R12_CAT_UPG_PVT.g_sys.line_type_id,

Line 1019: PO_R12_CAT_UPG_PVT.g_sys.receiving_flag,

1015: PO_R12_CAT_UPG_PVT.g_sys.freight_terms_lookup_code,
1016: PO_R12_CAT_UPG_PVT.g_sys.terms_id,
1017: PO_R12_CAT_UPG_PVT.g_sys.default_rate_type,
1018: PO_R12_CAT_UPG_PVT.g_sys.taxable_flag,
1019: PO_R12_CAT_UPG_PVT.g_sys.receiving_flag,
1020: PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_name_flag,
1021: PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_auth_flag,
1022: PO_R12_CAT_UPG_PVT.g_sys.line_type_id,
1023: PO_R12_CAT_UPG_PVT.g_sys.manual_po_num_type,

Line 1020: PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_name_flag,

1016: PO_R12_CAT_UPG_PVT.g_sys.terms_id,
1017: PO_R12_CAT_UPG_PVT.g_sys.default_rate_type,
1018: PO_R12_CAT_UPG_PVT.g_sys.taxable_flag,
1019: PO_R12_CAT_UPG_PVT.g_sys.receiving_flag,
1020: PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_name_flag,
1021: PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_auth_flag,
1022: PO_R12_CAT_UPG_PVT.g_sys.line_type_id,
1023: PO_R12_CAT_UPG_PVT.g_sys.manual_po_num_type,
1024: PO_R12_CAT_UPG_PVT.g_sys.po_num_code,

Line 1021: PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_auth_flag,

1017: PO_R12_CAT_UPG_PVT.g_sys.default_rate_type,
1018: PO_R12_CAT_UPG_PVT.g_sys.taxable_flag,
1019: PO_R12_CAT_UPG_PVT.g_sys.receiving_flag,
1020: PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_name_flag,
1021: PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_auth_flag,
1022: PO_R12_CAT_UPG_PVT.g_sys.line_type_id,
1023: PO_R12_CAT_UPG_PVT.g_sys.manual_po_num_type,
1024: PO_R12_CAT_UPG_PVT.g_sys.po_num_code,
1025: PO_R12_CAT_UPG_PVT.g_sys.price_lookup_code,

Line 1022: PO_R12_CAT_UPG_PVT.g_sys.line_type_id,

1018: PO_R12_CAT_UPG_PVT.g_sys.taxable_flag,
1019: PO_R12_CAT_UPG_PVT.g_sys.receiving_flag,
1020: PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_name_flag,
1021: PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_auth_flag,
1022: PO_R12_CAT_UPG_PVT.g_sys.line_type_id,
1023: PO_R12_CAT_UPG_PVT.g_sys.manual_po_num_type,
1024: PO_R12_CAT_UPG_PVT.g_sys.po_num_code,
1025: PO_R12_CAT_UPG_PVT.g_sys.price_lookup_code,
1026: PO_R12_CAT_UPG_PVT.g_sys.invoice_close_tolerance,

Line 1023: PO_R12_CAT_UPG_PVT.g_sys.manual_po_num_type,

1019: PO_R12_CAT_UPG_PVT.g_sys.receiving_flag,
1020: PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_name_flag,
1021: PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_auth_flag,
1022: PO_R12_CAT_UPG_PVT.g_sys.line_type_id,
1023: PO_R12_CAT_UPG_PVT.g_sys.manual_po_num_type,
1024: PO_R12_CAT_UPG_PVT.g_sys.po_num_code,
1025: PO_R12_CAT_UPG_PVT.g_sys.price_lookup_code,
1026: PO_R12_CAT_UPG_PVT.g_sys.invoice_close_tolerance,
1027: PO_R12_CAT_UPG_PVT.g_sys.receive_close_tolerance,

Line 1024: PO_R12_CAT_UPG_PVT.g_sys.po_num_code,

1020: PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_name_flag,
1021: PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_auth_flag,
1022: PO_R12_CAT_UPG_PVT.g_sys.line_type_id,
1023: PO_R12_CAT_UPG_PVT.g_sys.manual_po_num_type,
1024: PO_R12_CAT_UPG_PVT.g_sys.po_num_code,
1025: PO_R12_CAT_UPG_PVT.g_sys.price_lookup_code,
1026: PO_R12_CAT_UPG_PVT.g_sys.invoice_close_tolerance,
1027: PO_R12_CAT_UPG_PVT.g_sys.receive_close_tolerance,
1028: PO_R12_CAT_UPG_PVT.g_sys.security_structure_id,

Line 1025: PO_R12_CAT_UPG_PVT.g_sys.price_lookup_code,

1021: PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_auth_flag,
1022: PO_R12_CAT_UPG_PVT.g_sys.line_type_id,
1023: PO_R12_CAT_UPG_PVT.g_sys.manual_po_num_type,
1024: PO_R12_CAT_UPG_PVT.g_sys.po_num_code,
1025: PO_R12_CAT_UPG_PVT.g_sys.price_lookup_code,
1026: PO_R12_CAT_UPG_PVT.g_sys.invoice_close_tolerance,
1027: PO_R12_CAT_UPG_PVT.g_sys.receive_close_tolerance,
1028: PO_R12_CAT_UPG_PVT.g_sys.security_structure_id,
1029: PO_R12_CAT_UPG_PVT.g_sys.expense_accrual_code,

Line 1026: PO_R12_CAT_UPG_PVT.g_sys.invoice_close_tolerance,

1022: PO_R12_CAT_UPG_PVT.g_sys.line_type_id,
1023: PO_R12_CAT_UPG_PVT.g_sys.manual_po_num_type,
1024: PO_R12_CAT_UPG_PVT.g_sys.po_num_code,
1025: PO_R12_CAT_UPG_PVT.g_sys.price_lookup_code,
1026: PO_R12_CAT_UPG_PVT.g_sys.invoice_close_tolerance,
1027: PO_R12_CAT_UPG_PVT.g_sys.receive_close_tolerance,
1028: PO_R12_CAT_UPG_PVT.g_sys.security_structure_id,
1029: PO_R12_CAT_UPG_PVT.g_sys.expense_accrual_code,
1030: PO_R12_CAT_UPG_PVT.g_sys.inv_org_id,

Line 1027: PO_R12_CAT_UPG_PVT.g_sys.receive_close_tolerance,

1023: PO_R12_CAT_UPG_PVT.g_sys.manual_po_num_type,
1024: PO_R12_CAT_UPG_PVT.g_sys.po_num_code,
1025: PO_R12_CAT_UPG_PVT.g_sys.price_lookup_code,
1026: PO_R12_CAT_UPG_PVT.g_sys.invoice_close_tolerance,
1027: PO_R12_CAT_UPG_PVT.g_sys.receive_close_tolerance,
1028: PO_R12_CAT_UPG_PVT.g_sys.security_structure_id,
1029: PO_R12_CAT_UPG_PVT.g_sys.expense_accrual_code,
1030: PO_R12_CAT_UPG_PVT.g_sys.inv_org_id,
1031: PO_R12_CAT_UPG_PVT.g_sys.rev_sort_ordering,

Line 1028: PO_R12_CAT_UPG_PVT.g_sys.security_structure_id,

1024: PO_R12_CAT_UPG_PVT.g_sys.po_num_code,
1025: PO_R12_CAT_UPG_PVT.g_sys.price_lookup_code,
1026: PO_R12_CAT_UPG_PVT.g_sys.invoice_close_tolerance,
1027: PO_R12_CAT_UPG_PVT.g_sys.receive_close_tolerance,
1028: PO_R12_CAT_UPG_PVT.g_sys.security_structure_id,
1029: PO_R12_CAT_UPG_PVT.g_sys.expense_accrual_code,
1030: PO_R12_CAT_UPG_PVT.g_sys.inv_org_id,
1031: PO_R12_CAT_UPG_PVT.g_sys.rev_sort_ordering,
1032: PO_R12_CAT_UPG_PVT.g_sys.min_rel_amount,

Line 1029: PO_R12_CAT_UPG_PVT.g_sys.expense_accrual_code,

1025: PO_R12_CAT_UPG_PVT.g_sys.price_lookup_code,
1026: PO_R12_CAT_UPG_PVT.g_sys.invoice_close_tolerance,
1027: PO_R12_CAT_UPG_PVT.g_sys.receive_close_tolerance,
1028: PO_R12_CAT_UPG_PVT.g_sys.security_structure_id,
1029: PO_R12_CAT_UPG_PVT.g_sys.expense_accrual_code,
1030: PO_R12_CAT_UPG_PVT.g_sys.inv_org_id,
1031: PO_R12_CAT_UPG_PVT.g_sys.rev_sort_ordering,
1032: PO_R12_CAT_UPG_PVT.g_sys.min_rel_amount,
1033: PO_R12_CAT_UPG_PVT.g_sys.notify_blanket_flag,

Line 1030: PO_R12_CAT_UPG_PVT.g_sys.inv_org_id,

1026: PO_R12_CAT_UPG_PVT.g_sys.invoice_close_tolerance,
1027: PO_R12_CAT_UPG_PVT.g_sys.receive_close_tolerance,
1028: PO_R12_CAT_UPG_PVT.g_sys.security_structure_id,
1029: PO_R12_CAT_UPG_PVT.g_sys.expense_accrual_code,
1030: PO_R12_CAT_UPG_PVT.g_sys.inv_org_id,
1031: PO_R12_CAT_UPG_PVT.g_sys.rev_sort_ordering,
1032: PO_R12_CAT_UPG_PVT.g_sys.min_rel_amount,
1033: PO_R12_CAT_UPG_PVT.g_sys.notify_blanket_flag,
1034: PO_R12_CAT_UPG_PVT.g_sys.budgetary_control_flag,

Line 1031: PO_R12_CAT_UPG_PVT.g_sys.rev_sort_ordering,

1027: PO_R12_CAT_UPG_PVT.g_sys.receive_close_tolerance,
1028: PO_R12_CAT_UPG_PVT.g_sys.security_structure_id,
1029: PO_R12_CAT_UPG_PVT.g_sys.expense_accrual_code,
1030: PO_R12_CAT_UPG_PVT.g_sys.inv_org_id,
1031: PO_R12_CAT_UPG_PVT.g_sys.rev_sort_ordering,
1032: PO_R12_CAT_UPG_PVT.g_sys.min_rel_amount,
1033: PO_R12_CAT_UPG_PVT.g_sys.notify_blanket_flag,
1034: PO_R12_CAT_UPG_PVT.g_sys.budgetary_control_flag,
1035: PO_R12_CAT_UPG_PVT.g_sys.user_defined_req_num_code,

Line 1032: PO_R12_CAT_UPG_PVT.g_sys.min_rel_amount,

1028: PO_R12_CAT_UPG_PVT.g_sys.security_structure_id,
1029: PO_R12_CAT_UPG_PVT.g_sys.expense_accrual_code,
1030: PO_R12_CAT_UPG_PVT.g_sys.inv_org_id,
1031: PO_R12_CAT_UPG_PVT.g_sys.rev_sort_ordering,
1032: PO_R12_CAT_UPG_PVT.g_sys.min_rel_amount,
1033: PO_R12_CAT_UPG_PVT.g_sys.notify_blanket_flag,
1034: PO_R12_CAT_UPG_PVT.g_sys.budgetary_control_flag,
1035: PO_R12_CAT_UPG_PVT.g_sys.user_defined_req_num_code,
1036: PO_R12_CAT_UPG_PVT.g_sys.rfq_required_flag,

Line 1033: PO_R12_CAT_UPG_PVT.g_sys.notify_blanket_flag,

1029: PO_R12_CAT_UPG_PVT.g_sys.expense_accrual_code,
1030: PO_R12_CAT_UPG_PVT.g_sys.inv_org_id,
1031: PO_R12_CAT_UPG_PVT.g_sys.rev_sort_ordering,
1032: PO_R12_CAT_UPG_PVT.g_sys.min_rel_amount,
1033: PO_R12_CAT_UPG_PVT.g_sys.notify_blanket_flag,
1034: PO_R12_CAT_UPG_PVT.g_sys.budgetary_control_flag,
1035: PO_R12_CAT_UPG_PVT.g_sys.user_defined_req_num_code,
1036: PO_R12_CAT_UPG_PVT.g_sys.rfq_required_flag,
1037: PO_R12_CAT_UPG_PVT.g_sys.manual_req_num_type,

Line 1034: PO_R12_CAT_UPG_PVT.g_sys.budgetary_control_flag,

1030: PO_R12_CAT_UPG_PVT.g_sys.inv_org_id,
1031: PO_R12_CAT_UPG_PVT.g_sys.rev_sort_ordering,
1032: PO_R12_CAT_UPG_PVT.g_sys.min_rel_amount,
1033: PO_R12_CAT_UPG_PVT.g_sys.notify_blanket_flag,
1034: PO_R12_CAT_UPG_PVT.g_sys.budgetary_control_flag,
1035: PO_R12_CAT_UPG_PVT.g_sys.user_defined_req_num_code,
1036: PO_R12_CAT_UPG_PVT.g_sys.rfq_required_flag,
1037: PO_R12_CAT_UPG_PVT.g_sys.manual_req_num_type,
1038: PO_R12_CAT_UPG_PVT.g_sys.enforce_full_lot_qty,

Line 1035: PO_R12_CAT_UPG_PVT.g_sys.user_defined_req_num_code,

1031: PO_R12_CAT_UPG_PVT.g_sys.rev_sort_ordering,
1032: PO_R12_CAT_UPG_PVT.g_sys.min_rel_amount,
1033: PO_R12_CAT_UPG_PVT.g_sys.notify_blanket_flag,
1034: PO_R12_CAT_UPG_PVT.g_sys.budgetary_control_flag,
1035: PO_R12_CAT_UPG_PVT.g_sys.user_defined_req_num_code,
1036: PO_R12_CAT_UPG_PVT.g_sys.rfq_required_flag,
1037: PO_R12_CAT_UPG_PVT.g_sys.manual_req_num_type,
1038: PO_R12_CAT_UPG_PVT.g_sys.enforce_full_lot_qty,
1039: PO_R12_CAT_UPG_PVT.g_sys.disposition_warning_flag,

Line 1036: PO_R12_CAT_UPG_PVT.g_sys.rfq_required_flag,

1032: PO_R12_CAT_UPG_PVT.g_sys.min_rel_amount,
1033: PO_R12_CAT_UPG_PVT.g_sys.notify_blanket_flag,
1034: PO_R12_CAT_UPG_PVT.g_sys.budgetary_control_flag,
1035: PO_R12_CAT_UPG_PVT.g_sys.user_defined_req_num_code,
1036: PO_R12_CAT_UPG_PVT.g_sys.rfq_required_flag,
1037: PO_R12_CAT_UPG_PVT.g_sys.manual_req_num_type,
1038: PO_R12_CAT_UPG_PVT.g_sys.enforce_full_lot_qty,
1039: PO_R12_CAT_UPG_PVT.g_sys.disposition_warning_flag,
1040: PO_R12_CAT_UPG_PVT.g_sys.reserve_at_completion_flag,

Line 1037: PO_R12_CAT_UPG_PVT.g_sys.manual_req_num_type,

1033: PO_R12_CAT_UPG_PVT.g_sys.notify_blanket_flag,
1034: PO_R12_CAT_UPG_PVT.g_sys.budgetary_control_flag,
1035: PO_R12_CAT_UPG_PVT.g_sys.user_defined_req_num_code,
1036: PO_R12_CAT_UPG_PVT.g_sys.rfq_required_flag,
1037: PO_R12_CAT_UPG_PVT.g_sys.manual_req_num_type,
1038: PO_R12_CAT_UPG_PVT.g_sys.enforce_full_lot_qty,
1039: PO_R12_CAT_UPG_PVT.g_sys.disposition_warning_flag,
1040: PO_R12_CAT_UPG_PVT.g_sys.reserve_at_completion_flag,
1041: PO_R12_CAT_UPG_PVT.g_sys.user_defined_rcpt_num_code,

Line 1038: PO_R12_CAT_UPG_PVT.g_sys.enforce_full_lot_qty,

1034: PO_R12_CAT_UPG_PVT.g_sys.budgetary_control_flag,
1035: PO_R12_CAT_UPG_PVT.g_sys.user_defined_req_num_code,
1036: PO_R12_CAT_UPG_PVT.g_sys.rfq_required_flag,
1037: PO_R12_CAT_UPG_PVT.g_sys.manual_req_num_type,
1038: PO_R12_CAT_UPG_PVT.g_sys.enforce_full_lot_qty,
1039: PO_R12_CAT_UPG_PVT.g_sys.disposition_warning_flag,
1040: PO_R12_CAT_UPG_PVT.g_sys.reserve_at_completion_flag,
1041: PO_R12_CAT_UPG_PVT.g_sys.user_defined_rcpt_num_code,
1042: PO_R12_CAT_UPG_PVT.g_sys.manual_rcpt_num_type,

Line 1039: PO_R12_CAT_UPG_PVT.g_sys.disposition_warning_flag,

1035: PO_R12_CAT_UPG_PVT.g_sys.user_defined_req_num_code,
1036: PO_R12_CAT_UPG_PVT.g_sys.rfq_required_flag,
1037: PO_R12_CAT_UPG_PVT.g_sys.manual_req_num_type,
1038: PO_R12_CAT_UPG_PVT.g_sys.enforce_full_lot_qty,
1039: PO_R12_CAT_UPG_PVT.g_sys.disposition_warning_flag,
1040: PO_R12_CAT_UPG_PVT.g_sys.reserve_at_completion_flag,
1041: PO_R12_CAT_UPG_PVT.g_sys.user_defined_rcpt_num_code,
1042: PO_R12_CAT_UPG_PVT.g_sys.manual_rcpt_num_type,
1043: PO_R12_CAT_UPG_PVT.g_sys.use_positions_flag,

Line 1040: PO_R12_CAT_UPG_PVT.g_sys.reserve_at_completion_flag,

1036: PO_R12_CAT_UPG_PVT.g_sys.rfq_required_flag,
1037: PO_R12_CAT_UPG_PVT.g_sys.manual_req_num_type,
1038: PO_R12_CAT_UPG_PVT.g_sys.enforce_full_lot_qty,
1039: PO_R12_CAT_UPG_PVT.g_sys.disposition_warning_flag,
1040: PO_R12_CAT_UPG_PVT.g_sys.reserve_at_completion_flag,
1041: PO_R12_CAT_UPG_PVT.g_sys.user_defined_rcpt_num_code,
1042: PO_R12_CAT_UPG_PVT.g_sys.manual_rcpt_num_type,
1043: PO_R12_CAT_UPG_PVT.g_sys.use_positions_flag,
1044: PO_R12_CAT_UPG_PVT.g_sys.default_quote_warning_delay,

Line 1041: PO_R12_CAT_UPG_PVT.g_sys.user_defined_rcpt_num_code,

1037: PO_R12_CAT_UPG_PVT.g_sys.manual_req_num_type,
1038: PO_R12_CAT_UPG_PVT.g_sys.enforce_full_lot_qty,
1039: PO_R12_CAT_UPG_PVT.g_sys.disposition_warning_flag,
1040: PO_R12_CAT_UPG_PVT.g_sys.reserve_at_completion_flag,
1041: PO_R12_CAT_UPG_PVT.g_sys.user_defined_rcpt_num_code,
1042: PO_R12_CAT_UPG_PVT.g_sys.manual_rcpt_num_type,
1043: PO_R12_CAT_UPG_PVT.g_sys.use_positions_flag,
1044: PO_R12_CAT_UPG_PVT.g_sys.default_quote_warning_delay,
1045: PO_R12_CAT_UPG_PVT.g_sys.inspection_required_flag,

Line 1042: PO_R12_CAT_UPG_PVT.g_sys.manual_rcpt_num_type,

1038: PO_R12_CAT_UPG_PVT.g_sys.enforce_full_lot_qty,
1039: PO_R12_CAT_UPG_PVT.g_sys.disposition_warning_flag,
1040: PO_R12_CAT_UPG_PVT.g_sys.reserve_at_completion_flag,
1041: PO_R12_CAT_UPG_PVT.g_sys.user_defined_rcpt_num_code,
1042: PO_R12_CAT_UPG_PVT.g_sys.manual_rcpt_num_type,
1043: PO_R12_CAT_UPG_PVT.g_sys.use_positions_flag,
1044: PO_R12_CAT_UPG_PVT.g_sys.default_quote_warning_delay,
1045: PO_R12_CAT_UPG_PVT.g_sys.inspection_required_flag,
1046: PO_R12_CAT_UPG_PVT.g_sys.user_defined_quote_num_code,

Line 1043: PO_R12_CAT_UPG_PVT.g_sys.use_positions_flag,

1039: PO_R12_CAT_UPG_PVT.g_sys.disposition_warning_flag,
1040: PO_R12_CAT_UPG_PVT.g_sys.reserve_at_completion_flag,
1041: PO_R12_CAT_UPG_PVT.g_sys.user_defined_rcpt_num_code,
1042: PO_R12_CAT_UPG_PVT.g_sys.manual_rcpt_num_type,
1043: PO_R12_CAT_UPG_PVT.g_sys.use_positions_flag,
1044: PO_R12_CAT_UPG_PVT.g_sys.default_quote_warning_delay,
1045: PO_R12_CAT_UPG_PVT.g_sys.inspection_required_flag,
1046: PO_R12_CAT_UPG_PVT.g_sys.user_defined_quote_num_code,
1047: PO_R12_CAT_UPG_PVT.g_sys.manual_quote_num_type,

Line 1044: PO_R12_CAT_UPG_PVT.g_sys.default_quote_warning_delay,

1040: PO_R12_CAT_UPG_PVT.g_sys.reserve_at_completion_flag,
1041: PO_R12_CAT_UPG_PVT.g_sys.user_defined_rcpt_num_code,
1042: PO_R12_CAT_UPG_PVT.g_sys.manual_rcpt_num_type,
1043: PO_R12_CAT_UPG_PVT.g_sys.use_positions_flag,
1044: PO_R12_CAT_UPG_PVT.g_sys.default_quote_warning_delay,
1045: PO_R12_CAT_UPG_PVT.g_sys.inspection_required_flag,
1046: PO_R12_CAT_UPG_PVT.g_sys.user_defined_quote_num_code,
1047: PO_R12_CAT_UPG_PVT.g_sys.manual_quote_num_type,
1048: PO_R12_CAT_UPG_PVT.g_sys.user_defined_rfq_num_code,

Line 1045: PO_R12_CAT_UPG_PVT.g_sys.inspection_required_flag,

1041: PO_R12_CAT_UPG_PVT.g_sys.user_defined_rcpt_num_code,
1042: PO_R12_CAT_UPG_PVT.g_sys.manual_rcpt_num_type,
1043: PO_R12_CAT_UPG_PVT.g_sys.use_positions_flag,
1044: PO_R12_CAT_UPG_PVT.g_sys.default_quote_warning_delay,
1045: PO_R12_CAT_UPG_PVT.g_sys.inspection_required_flag,
1046: PO_R12_CAT_UPG_PVT.g_sys.user_defined_quote_num_code,
1047: PO_R12_CAT_UPG_PVT.g_sys.manual_quote_num_type,
1048: PO_R12_CAT_UPG_PVT.g_sys.user_defined_rfq_num_code,
1049: PO_R12_CAT_UPG_PVT.g_sys.manual_rfq_num_type,

Line 1046: PO_R12_CAT_UPG_PVT.g_sys.user_defined_quote_num_code,

1042: PO_R12_CAT_UPG_PVT.g_sys.manual_rcpt_num_type,
1043: PO_R12_CAT_UPG_PVT.g_sys.use_positions_flag,
1044: PO_R12_CAT_UPG_PVT.g_sys.default_quote_warning_delay,
1045: PO_R12_CAT_UPG_PVT.g_sys.inspection_required_flag,
1046: PO_R12_CAT_UPG_PVT.g_sys.user_defined_quote_num_code,
1047: PO_R12_CAT_UPG_PVT.g_sys.manual_quote_num_type,
1048: PO_R12_CAT_UPG_PVT.g_sys.user_defined_rfq_num_code,
1049: PO_R12_CAT_UPG_PVT.g_sys.manual_rfq_num_type,
1050: PO_R12_CAT_UPG_PVT.g_sys.ship_via_lookup_code,

Line 1047: PO_R12_CAT_UPG_PVT.g_sys.manual_quote_num_type,

1043: PO_R12_CAT_UPG_PVT.g_sys.use_positions_flag,
1044: PO_R12_CAT_UPG_PVT.g_sys.default_quote_warning_delay,
1045: PO_R12_CAT_UPG_PVT.g_sys.inspection_required_flag,
1046: PO_R12_CAT_UPG_PVT.g_sys.user_defined_quote_num_code,
1047: PO_R12_CAT_UPG_PVT.g_sys.manual_quote_num_type,
1048: PO_R12_CAT_UPG_PVT.g_sys.user_defined_rfq_num_code,
1049: PO_R12_CAT_UPG_PVT.g_sys.manual_rfq_num_type,
1050: PO_R12_CAT_UPG_PVT.g_sys.ship_via_lookup_code,
1051: PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_tolerance

Line 1048: PO_R12_CAT_UPG_PVT.g_sys.user_defined_rfq_num_code,

1044: PO_R12_CAT_UPG_PVT.g_sys.default_quote_warning_delay,
1045: PO_R12_CAT_UPG_PVT.g_sys.inspection_required_flag,
1046: PO_R12_CAT_UPG_PVT.g_sys.user_defined_quote_num_code,
1047: PO_R12_CAT_UPG_PVT.g_sys.manual_quote_num_type,
1048: PO_R12_CAT_UPG_PVT.g_sys.user_defined_rfq_num_code,
1049: PO_R12_CAT_UPG_PVT.g_sys.manual_rfq_num_type,
1050: PO_R12_CAT_UPG_PVT.g_sys.ship_via_lookup_code,
1051: PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_tolerance
1052: FROM FINANCIALS_SYSTEM_PARAMS_ALL FSPA,

Line 1049: PO_R12_CAT_UPG_PVT.g_sys.manual_rfq_num_type,

1045: PO_R12_CAT_UPG_PVT.g_sys.inspection_required_flag,
1046: PO_R12_CAT_UPG_PVT.g_sys.user_defined_quote_num_code,
1047: PO_R12_CAT_UPG_PVT.g_sys.manual_quote_num_type,
1048: PO_R12_CAT_UPG_PVT.g_sys.user_defined_rfq_num_code,
1049: PO_R12_CAT_UPG_PVT.g_sys.manual_rfq_num_type,
1050: PO_R12_CAT_UPG_PVT.g_sys.ship_via_lookup_code,
1051: PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_tolerance
1052: FROM FINANCIALS_SYSTEM_PARAMS_ALL FSPA,
1053: GL_SETS_OF_BOOKS SOB,

Line 1050: PO_R12_CAT_UPG_PVT.g_sys.ship_via_lookup_code,

1046: PO_R12_CAT_UPG_PVT.g_sys.user_defined_quote_num_code,
1047: PO_R12_CAT_UPG_PVT.g_sys.manual_quote_num_type,
1048: PO_R12_CAT_UPG_PVT.g_sys.user_defined_rfq_num_code,
1049: PO_R12_CAT_UPG_PVT.g_sys.manual_rfq_num_type,
1050: PO_R12_CAT_UPG_PVT.g_sys.ship_via_lookup_code,
1051: PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_tolerance
1052: FROM FINANCIALS_SYSTEM_PARAMS_ALL FSPA,
1053: GL_SETS_OF_BOOKS SOB,
1054: PO_SYSTEM_PARAMETERS_ALL PSPA,

Line 1051: PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_tolerance

1047: PO_R12_CAT_UPG_PVT.g_sys.manual_quote_num_type,
1048: PO_R12_CAT_UPG_PVT.g_sys.user_defined_rfq_num_code,
1049: PO_R12_CAT_UPG_PVT.g_sys.manual_rfq_num_type,
1050: PO_R12_CAT_UPG_PVT.g_sys.ship_via_lookup_code,
1051: PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_tolerance
1052: FROM FINANCIALS_SYSTEM_PARAMS_ALL FSPA,
1053: GL_SETS_OF_BOOKS SOB,
1054: PO_SYSTEM_PARAMETERS_ALL PSPA,
1055: RCV_PARAMETERS RCV

Line 1058: AND PSPA.org_id = PO_R12_CAT_UPG_PVT.g_job.org_id

1054: PO_SYSTEM_PARAMETERS_ALL PSPA,
1055: RCV_PARAMETERS RCV
1056: WHERE FSPA.set_of_books_id = SOB.set_of_books_id
1057: AND RCV.organization_id (+) = FSPA.inventory_organization_id
1058: AND PSPA.org_id = PO_R12_CAT_UPG_PVT.g_job.org_id
1059: AND FSPA.org_id = PO_R12_CAT_UPG_PVT.g_job.org_id;
1060:
1061: SELECT master_organization_id
1062: INTO PO_R12_CAT_UPG_PVT.g_sys.master_inv_org_id

Line 1059: AND FSPA.org_id = PO_R12_CAT_UPG_PVT.g_job.org_id;

1055: RCV_PARAMETERS RCV
1056: WHERE FSPA.set_of_books_id = SOB.set_of_books_id
1057: AND RCV.organization_id (+) = FSPA.inventory_organization_id
1058: AND PSPA.org_id = PO_R12_CAT_UPG_PVT.g_job.org_id
1059: AND FSPA.org_id = PO_R12_CAT_UPG_PVT.g_job.org_id;
1060:
1061: SELECT master_organization_id
1062: INTO PO_R12_CAT_UPG_PVT.g_sys.master_inv_org_id
1063: FROM MTL_PARAMETERS

Line 1062: INTO PO_R12_CAT_UPG_PVT.g_sys.master_inv_org_id

1058: AND PSPA.org_id = PO_R12_CAT_UPG_PVT.g_job.org_id
1059: AND FSPA.org_id = PO_R12_CAT_UPG_PVT.g_job.org_id;
1060:
1061: SELECT master_organization_id
1062: INTO PO_R12_CAT_UPG_PVT.g_sys.master_inv_org_id
1063: FROM MTL_PARAMETERS
1064: WHERE organization_id = PO_R12_CAT_UPG_PVT.g_sys.inv_org_id;
1065:
1066: IF g_debug THEN

Line 1064: WHERE organization_id = PO_R12_CAT_UPG_PVT.g_sys.inv_org_id;

1060:
1061: SELECT master_organization_id
1062: INTO PO_R12_CAT_UPG_PVT.g_sys.master_inv_org_id
1063: FROM MTL_PARAMETERS
1064: WHERE organization_id = PO_R12_CAT_UPG_PVT.g_sys.inv_org_id;
1065:
1066: IF g_debug THEN
1067: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default currency_code='||PO_R12_CAT_UPG_PVT.g_sys.currency_code);
1068: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default coa_id='||PO_R12_CAT_UPG_PVT.g_sys.coa_id);

Line 1067: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default currency_code='||PO_R12_CAT_UPG_PVT.g_sys.currency_code);

1063: FROM MTL_PARAMETERS
1064: WHERE organization_id = PO_R12_CAT_UPG_PVT.g_sys.inv_org_id;
1065:
1066: IF g_debug THEN
1067: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default currency_code='||PO_R12_CAT_UPG_PVT.g_sys.currency_code);
1068: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default coa_id='||PO_R12_CAT_UPG_PVT.g_sys.coa_id);
1069: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default po_encumberance_flag='||PO_R12_CAT_UPG_PVT.g_sys.po_encumberance_flag);
1070: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default req_encumberance_flag='||PO_R12_CAT_UPG_PVT.g_sys.req_encumberance_flag);
1071: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default sob_id='||PO_R12_CAT_UPG_PVT.g_sys.sob_id);

Line 1068: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default coa_id='||PO_R12_CAT_UPG_PVT.g_sys.coa_id);

1064: WHERE organization_id = PO_R12_CAT_UPG_PVT.g_sys.inv_org_id;
1065:
1066: IF g_debug THEN
1067: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default currency_code='||PO_R12_CAT_UPG_PVT.g_sys.currency_code);
1068: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default coa_id='||PO_R12_CAT_UPG_PVT.g_sys.coa_id);
1069: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default po_encumberance_flag='||PO_R12_CAT_UPG_PVT.g_sys.po_encumberance_flag);
1070: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default req_encumberance_flag='||PO_R12_CAT_UPG_PVT.g_sys.req_encumberance_flag);
1071: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default sob_id='||PO_R12_CAT_UPG_PVT.g_sys.sob_id);
1072: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default ship_to_location_id='||PO_R12_CAT_UPG_PVT.g_sys.ship_to_location_id);

Line 1069: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default po_encumberance_flag='||PO_R12_CAT_UPG_PVT.g_sys.po_encumberance_flag);

1065:
1066: IF g_debug THEN
1067: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default currency_code='||PO_R12_CAT_UPG_PVT.g_sys.currency_code);
1068: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default coa_id='||PO_R12_CAT_UPG_PVT.g_sys.coa_id);
1069: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default po_encumberance_flag='||PO_R12_CAT_UPG_PVT.g_sys.po_encumberance_flag);
1070: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default req_encumberance_flag='||PO_R12_CAT_UPG_PVT.g_sys.req_encumberance_flag);
1071: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default sob_id='||PO_R12_CAT_UPG_PVT.g_sys.sob_id);
1072: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default ship_to_location_id='||PO_R12_CAT_UPG_PVT.g_sys.ship_to_location_id);
1073: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default bill_to_location_id='||PO_R12_CAT_UPG_PVT.g_sys.bill_to_location_id);

Line 1070: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default req_encumberance_flag='||PO_R12_CAT_UPG_PVT.g_sys.req_encumberance_flag);

1066: IF g_debug THEN
1067: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default currency_code='||PO_R12_CAT_UPG_PVT.g_sys.currency_code);
1068: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default coa_id='||PO_R12_CAT_UPG_PVT.g_sys.coa_id);
1069: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default po_encumberance_flag='||PO_R12_CAT_UPG_PVT.g_sys.po_encumberance_flag);
1070: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default req_encumberance_flag='||PO_R12_CAT_UPG_PVT.g_sys.req_encumberance_flag);
1071: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default sob_id='||PO_R12_CAT_UPG_PVT.g_sys.sob_id);
1072: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default ship_to_location_id='||PO_R12_CAT_UPG_PVT.g_sys.ship_to_location_id);
1073: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default bill_to_location_id='||PO_R12_CAT_UPG_PVT.g_sys.bill_to_location_id);
1074: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default fob_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.fob_lookup_code);

Line 1071: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default sob_id='||PO_R12_CAT_UPG_PVT.g_sys.sob_id);

1067: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default currency_code='||PO_R12_CAT_UPG_PVT.g_sys.currency_code);
1068: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default coa_id='||PO_R12_CAT_UPG_PVT.g_sys.coa_id);
1069: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default po_encumberance_flag='||PO_R12_CAT_UPG_PVT.g_sys.po_encumberance_flag);
1070: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default req_encumberance_flag='||PO_R12_CAT_UPG_PVT.g_sys.req_encumberance_flag);
1071: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default sob_id='||PO_R12_CAT_UPG_PVT.g_sys.sob_id);
1072: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default ship_to_location_id='||PO_R12_CAT_UPG_PVT.g_sys.ship_to_location_id);
1073: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default bill_to_location_id='||PO_R12_CAT_UPG_PVT.g_sys.bill_to_location_id);
1074: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default fob_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.fob_lookup_code);
1075: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default freight_terms_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.freight_terms_lookup_code);

Line 1072: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default ship_to_location_id='||PO_R12_CAT_UPG_PVT.g_sys.ship_to_location_id);

1068: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default coa_id='||PO_R12_CAT_UPG_PVT.g_sys.coa_id);
1069: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default po_encumberance_flag='||PO_R12_CAT_UPG_PVT.g_sys.po_encumberance_flag);
1070: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default req_encumberance_flag='||PO_R12_CAT_UPG_PVT.g_sys.req_encumberance_flag);
1071: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default sob_id='||PO_R12_CAT_UPG_PVT.g_sys.sob_id);
1072: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default ship_to_location_id='||PO_R12_CAT_UPG_PVT.g_sys.ship_to_location_id);
1073: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default bill_to_location_id='||PO_R12_CAT_UPG_PVT.g_sys.bill_to_location_id);
1074: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default fob_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.fob_lookup_code);
1075: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default freight_terms_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.freight_terms_lookup_code);
1076: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default terms_id='||PO_R12_CAT_UPG_PVT.g_sys.terms_id);

Line 1073: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default bill_to_location_id='||PO_R12_CAT_UPG_PVT.g_sys.bill_to_location_id);

1069: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default po_encumberance_flag='||PO_R12_CAT_UPG_PVT.g_sys.po_encumberance_flag);
1070: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default req_encumberance_flag='||PO_R12_CAT_UPG_PVT.g_sys.req_encumberance_flag);
1071: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default sob_id='||PO_R12_CAT_UPG_PVT.g_sys.sob_id);
1072: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default ship_to_location_id='||PO_R12_CAT_UPG_PVT.g_sys.ship_to_location_id);
1073: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default bill_to_location_id='||PO_R12_CAT_UPG_PVT.g_sys.bill_to_location_id);
1074: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default fob_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.fob_lookup_code);
1075: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default freight_terms_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.freight_terms_lookup_code);
1076: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default terms_id='||PO_R12_CAT_UPG_PVT.g_sys.terms_id);
1077: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default default_rate_type='||PO_R12_CAT_UPG_PVT.g_sys.default_rate_type);

Line 1074: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default fob_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.fob_lookup_code);

1070: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default req_encumberance_flag='||PO_R12_CAT_UPG_PVT.g_sys.req_encumberance_flag);
1071: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default sob_id='||PO_R12_CAT_UPG_PVT.g_sys.sob_id);
1072: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default ship_to_location_id='||PO_R12_CAT_UPG_PVT.g_sys.ship_to_location_id);
1073: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default bill_to_location_id='||PO_R12_CAT_UPG_PVT.g_sys.bill_to_location_id);
1074: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default fob_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.fob_lookup_code);
1075: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default freight_terms_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.freight_terms_lookup_code);
1076: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default terms_id='||PO_R12_CAT_UPG_PVT.g_sys.terms_id);
1077: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default default_rate_type='||PO_R12_CAT_UPG_PVT.g_sys.default_rate_type);
1078: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default taxable_flag='||PO_R12_CAT_UPG_PVT.g_sys.taxable_flag);

Line 1075: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default freight_terms_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.freight_terms_lookup_code);

1071: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default sob_id='||PO_R12_CAT_UPG_PVT.g_sys.sob_id);
1072: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default ship_to_location_id='||PO_R12_CAT_UPG_PVT.g_sys.ship_to_location_id);
1073: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default bill_to_location_id='||PO_R12_CAT_UPG_PVT.g_sys.bill_to_location_id);
1074: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default fob_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.fob_lookup_code);
1075: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default freight_terms_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.freight_terms_lookup_code);
1076: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default terms_id='||PO_R12_CAT_UPG_PVT.g_sys.terms_id);
1077: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default default_rate_type='||PO_R12_CAT_UPG_PVT.g_sys.default_rate_type);
1078: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default taxable_flag='||PO_R12_CAT_UPG_PVT.g_sys.taxable_flag);
1079: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default receiving_flag='||PO_R12_CAT_UPG_PVT.g_sys.receiving_flag);

Line 1076: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default terms_id='||PO_R12_CAT_UPG_PVT.g_sys.terms_id);

1072: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default ship_to_location_id='||PO_R12_CAT_UPG_PVT.g_sys.ship_to_location_id);
1073: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default bill_to_location_id='||PO_R12_CAT_UPG_PVT.g_sys.bill_to_location_id);
1074: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default fob_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.fob_lookup_code);
1075: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default freight_terms_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.freight_terms_lookup_code);
1076: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default terms_id='||PO_R12_CAT_UPG_PVT.g_sys.terms_id);
1077: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default default_rate_type='||PO_R12_CAT_UPG_PVT.g_sys.default_rate_type);
1078: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default taxable_flag='||PO_R12_CAT_UPG_PVT.g_sys.taxable_flag);
1079: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default receiving_flag='||PO_R12_CAT_UPG_PVT.g_sys.receiving_flag);
1080: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default enforce_buyer_name_flag='||PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_name_flag);

Line 1077: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default default_rate_type='||PO_R12_CAT_UPG_PVT.g_sys.default_rate_type);

1073: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default bill_to_location_id='||PO_R12_CAT_UPG_PVT.g_sys.bill_to_location_id);
1074: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default fob_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.fob_lookup_code);
1075: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default freight_terms_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.freight_terms_lookup_code);
1076: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default terms_id='||PO_R12_CAT_UPG_PVT.g_sys.terms_id);
1077: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default default_rate_type='||PO_R12_CAT_UPG_PVT.g_sys.default_rate_type);
1078: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default taxable_flag='||PO_R12_CAT_UPG_PVT.g_sys.taxable_flag);
1079: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default receiving_flag='||PO_R12_CAT_UPG_PVT.g_sys.receiving_flag);
1080: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default enforce_buyer_name_flag='||PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_name_flag);
1081: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default enforce_buyer_auth_flag='||PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_auth_flag);

Line 1078: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default taxable_flag='||PO_R12_CAT_UPG_PVT.g_sys.taxable_flag);

1074: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default fob_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.fob_lookup_code);
1075: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default freight_terms_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.freight_terms_lookup_code);
1076: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default terms_id='||PO_R12_CAT_UPG_PVT.g_sys.terms_id);
1077: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default default_rate_type='||PO_R12_CAT_UPG_PVT.g_sys.default_rate_type);
1078: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default taxable_flag='||PO_R12_CAT_UPG_PVT.g_sys.taxable_flag);
1079: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default receiving_flag='||PO_R12_CAT_UPG_PVT.g_sys.receiving_flag);
1080: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default enforce_buyer_name_flag='||PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_name_flag);
1081: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default enforce_buyer_auth_flag='||PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_auth_flag);
1082: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default line_type_id='||PO_R12_CAT_UPG_PVT.g_sys.line_type_id);

Line 1079: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default receiving_flag='||PO_R12_CAT_UPG_PVT.g_sys.receiving_flag);

1075: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default freight_terms_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.freight_terms_lookup_code);
1076: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default terms_id='||PO_R12_CAT_UPG_PVT.g_sys.terms_id);
1077: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default default_rate_type='||PO_R12_CAT_UPG_PVT.g_sys.default_rate_type);
1078: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default taxable_flag='||PO_R12_CAT_UPG_PVT.g_sys.taxable_flag);
1079: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default receiving_flag='||PO_R12_CAT_UPG_PVT.g_sys.receiving_flag);
1080: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default enforce_buyer_name_flag='||PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_name_flag);
1081: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default enforce_buyer_auth_flag='||PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_auth_flag);
1082: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default line_type_id='||PO_R12_CAT_UPG_PVT.g_sys.line_type_id);
1083: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_po_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_po_num_type);

Line 1080: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default enforce_buyer_name_flag='||PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_name_flag);

1076: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default terms_id='||PO_R12_CAT_UPG_PVT.g_sys.terms_id);
1077: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default default_rate_type='||PO_R12_CAT_UPG_PVT.g_sys.default_rate_type);
1078: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default taxable_flag='||PO_R12_CAT_UPG_PVT.g_sys.taxable_flag);
1079: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default receiving_flag='||PO_R12_CAT_UPG_PVT.g_sys.receiving_flag);
1080: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default enforce_buyer_name_flag='||PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_name_flag);
1081: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default enforce_buyer_auth_flag='||PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_auth_flag);
1082: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default line_type_id='||PO_R12_CAT_UPG_PVT.g_sys.line_type_id);
1083: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_po_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_po_num_type);
1084: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default po_num_code='||PO_R12_CAT_UPG_PVT.g_sys.po_num_code);

Line 1081: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default enforce_buyer_auth_flag='||PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_auth_flag);

1077: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default default_rate_type='||PO_R12_CAT_UPG_PVT.g_sys.default_rate_type);
1078: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default taxable_flag='||PO_R12_CAT_UPG_PVT.g_sys.taxable_flag);
1079: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default receiving_flag='||PO_R12_CAT_UPG_PVT.g_sys.receiving_flag);
1080: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default enforce_buyer_name_flag='||PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_name_flag);
1081: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default enforce_buyer_auth_flag='||PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_auth_flag);
1082: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default line_type_id='||PO_R12_CAT_UPG_PVT.g_sys.line_type_id);
1083: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_po_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_po_num_type);
1084: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default po_num_code='||PO_R12_CAT_UPG_PVT.g_sys.po_num_code);
1085: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default price_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.price_lookup_code);

Line 1082: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default line_type_id='||PO_R12_CAT_UPG_PVT.g_sys.line_type_id);

1078: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default taxable_flag='||PO_R12_CAT_UPG_PVT.g_sys.taxable_flag);
1079: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default receiving_flag='||PO_R12_CAT_UPG_PVT.g_sys.receiving_flag);
1080: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default enforce_buyer_name_flag='||PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_name_flag);
1081: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default enforce_buyer_auth_flag='||PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_auth_flag);
1082: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default line_type_id='||PO_R12_CAT_UPG_PVT.g_sys.line_type_id);
1083: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_po_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_po_num_type);
1084: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default po_num_code='||PO_R12_CAT_UPG_PVT.g_sys.po_num_code);
1085: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default price_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.price_lookup_code);
1086: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default invoice_close_tolerance='||PO_R12_CAT_UPG_PVT.g_sys.invoice_close_tolerance);

Line 1083: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_po_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_po_num_type);

1079: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default receiving_flag='||PO_R12_CAT_UPG_PVT.g_sys.receiving_flag);
1080: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default enforce_buyer_name_flag='||PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_name_flag);
1081: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default enforce_buyer_auth_flag='||PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_auth_flag);
1082: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default line_type_id='||PO_R12_CAT_UPG_PVT.g_sys.line_type_id);
1083: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_po_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_po_num_type);
1084: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default po_num_code='||PO_R12_CAT_UPG_PVT.g_sys.po_num_code);
1085: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default price_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.price_lookup_code);
1086: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default invoice_close_tolerance='||PO_R12_CAT_UPG_PVT.g_sys.invoice_close_tolerance);
1087: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default receive_close_tolerance='||PO_R12_CAT_UPG_PVT.g_sys.receive_close_tolerance);

Line 1084: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default po_num_code='||PO_R12_CAT_UPG_PVT.g_sys.po_num_code);

1080: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default enforce_buyer_name_flag='||PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_name_flag);
1081: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default enforce_buyer_auth_flag='||PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_auth_flag);
1082: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default line_type_id='||PO_R12_CAT_UPG_PVT.g_sys.line_type_id);
1083: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_po_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_po_num_type);
1084: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default po_num_code='||PO_R12_CAT_UPG_PVT.g_sys.po_num_code);
1085: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default price_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.price_lookup_code);
1086: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default invoice_close_tolerance='||PO_R12_CAT_UPG_PVT.g_sys.invoice_close_tolerance);
1087: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default receive_close_tolerance='||PO_R12_CAT_UPG_PVT.g_sys.receive_close_tolerance);
1088: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default security_structure_id='||PO_R12_CAT_UPG_PVT.g_sys.security_structure_id);

Line 1085: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default price_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.price_lookup_code);

1081: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default enforce_buyer_auth_flag='||PO_R12_CAT_UPG_PVT.g_sys.enforce_buyer_auth_flag);
1082: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default line_type_id='||PO_R12_CAT_UPG_PVT.g_sys.line_type_id);
1083: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_po_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_po_num_type);
1084: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default po_num_code='||PO_R12_CAT_UPG_PVT.g_sys.po_num_code);
1085: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default price_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.price_lookup_code);
1086: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default invoice_close_tolerance='||PO_R12_CAT_UPG_PVT.g_sys.invoice_close_tolerance);
1087: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default receive_close_tolerance='||PO_R12_CAT_UPG_PVT.g_sys.receive_close_tolerance);
1088: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default security_structure_id='||PO_R12_CAT_UPG_PVT.g_sys.security_structure_id);
1089: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default expense_accrual_code='||PO_R12_CAT_UPG_PVT.g_sys.expense_accrual_code);

Line 1086: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default invoice_close_tolerance='||PO_R12_CAT_UPG_PVT.g_sys.invoice_close_tolerance);

1082: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default line_type_id='||PO_R12_CAT_UPG_PVT.g_sys.line_type_id);
1083: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_po_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_po_num_type);
1084: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default po_num_code='||PO_R12_CAT_UPG_PVT.g_sys.po_num_code);
1085: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default price_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.price_lookup_code);
1086: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default invoice_close_tolerance='||PO_R12_CAT_UPG_PVT.g_sys.invoice_close_tolerance);
1087: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default receive_close_tolerance='||PO_R12_CAT_UPG_PVT.g_sys.receive_close_tolerance);
1088: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default security_structure_id='||PO_R12_CAT_UPG_PVT.g_sys.security_structure_id);
1089: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default expense_accrual_code='||PO_R12_CAT_UPG_PVT.g_sys.expense_accrual_code);
1090: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default inv_org_id='||PO_R12_CAT_UPG_PVT.g_sys.inv_org_id);

Line 1087: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default receive_close_tolerance='||PO_R12_CAT_UPG_PVT.g_sys.receive_close_tolerance);

1083: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_po_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_po_num_type);
1084: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default po_num_code='||PO_R12_CAT_UPG_PVT.g_sys.po_num_code);
1085: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default price_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.price_lookup_code);
1086: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default invoice_close_tolerance='||PO_R12_CAT_UPG_PVT.g_sys.invoice_close_tolerance);
1087: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default receive_close_tolerance='||PO_R12_CAT_UPG_PVT.g_sys.receive_close_tolerance);
1088: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default security_structure_id='||PO_R12_CAT_UPG_PVT.g_sys.security_structure_id);
1089: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default expense_accrual_code='||PO_R12_CAT_UPG_PVT.g_sys.expense_accrual_code);
1090: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default inv_org_id='||PO_R12_CAT_UPG_PVT.g_sys.inv_org_id);
1091: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default rev_sort_ordering='||PO_R12_CAT_UPG_PVT.g_sys.rev_sort_ordering);

Line 1088: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default security_structure_id='||PO_R12_CAT_UPG_PVT.g_sys.security_structure_id);

1084: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default po_num_code='||PO_R12_CAT_UPG_PVT.g_sys.po_num_code);
1085: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default price_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.price_lookup_code);
1086: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default invoice_close_tolerance='||PO_R12_CAT_UPG_PVT.g_sys.invoice_close_tolerance);
1087: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default receive_close_tolerance='||PO_R12_CAT_UPG_PVT.g_sys.receive_close_tolerance);
1088: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default security_structure_id='||PO_R12_CAT_UPG_PVT.g_sys.security_structure_id);
1089: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default expense_accrual_code='||PO_R12_CAT_UPG_PVT.g_sys.expense_accrual_code);
1090: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default inv_org_id='||PO_R12_CAT_UPG_PVT.g_sys.inv_org_id);
1091: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default rev_sort_ordering='||PO_R12_CAT_UPG_PVT.g_sys.rev_sort_ordering);
1092: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default min_rel_amount='||PO_R12_CAT_UPG_PVT.g_sys.min_rel_amount);

Line 1089: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default expense_accrual_code='||PO_R12_CAT_UPG_PVT.g_sys.expense_accrual_code);

1085: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default price_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.price_lookup_code);
1086: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default invoice_close_tolerance='||PO_R12_CAT_UPG_PVT.g_sys.invoice_close_tolerance);
1087: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default receive_close_tolerance='||PO_R12_CAT_UPG_PVT.g_sys.receive_close_tolerance);
1088: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default security_structure_id='||PO_R12_CAT_UPG_PVT.g_sys.security_structure_id);
1089: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default expense_accrual_code='||PO_R12_CAT_UPG_PVT.g_sys.expense_accrual_code);
1090: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default inv_org_id='||PO_R12_CAT_UPG_PVT.g_sys.inv_org_id);
1091: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default rev_sort_ordering='||PO_R12_CAT_UPG_PVT.g_sys.rev_sort_ordering);
1092: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default min_rel_amount='||PO_R12_CAT_UPG_PVT.g_sys.min_rel_amount);
1093: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default notify_blanket_flag='||PO_R12_CAT_UPG_PVT.g_sys.notify_blanket_flag);

Line 1090: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default inv_org_id='||PO_R12_CAT_UPG_PVT.g_sys.inv_org_id);

1086: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default invoice_close_tolerance='||PO_R12_CAT_UPG_PVT.g_sys.invoice_close_tolerance);
1087: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default receive_close_tolerance='||PO_R12_CAT_UPG_PVT.g_sys.receive_close_tolerance);
1088: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default security_structure_id='||PO_R12_CAT_UPG_PVT.g_sys.security_structure_id);
1089: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default expense_accrual_code='||PO_R12_CAT_UPG_PVT.g_sys.expense_accrual_code);
1090: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default inv_org_id='||PO_R12_CAT_UPG_PVT.g_sys.inv_org_id);
1091: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default rev_sort_ordering='||PO_R12_CAT_UPG_PVT.g_sys.rev_sort_ordering);
1092: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default min_rel_amount='||PO_R12_CAT_UPG_PVT.g_sys.min_rel_amount);
1093: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default notify_blanket_flag='||PO_R12_CAT_UPG_PVT.g_sys.notify_blanket_flag);
1094: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default budgetary_control_flag='||PO_R12_CAT_UPG_PVT.g_sys.budgetary_control_flag);

Line 1091: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default rev_sort_ordering='||PO_R12_CAT_UPG_PVT.g_sys.rev_sort_ordering);

1087: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default receive_close_tolerance='||PO_R12_CAT_UPG_PVT.g_sys.receive_close_tolerance);
1088: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default security_structure_id='||PO_R12_CAT_UPG_PVT.g_sys.security_structure_id);
1089: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default expense_accrual_code='||PO_R12_CAT_UPG_PVT.g_sys.expense_accrual_code);
1090: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default inv_org_id='||PO_R12_CAT_UPG_PVT.g_sys.inv_org_id);
1091: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default rev_sort_ordering='||PO_R12_CAT_UPG_PVT.g_sys.rev_sort_ordering);
1092: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default min_rel_amount='||PO_R12_CAT_UPG_PVT.g_sys.min_rel_amount);
1093: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default notify_blanket_flag='||PO_R12_CAT_UPG_PVT.g_sys.notify_blanket_flag);
1094: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default budgetary_control_flag='||PO_R12_CAT_UPG_PVT.g_sys.budgetary_control_flag);
1095: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_req_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_req_num_code);

Line 1092: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default min_rel_amount='||PO_R12_CAT_UPG_PVT.g_sys.min_rel_amount);

1088: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default security_structure_id='||PO_R12_CAT_UPG_PVT.g_sys.security_structure_id);
1089: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default expense_accrual_code='||PO_R12_CAT_UPG_PVT.g_sys.expense_accrual_code);
1090: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default inv_org_id='||PO_R12_CAT_UPG_PVT.g_sys.inv_org_id);
1091: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default rev_sort_ordering='||PO_R12_CAT_UPG_PVT.g_sys.rev_sort_ordering);
1092: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default min_rel_amount='||PO_R12_CAT_UPG_PVT.g_sys.min_rel_amount);
1093: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default notify_blanket_flag='||PO_R12_CAT_UPG_PVT.g_sys.notify_blanket_flag);
1094: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default budgetary_control_flag='||PO_R12_CAT_UPG_PVT.g_sys.budgetary_control_flag);
1095: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_req_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_req_num_code);
1096: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default rfq_required_flag='||PO_R12_CAT_UPG_PVT.g_sys.rfq_required_flag);

Line 1093: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default notify_blanket_flag='||PO_R12_CAT_UPG_PVT.g_sys.notify_blanket_flag);

1089: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default expense_accrual_code='||PO_R12_CAT_UPG_PVT.g_sys.expense_accrual_code);
1090: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default inv_org_id='||PO_R12_CAT_UPG_PVT.g_sys.inv_org_id);
1091: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default rev_sort_ordering='||PO_R12_CAT_UPG_PVT.g_sys.rev_sort_ordering);
1092: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default min_rel_amount='||PO_R12_CAT_UPG_PVT.g_sys.min_rel_amount);
1093: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default notify_blanket_flag='||PO_R12_CAT_UPG_PVT.g_sys.notify_blanket_flag);
1094: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default budgetary_control_flag='||PO_R12_CAT_UPG_PVT.g_sys.budgetary_control_flag);
1095: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_req_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_req_num_code);
1096: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default rfq_required_flag='||PO_R12_CAT_UPG_PVT.g_sys.rfq_required_flag);
1097: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_req_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_req_num_type);

Line 1094: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default budgetary_control_flag='||PO_R12_CAT_UPG_PVT.g_sys.budgetary_control_flag);

1090: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default inv_org_id='||PO_R12_CAT_UPG_PVT.g_sys.inv_org_id);
1091: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default rev_sort_ordering='||PO_R12_CAT_UPG_PVT.g_sys.rev_sort_ordering);
1092: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default min_rel_amount='||PO_R12_CAT_UPG_PVT.g_sys.min_rel_amount);
1093: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default notify_blanket_flag='||PO_R12_CAT_UPG_PVT.g_sys.notify_blanket_flag);
1094: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default budgetary_control_flag='||PO_R12_CAT_UPG_PVT.g_sys.budgetary_control_flag);
1095: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_req_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_req_num_code);
1096: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default rfq_required_flag='||PO_R12_CAT_UPG_PVT.g_sys.rfq_required_flag);
1097: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_req_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_req_num_type);
1098: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default enforce_full_lot_qty='||PO_R12_CAT_UPG_PVT.g_sys.enforce_full_lot_qty);

Line 1095: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_req_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_req_num_code);

1091: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default rev_sort_ordering='||PO_R12_CAT_UPG_PVT.g_sys.rev_sort_ordering);
1092: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default min_rel_amount='||PO_R12_CAT_UPG_PVT.g_sys.min_rel_amount);
1093: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default notify_blanket_flag='||PO_R12_CAT_UPG_PVT.g_sys.notify_blanket_flag);
1094: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default budgetary_control_flag='||PO_R12_CAT_UPG_PVT.g_sys.budgetary_control_flag);
1095: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_req_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_req_num_code);
1096: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default rfq_required_flag='||PO_R12_CAT_UPG_PVT.g_sys.rfq_required_flag);
1097: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_req_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_req_num_type);
1098: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default enforce_full_lot_qty='||PO_R12_CAT_UPG_PVT.g_sys.enforce_full_lot_qty);
1099: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default disposition_warning_flag='||PO_R12_CAT_UPG_PVT.g_sys.disposition_warning_flag);

Line 1096: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default rfq_required_flag='||PO_R12_CAT_UPG_PVT.g_sys.rfq_required_flag);

1092: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default min_rel_amount='||PO_R12_CAT_UPG_PVT.g_sys.min_rel_amount);
1093: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default notify_blanket_flag='||PO_R12_CAT_UPG_PVT.g_sys.notify_blanket_flag);
1094: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default budgetary_control_flag='||PO_R12_CAT_UPG_PVT.g_sys.budgetary_control_flag);
1095: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_req_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_req_num_code);
1096: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default rfq_required_flag='||PO_R12_CAT_UPG_PVT.g_sys.rfq_required_flag);
1097: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_req_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_req_num_type);
1098: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default enforce_full_lot_qty='||PO_R12_CAT_UPG_PVT.g_sys.enforce_full_lot_qty);
1099: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default disposition_warning_flag='||PO_R12_CAT_UPG_PVT.g_sys.disposition_warning_flag);
1100: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default reserve_at_completion_flag='||PO_R12_CAT_UPG_PVT.g_sys.reserve_at_completion_flag);

Line 1097: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_req_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_req_num_type);

1093: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default notify_blanket_flag='||PO_R12_CAT_UPG_PVT.g_sys.notify_blanket_flag);
1094: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default budgetary_control_flag='||PO_R12_CAT_UPG_PVT.g_sys.budgetary_control_flag);
1095: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_req_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_req_num_code);
1096: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default rfq_required_flag='||PO_R12_CAT_UPG_PVT.g_sys.rfq_required_flag);
1097: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_req_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_req_num_type);
1098: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default enforce_full_lot_qty='||PO_R12_CAT_UPG_PVT.g_sys.enforce_full_lot_qty);
1099: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default disposition_warning_flag='||PO_R12_CAT_UPG_PVT.g_sys.disposition_warning_flag);
1100: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default reserve_at_completion_flag='||PO_R12_CAT_UPG_PVT.g_sys.reserve_at_completion_flag);
1101: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_rcpt_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_rcpt_num_code);

Line 1098: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default enforce_full_lot_qty='||PO_R12_CAT_UPG_PVT.g_sys.enforce_full_lot_qty);

1094: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default budgetary_control_flag='||PO_R12_CAT_UPG_PVT.g_sys.budgetary_control_flag);
1095: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_req_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_req_num_code);
1096: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default rfq_required_flag='||PO_R12_CAT_UPG_PVT.g_sys.rfq_required_flag);
1097: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_req_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_req_num_type);
1098: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default enforce_full_lot_qty='||PO_R12_CAT_UPG_PVT.g_sys.enforce_full_lot_qty);
1099: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default disposition_warning_flag='||PO_R12_CAT_UPG_PVT.g_sys.disposition_warning_flag);
1100: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default reserve_at_completion_flag='||PO_R12_CAT_UPG_PVT.g_sys.reserve_at_completion_flag);
1101: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_rcpt_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_rcpt_num_code);
1102: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_rcpt_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_rcpt_num_type);

Line 1099: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default disposition_warning_flag='||PO_R12_CAT_UPG_PVT.g_sys.disposition_warning_flag);

1095: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_req_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_req_num_code);
1096: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default rfq_required_flag='||PO_R12_CAT_UPG_PVT.g_sys.rfq_required_flag);
1097: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_req_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_req_num_type);
1098: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default enforce_full_lot_qty='||PO_R12_CAT_UPG_PVT.g_sys.enforce_full_lot_qty);
1099: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default disposition_warning_flag='||PO_R12_CAT_UPG_PVT.g_sys.disposition_warning_flag);
1100: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default reserve_at_completion_flag='||PO_R12_CAT_UPG_PVT.g_sys.reserve_at_completion_flag);
1101: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_rcpt_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_rcpt_num_code);
1102: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_rcpt_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_rcpt_num_type);
1103: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default use_positions_flag='||PO_R12_CAT_UPG_PVT.g_sys.use_positions_flag);

Line 1100: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default reserve_at_completion_flag='||PO_R12_CAT_UPG_PVT.g_sys.reserve_at_completion_flag);

1096: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default rfq_required_flag='||PO_R12_CAT_UPG_PVT.g_sys.rfq_required_flag);
1097: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_req_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_req_num_type);
1098: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default enforce_full_lot_qty='||PO_R12_CAT_UPG_PVT.g_sys.enforce_full_lot_qty);
1099: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default disposition_warning_flag='||PO_R12_CAT_UPG_PVT.g_sys.disposition_warning_flag);
1100: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default reserve_at_completion_flag='||PO_R12_CAT_UPG_PVT.g_sys.reserve_at_completion_flag);
1101: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_rcpt_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_rcpt_num_code);
1102: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_rcpt_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_rcpt_num_type);
1103: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default use_positions_flag='||PO_R12_CAT_UPG_PVT.g_sys.use_positions_flag);
1104: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default default_quote_warning_delay='||PO_R12_CAT_UPG_PVT.g_sys.default_quote_warning_delay);

Line 1101: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_rcpt_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_rcpt_num_code);

1097: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_req_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_req_num_type);
1098: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default enforce_full_lot_qty='||PO_R12_CAT_UPG_PVT.g_sys.enforce_full_lot_qty);
1099: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default disposition_warning_flag='||PO_R12_CAT_UPG_PVT.g_sys.disposition_warning_flag);
1100: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default reserve_at_completion_flag='||PO_R12_CAT_UPG_PVT.g_sys.reserve_at_completion_flag);
1101: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_rcpt_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_rcpt_num_code);
1102: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_rcpt_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_rcpt_num_type);
1103: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default use_positions_flag='||PO_R12_CAT_UPG_PVT.g_sys.use_positions_flag);
1104: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default default_quote_warning_delay='||PO_R12_CAT_UPG_PVT.g_sys.default_quote_warning_delay);
1105: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default inspection_required_flag='||PO_R12_CAT_UPG_PVT.g_sys.inspection_required_flag);

Line 1102: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_rcpt_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_rcpt_num_type);

1098: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default enforce_full_lot_qty='||PO_R12_CAT_UPG_PVT.g_sys.enforce_full_lot_qty);
1099: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default disposition_warning_flag='||PO_R12_CAT_UPG_PVT.g_sys.disposition_warning_flag);
1100: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default reserve_at_completion_flag='||PO_R12_CAT_UPG_PVT.g_sys.reserve_at_completion_flag);
1101: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_rcpt_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_rcpt_num_code);
1102: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_rcpt_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_rcpt_num_type);
1103: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default use_positions_flag='||PO_R12_CAT_UPG_PVT.g_sys.use_positions_flag);
1104: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default default_quote_warning_delay='||PO_R12_CAT_UPG_PVT.g_sys.default_quote_warning_delay);
1105: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default inspection_required_flag='||PO_R12_CAT_UPG_PVT.g_sys.inspection_required_flag);
1106: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_quote_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_quote_num_code);

Line 1103: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default use_positions_flag='||PO_R12_CAT_UPG_PVT.g_sys.use_positions_flag);

1099: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default disposition_warning_flag='||PO_R12_CAT_UPG_PVT.g_sys.disposition_warning_flag);
1100: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default reserve_at_completion_flag='||PO_R12_CAT_UPG_PVT.g_sys.reserve_at_completion_flag);
1101: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_rcpt_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_rcpt_num_code);
1102: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_rcpt_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_rcpt_num_type);
1103: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default use_positions_flag='||PO_R12_CAT_UPG_PVT.g_sys.use_positions_flag);
1104: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default default_quote_warning_delay='||PO_R12_CAT_UPG_PVT.g_sys.default_quote_warning_delay);
1105: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default inspection_required_flag='||PO_R12_CAT_UPG_PVT.g_sys.inspection_required_flag);
1106: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_quote_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_quote_num_code);
1107: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_quote_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_quote_num_type);

Line 1104: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default default_quote_warning_delay='||PO_R12_CAT_UPG_PVT.g_sys.default_quote_warning_delay);

1100: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default reserve_at_completion_flag='||PO_R12_CAT_UPG_PVT.g_sys.reserve_at_completion_flag);
1101: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_rcpt_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_rcpt_num_code);
1102: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_rcpt_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_rcpt_num_type);
1103: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default use_positions_flag='||PO_R12_CAT_UPG_PVT.g_sys.use_positions_flag);
1104: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default default_quote_warning_delay='||PO_R12_CAT_UPG_PVT.g_sys.default_quote_warning_delay);
1105: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default inspection_required_flag='||PO_R12_CAT_UPG_PVT.g_sys.inspection_required_flag);
1106: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_quote_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_quote_num_code);
1107: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_quote_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_quote_num_type);
1108: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_rfq_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_rfq_num_code);

Line 1105: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default inspection_required_flag='||PO_R12_CAT_UPG_PVT.g_sys.inspection_required_flag);

1101: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_rcpt_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_rcpt_num_code);
1102: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_rcpt_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_rcpt_num_type);
1103: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default use_positions_flag='||PO_R12_CAT_UPG_PVT.g_sys.use_positions_flag);
1104: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default default_quote_warning_delay='||PO_R12_CAT_UPG_PVT.g_sys.default_quote_warning_delay);
1105: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default inspection_required_flag='||PO_R12_CAT_UPG_PVT.g_sys.inspection_required_flag);
1106: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_quote_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_quote_num_code);
1107: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_quote_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_quote_num_type);
1108: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_rfq_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_rfq_num_code);
1109: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_rfq_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_rfq_num_type);

Line 1106: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_quote_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_quote_num_code);

1102: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_rcpt_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_rcpt_num_type);
1103: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default use_positions_flag='||PO_R12_CAT_UPG_PVT.g_sys.use_positions_flag);
1104: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default default_quote_warning_delay='||PO_R12_CAT_UPG_PVT.g_sys.default_quote_warning_delay);
1105: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default inspection_required_flag='||PO_R12_CAT_UPG_PVT.g_sys.inspection_required_flag);
1106: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_quote_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_quote_num_code);
1107: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_quote_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_quote_num_type);
1108: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_rfq_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_rfq_num_code);
1109: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_rfq_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_rfq_num_type);
1110: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default ship_via_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.ship_via_lookup_code);

Line 1107: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_quote_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_quote_num_type);

1103: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default use_positions_flag='||PO_R12_CAT_UPG_PVT.g_sys.use_positions_flag);
1104: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default default_quote_warning_delay='||PO_R12_CAT_UPG_PVT.g_sys.default_quote_warning_delay);
1105: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default inspection_required_flag='||PO_R12_CAT_UPG_PVT.g_sys.inspection_required_flag);
1106: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_quote_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_quote_num_code);
1107: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_quote_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_quote_num_type);
1108: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_rfq_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_rfq_num_code);
1109: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_rfq_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_rfq_num_type);
1110: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default ship_via_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.ship_via_lookup_code);
1111: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default qty_rcv_tolerance='||PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_tolerance);

Line 1108: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_rfq_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_rfq_num_code);

1104: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default default_quote_warning_delay='||PO_R12_CAT_UPG_PVT.g_sys.default_quote_warning_delay);
1105: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default inspection_required_flag='||PO_R12_CAT_UPG_PVT.g_sys.inspection_required_flag);
1106: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_quote_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_quote_num_code);
1107: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_quote_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_quote_num_type);
1108: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_rfq_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_rfq_num_code);
1109: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_rfq_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_rfq_num_type);
1110: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default ship_via_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.ship_via_lookup_code);
1111: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default qty_rcv_tolerance='||PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_tolerance);
1112: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default master_inv_org_id='||PO_R12_CAT_UPG_PVT.g_sys.master_inv_org_id);

Line 1109: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_rfq_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_rfq_num_type);

1105: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default inspection_required_flag='||PO_R12_CAT_UPG_PVT.g_sys.inspection_required_flag);
1106: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_quote_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_quote_num_code);
1107: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_quote_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_quote_num_type);
1108: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_rfq_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_rfq_num_code);
1109: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_rfq_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_rfq_num_type);
1110: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default ship_via_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.ship_via_lookup_code);
1111: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default qty_rcv_tolerance='||PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_tolerance);
1112: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default master_inv_org_id='||PO_R12_CAT_UPG_PVT.g_sys.master_inv_org_id);
1113: END IF;

Line 1110: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default ship_via_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.ship_via_lookup_code);

1106: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_quote_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_quote_num_code);
1107: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_quote_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_quote_num_type);
1108: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_rfq_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_rfq_num_code);
1109: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_rfq_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_rfq_num_type);
1110: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default ship_via_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.ship_via_lookup_code);
1111: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default qty_rcv_tolerance='||PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_tolerance);
1112: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default master_inv_org_id='||PO_R12_CAT_UPG_PVT.g_sys.master_inv_org_id);
1113: END IF;
1114:

Line 1111: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default qty_rcv_tolerance='||PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_tolerance);

1107: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_quote_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_quote_num_type);
1108: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_rfq_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_rfq_num_code);
1109: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_rfq_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_rfq_num_type);
1110: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default ship_via_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.ship_via_lookup_code);
1111: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default qty_rcv_tolerance='||PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_tolerance);
1112: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default master_inv_org_id='||PO_R12_CAT_UPG_PVT.g_sys.master_inv_org_id);
1113: END IF;
1114:
1115: -- We do not need the Receiving parameters in Catalog Migration.

Line 1112: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default master_inv_org_id='||PO_R12_CAT_UPG_PVT.g_sys.master_inv_org_id);

1108: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default user_defined_rfq_num_code='||PO_R12_CAT_UPG_PVT.g_sys.user_defined_rfq_num_code);
1109: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default manual_rfq_num_type='||PO_R12_CAT_UPG_PVT.g_sys.manual_rfq_num_type);
1110: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default ship_via_lookup_code='||PO_R12_CAT_UPG_PVT.g_sys.ship_via_lookup_code);
1111: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default qty_rcv_tolerance='||PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_tolerance);
1112: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Default master_inv_org_id='||PO_R12_CAT_UPG_PVT.g_sys.master_inv_org_id);
1113: END IF;
1114:
1115: -- We do not need the Receiving parameters in Catalog Migration.
1116: -- So commenting out the following code

Line 1119: --INTO PO_R12_CAT_UPG_PVT.g_sys_param.master_inv_org_id

1115: -- We do not need the Receiving parameters in Catalog Migration.
1116: -- So commenting out the following code
1117:
1118: --SELECT master_organization_id
1119: --INTO PO_R12_CAT_UPG_PVT.g_sys_param.master_inv_org_id
1120: --FROM mtl_system_parameters
1121: --WHERE organization_id = PO_R12_CAT_UPG_PVT.g_sys.def_inv_org_id;
1122:
1123: -- receiving parameters for defaulting org

Line 1121: --WHERE organization_id = PO_R12_CAT_UPG_PVT.g_sys.def_inv_org_id;

1117:
1118: --SELECT master_organization_id
1119: --INTO PO_R12_CAT_UPG_PVT.g_sys_param.master_inv_org_id
1120: --FROM mtl_system_parameters
1121: --WHERE organization_id = PO_R12_CAT_UPG_PVT.g_sys.def_inv_org_id;
1122:
1123: -- receiving parameters for defaulting org
1124: --RCV_CORE_S.get_receiving_controls
1125: --( x_line_loc_id => NULL,

Line 1128: -- x_org_id => PO_R12_CAT_UPG_PVT.g_sys.def_inv_org_id,

1124: --RCV_CORE_S.get_receiving_controls
1125: --( x_line_loc_id => NULL,
1126: -- x_item_id => NULL,
1127: -- x_vendor_id => NULL,
1128: -- x_org_id => PO_R12_CAT_UPG_PVT.g_sys.def_inv_org_id,
1129: -- x_enforce_ship_to_loc => PO_R12_CAT_UPG_PVT.g_sys.enforce_ship_to_loc,
1130: -- x_allow_substitutes => PO_R12_CAT_UPG_PVT.g_sys.allow_substitutes,
1131: -- x_routing_id => PO_R12_CAT_UPG_PVT.g_sys.routing_id,
1132: -- x_qty_rcv_tolerance => PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_tolerance,

Line 1129: -- x_enforce_ship_to_loc => PO_R12_CAT_UPG_PVT.g_sys.enforce_ship_to_loc,

1125: --( x_line_loc_id => NULL,
1126: -- x_item_id => NULL,
1127: -- x_vendor_id => NULL,
1128: -- x_org_id => PO_R12_CAT_UPG_PVT.g_sys.def_inv_org_id,
1129: -- x_enforce_ship_to_loc => PO_R12_CAT_UPG_PVT.g_sys.enforce_ship_to_loc,
1130: -- x_allow_substitutes => PO_R12_CAT_UPG_PVT.g_sys.allow_substitutes,
1131: -- x_routing_id => PO_R12_CAT_UPG_PVT.g_sys.routing_id,
1132: -- x_qty_rcv_tolerance => PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_tolerance,
1133: -- x_qty_rcv_exception => PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_exception,

Line 1130: -- x_allow_substitutes => PO_R12_CAT_UPG_PVT.g_sys.allow_substitutes,

1126: -- x_item_id => NULL,
1127: -- x_vendor_id => NULL,
1128: -- x_org_id => PO_R12_CAT_UPG_PVT.g_sys.def_inv_org_id,
1129: -- x_enforce_ship_to_loc => PO_R12_CAT_UPG_PVT.g_sys.enforce_ship_to_loc,
1130: -- x_allow_substitutes => PO_R12_CAT_UPG_PVT.g_sys.allow_substitutes,
1131: -- x_routing_id => PO_R12_CAT_UPG_PVT.g_sys.routing_id,
1132: -- x_qty_rcv_tolerance => PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_tolerance,
1133: -- x_qty_rcv_exception => PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_exception,
1134: -- x_days_early_receipt => PO_R12_CAT_UPG_PVT.g_sys.days_early_receipt,

Line 1131: -- x_routing_id => PO_R12_CAT_UPG_PVT.g_sys.routing_id,

1127: -- x_vendor_id => NULL,
1128: -- x_org_id => PO_R12_CAT_UPG_PVT.g_sys.def_inv_org_id,
1129: -- x_enforce_ship_to_loc => PO_R12_CAT_UPG_PVT.g_sys.enforce_ship_to_loc,
1130: -- x_allow_substitutes => PO_R12_CAT_UPG_PVT.g_sys.allow_substitutes,
1131: -- x_routing_id => PO_R12_CAT_UPG_PVT.g_sys.routing_id,
1132: -- x_qty_rcv_tolerance => PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_tolerance,
1133: -- x_qty_rcv_exception => PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_exception,
1134: -- x_days_early_receipt => PO_R12_CAT_UPG_PVT.g_sys.days_early_receipt,
1135: -- x_days_late_receipt => PO_R12_CAT_UPG_PVT.g_sys.days_late_receipt,

Line 1132: -- x_qty_rcv_tolerance => PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_tolerance,

1128: -- x_org_id => PO_R12_CAT_UPG_PVT.g_sys.def_inv_org_id,
1129: -- x_enforce_ship_to_loc => PO_R12_CAT_UPG_PVT.g_sys.enforce_ship_to_loc,
1130: -- x_allow_substitutes => PO_R12_CAT_UPG_PVT.g_sys.allow_substitutes,
1131: -- x_routing_id => PO_R12_CAT_UPG_PVT.g_sys.routing_id,
1132: -- x_qty_rcv_tolerance => PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_tolerance,
1133: -- x_qty_rcv_exception => PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_exception,
1134: -- x_days_early_receipt => PO_R12_CAT_UPG_PVT.g_sys.days_early_receipt,
1135: -- x_days_late_receipt => PO_R12_CAT_UPG_PVT.g_sys.days_late_receipt,
1136: -- x_rcv_date_exception => PO_R12_CAT_UPG_PVT.g_sys.rcv_date_exception

Line 1133: -- x_qty_rcv_exception => PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_exception,

1129: -- x_enforce_ship_to_loc => PO_R12_CAT_UPG_PVT.g_sys.enforce_ship_to_loc,
1130: -- x_allow_substitutes => PO_R12_CAT_UPG_PVT.g_sys.allow_substitutes,
1131: -- x_routing_id => PO_R12_CAT_UPG_PVT.g_sys.routing_id,
1132: -- x_qty_rcv_tolerance => PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_tolerance,
1133: -- x_qty_rcv_exception => PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_exception,
1134: -- x_days_early_receipt => PO_R12_CAT_UPG_PVT.g_sys.days_early_receipt,
1135: -- x_days_late_receipt => PO_R12_CAT_UPG_PVT.g_sys.days_late_receipt,
1136: -- x_rcv_date_exception => PO_R12_CAT_UPG_PVT.g_sys.rcv_date_exception
1137: --);

Line 1134: -- x_days_early_receipt => PO_R12_CAT_UPG_PVT.g_sys.days_early_receipt,

1130: -- x_allow_substitutes => PO_R12_CAT_UPG_PVT.g_sys.allow_substitutes,
1131: -- x_routing_id => PO_R12_CAT_UPG_PVT.g_sys.routing_id,
1132: -- x_qty_rcv_tolerance => PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_tolerance,
1133: -- x_qty_rcv_exception => PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_exception,
1134: -- x_days_early_receipt => PO_R12_CAT_UPG_PVT.g_sys.days_early_receipt,
1135: -- x_days_late_receipt => PO_R12_CAT_UPG_PVT.g_sys.days_late_receipt,
1136: -- x_rcv_date_exception => PO_R12_CAT_UPG_PVT.g_sys.rcv_date_exception
1137: --);
1138:

Line 1135: -- x_days_late_receipt => PO_R12_CAT_UPG_PVT.g_sys.days_late_receipt,

1131: -- x_routing_id => PO_R12_CAT_UPG_PVT.g_sys.routing_id,
1132: -- x_qty_rcv_tolerance => PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_tolerance,
1133: -- x_qty_rcv_exception => PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_exception,
1134: -- x_days_early_receipt => PO_R12_CAT_UPG_PVT.g_sys.days_early_receipt,
1135: -- x_days_late_receipt => PO_R12_CAT_UPG_PVT.g_sys.days_late_receipt,
1136: -- x_rcv_date_exception => PO_R12_CAT_UPG_PVT.g_sys.rcv_date_exception
1137: --);
1138:
1139: l_progress := '030';

Line 1136: -- x_rcv_date_exception => PO_R12_CAT_UPG_PVT.g_sys.rcv_date_exception

1132: -- x_qty_rcv_tolerance => PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_tolerance,
1133: -- x_qty_rcv_exception => PO_R12_CAT_UPG_PVT.g_sys.qty_rcv_exception,
1134: -- x_days_early_receipt => PO_R12_CAT_UPG_PVT.g_sys.days_early_receipt,
1135: -- x_days_late_receipt => PO_R12_CAT_UPG_PVT.g_sys.days_late_receipt,
1136: -- x_rcv_date_exception => PO_R12_CAT_UPG_PVT.g_sys.rcv_date_exception
1137: --);
1138:
1139: l_progress := '030';
1140: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'END'); END IF;