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

Line 1: PACKAGE BODY PO_R12_CAT_UPG_PVT AS

1: PACKAGE BODY PO_R12_CAT_UPG_PVT AS
2: /* $Header: PO_R12_CAT_UPG_PVT.plb 120.16.12010000.2 2008/08/04 08:40:21 rramasam ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_R12_CAT_UPG_PVT';
5: g_module_prefix CONSTANT VARCHAR2(100) := 'po.plsql.' || g_pkg_name || '.';

Line 2: /* $Header: PO_R12_CAT_UPG_PVT.plb 120.16.12010000.2 2008/08/04 08:40:21 rramasam ship $ */

1: PACKAGE BODY PO_R12_CAT_UPG_PVT AS
2: /* $Header: PO_R12_CAT_UPG_PVT.plb 120.16.12010000.2 2008/08/04 08:40:21 rramasam ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_R12_CAT_UPG_PVT';
5: g_module_prefix CONSTANT VARCHAR2(100) := 'po.plsql.' || g_pkg_name || '.';
6:

Line 4: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_R12_CAT_UPG_PVT';

1: PACKAGE BODY PO_R12_CAT_UPG_PVT AS
2: /* $Header: PO_R12_CAT_UPG_PVT.plb 120.16.12010000.2 2008/08/04 08:40:21 rramasam ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_R12_CAT_UPG_PVT';
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;

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_PVT';
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: -- Value of IP_CATEGORY_ID column if no category mappings exist
11: g_NULL_IP_CATEGORY_ID CONSTANT NUMBER := -2;
12:

Line 943: AND headers.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_NEW

939: headers.cpa_reference,
940: 'N' -- has_errors
941: FROM po_headers_interface headers
942: WHERE headers.processing_id = request_processing_id
943: AND headers.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_NEW
944: AND headers.action IN (PO_R12_CAT_UPG_PVT.g_action_header_create, 'UPDATE', 'DELETE');
945:
946: l_doc_headers_table record_of_headers_type;
947: l_err_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 944: AND headers.action IN (PO_R12_CAT_UPG_PVT.g_action_header_create, 'UPDATE', 'DELETE');

940: 'N' -- has_errors
941: FROM po_headers_interface headers
942: WHERE headers.processing_id = request_processing_id
943: AND headers.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_NEW
944: AND headers.action IN (PO_R12_CAT_UPG_PVT.g_action_header_create, 'UPDATE', 'DELETE');
945:
946: l_doc_headers_table record_of_headers_type;
947: l_err_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
948: l_count NUMBER := NULL;

Line 1807: x_doc_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create) THEN

1803: l_num_valid_headers := 0;
1804: FOR i IN 1 .. x_doc_headers_rec.interface_header_id.COUNT
1805: LOOP
1806: IF (x_doc_headers_rec.has_errors(i) = 'N' AND
1807: x_doc_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create) THEN
1808: l_num_valid_headers := l_num_valid_headers + 1;
1809: END IF;
1810: END LOOP;
1811:

Line 1821: AND x_doc_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create) THEN

1817: FOR i IN 1 .. x_doc_headers_rec.interface_header_id.COUNT
1818: LOOP
1819: l_progress := '040';
1820: IF (x_doc_headers_rec.has_errors(i) = 'N'
1821: AND x_doc_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create) THEN
1822: l_count := l_count + 1;
1823:
1824: l_progress := '050';
1825: SELECT PO_HEADERS_S.nextval

Line 1993: -- is PO_R12_CAT_UPG_PVT.g_action_header_create

1989: END LOOP;
1990:
1991: l_progress := '070';
1992: -- SQL What: Insert Rows that do not have errors, and where action
1993: -- is PO_R12_CAT_UPG_PVT.g_action_header_create
1994: -- SQL Why : To migrate data to txn tables
1995: -- SQL Join: none
1996: FORALL i IN 1 .. l_valid_headers.po_header_id.COUNT
1997: INSERT INTO po_headers_all POH

Line 2843: AND lines.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_NEW

2839: NULL, -- purchase_basis: Not present in interface tables. Just initialize the collection
2840: NULL -- matching_basis: Not present in interface tables. Just initialize the collection
2841: FROM po_lines_interface lines
2842: WHERE lines.processing_id = request_processing_id
2843: AND lines.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_NEW
2844: AND lines.action IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE', 'DELETE');
2845:
2846: l_doc_lines_table record_of_lines_type;
2847: l_err_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 2844: AND lines.action IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE', 'DELETE');

2840: NULL -- matching_basis: Not present in interface tables. Just initialize the collection
2841: FROM po_lines_interface lines
2842: WHERE lines.processing_id = request_processing_id
2843: AND lines.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_NEW
2844: AND lines.action IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE', 'DELETE');
2845:
2846: l_doc_lines_table record_of_lines_type;
2847: l_err_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2848: l_count NUMBER := NULL;

Line 3389: AND l_process_code_list(i) = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_PROCESSED

3385: LOOP
3386: l_progress := '020';
3387:
3388: IF (p_doc_lines_rec.has_errors(i) = 'N'
3389: AND l_process_code_list(i) = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_PROCESSED
3390: AND p_doc_lines_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_line_create) THEN
3391: l_progress := '030';
3392:
3393: l_count := l_count + 1;

Line 3390: AND p_doc_lines_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_line_create) THEN

3386: l_progress := '020';
3387:
3388: IF (p_doc_lines_rec.has_errors(i) = 'N'
3389: AND l_process_code_list(i) = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_PROCESSED
3390: AND p_doc_lines_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_line_create) THEN
3391: l_progress := '030';
3392:
3393: l_count := l_count + 1;
3394:

Line 3639: -- SQL What: Insert rows that have no errors, and action = PO_R12_CAT_UPG_PVT.g_action_line_create

3635:
3636: l_progress := '090';
3637: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'l_count='||l_count); END IF;
3638:
3639: -- SQL What: Insert rows that have no errors, and action = PO_R12_CAT_UPG_PVT.g_action_line_create
3640: -- SQL Why : To migrate data to txn tables
3641: -- SQL Join: none
3642: FORALL i IN 1 .. l_valid_lines.po_line_id.COUNT
3643: INSERT INTO po_lines_all POL

Line 4593: AND attrib.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_NEW

4589: 'N' -- has_errors
4590: FROM PO_ATTR_VALUES_INTERFACE attrib,
4591: PO_LINES_INTERFACE POLI
4592: WHERE attrib.processing_id = request_processing_id
4593: AND attrib.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_NEW
4594: AND attrib.action IN (PO_R12_CAT_UPG_PVT.g_action_attr_create, 'UPDATE', 'DELETE')
4595: AND attrib.interface_line_id = POLI.interface_line_id;
4596:
4597: l_attrib_table record_of_attr_values_type;

Line 4594: AND attrib.action IN (PO_R12_CAT_UPG_PVT.g_action_attr_create, 'UPDATE', 'DELETE')

4590: FROM PO_ATTR_VALUES_INTERFACE attrib,
4591: PO_LINES_INTERFACE POLI
4592: WHERE attrib.processing_id = request_processing_id
4593: AND attrib.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_NEW
4594: AND attrib.action IN (PO_R12_CAT_UPG_PVT.g_action_attr_create, 'UPDATE', 'DELETE')
4595: AND attrib.interface_line_id = POLI.interface_line_id;
4596:
4597: l_attrib_table record_of_attr_values_type;
4598:

Line 5108: -- SQL What: Insert rows that have no errors, and action = PO_R12_CAT_UPG_PVT.g_action_attr_create

5104: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_attr_values_tbl.action(1)='||p_attr_values_tbl.action(1)); END IF;
5105: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_attr_values_tbl.interface_attr_values_id(1)='||p_attr_values_tbl.interface_attr_values_id(1)); END IF;
5106: END IF;
5107:
5108: -- SQL What: Insert rows that have no errors, and action = PO_R12_CAT_UPG_PVT.g_action_attr_create
5109: -- SQL Why : To migrate data to txn tables
5110: -- SQL Join: none
5111: FORALL i IN 1..p_attr_values_tbl.po_line_id.COUNT
5112: INSERT INTO po_attribute_values

Line 5775: AND p_attr_values_tbl.action(i) = PO_R12_CAT_UPG_PVT.g_action_attr_create

5771: FROM PO_ATTR_VALUES_INTERFACE POAVI,
5772: PO_LINES_INTERFACE POLI -- ECO bug 4738058
5773: WHERE POAVI.interface_attr_values_id = p_attr_values_tbl.interface_attr_values_id(i)
5774: AND p_attr_values_tbl.has_errors(i) = 'N'
5775: AND p_attr_values_tbl.action(i) = PO_R12_CAT_UPG_PVT.g_action_attr_create
5776: -- ECO bug 4738058
5777: AND POLI.interface_line_id = POAVI.interface_line_id;
5778:
5779: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of Attr inserted='||SQL%rowcount); END IF;

Line 5796: AND p_attr_values_tbl.action(i) = PO_R12_CAT_UPG_PVT.g_action_attr_create;

5792: FROM PO_LINES_INTERFACE POLI
5793: WHERE POLI.interface_line_id = POAVI.interface_line_id)
5794: WHERE POAVI.interface_attr_values_id = p_attr_values_tbl.interface_attr_values_id(i)
5795: AND p_attr_values_tbl.has_errors(i) = 'N'
5796: AND p_attr_values_tbl.action(i) = PO_R12_CAT_UPG_PVT.g_action_attr_create;
5797:
5798: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of Interface Attr PROCESSED='||SQL%rowcount); END IF;
5799:
5800: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'END'); END IF;

Line 6516: AND attrib_tlp.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_NEW

6512: 'N' -- has_errors
6513: FROM PO_ATTR_VALUES_TLP_INTERFACE attrib_tlp,
6514: PO_LINES_INTERFACE POLI
6515: WHERE attrib_tlp.processing_id = request_processing_id
6516: AND attrib_tlp.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_NEW
6517: AND attrib_tlp.action IN (PO_R12_CAT_UPG_PVT.g_action_tlp_create, 'UPDATE', 'DELETE')
6518: AND attrib_tlp.interface_line_id = POLI.interface_line_id;
6519:
6520: l_attrib_tlp_table record_of_attr_values_tlp_type;

Line 6517: AND attrib_tlp.action IN (PO_R12_CAT_UPG_PVT.g_action_tlp_create, 'UPDATE', 'DELETE')

6513: FROM PO_ATTR_VALUES_TLP_INTERFACE attrib_tlp,
6514: PO_LINES_INTERFACE POLI
6515: WHERE attrib_tlp.processing_id = request_processing_id
6516: AND attrib_tlp.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_NEW
6517: AND attrib_tlp.action IN (PO_R12_CAT_UPG_PVT.g_action_tlp_create, 'UPDATE', 'DELETE')
6518: AND attrib_tlp.interface_line_id = POLI.interface_line_id;
6519:
6520: l_attrib_tlp_table record_of_attr_values_tlp_type;
6521:

Line 6866: -- SQL What: Insert rows that have no errors, and action = PO_R12_CAT_UPG_PVT.g_action_tlp_create

6862: BEGIN
6863: l_progress := '010';
6864: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
6865:
6866: -- SQL What: Insert rows that have no errors, and action = PO_R12_CAT_UPG_PVT.g_action_tlp_create
6867: -- SQL Why : To migrate data to txn tables
6868: -- SQL Join: none
6869: FORALL i IN 1..p_attr_values_tlp_tbl.po_line_id.COUNT
6870: INSERT INTO po_attribute_values_tlp

Line 7228: AND p_attr_values_tlp_tbl.action(i) = PO_R12_CAT_UPG_PVT.g_action_tlp_create

7224: FROM PO_ATTR_VALUES_TLP_INTERFACE POAVTI,
7225: PO_LINES_INTERFACE POLI -- ECO bug 4738058
7226: WHERE POAVTI.interface_attr_values_tlp_id = p_attr_values_tlp_tbl.interface_attr_values_tlp_id(i)
7227: AND p_attr_values_tlp_tbl.has_errors(i) = 'N'
7228: AND p_attr_values_tlp_tbl.action(i) = PO_R12_CAT_UPG_PVT.g_action_tlp_create
7229: -- ECO bug 4738058
7230: AND POLI.interface_line_id = POAVTI.interface_line_id;
7231:
7232: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of TLP inserted='||SQL%rowcount); END IF;

Line 7249: AND p_attr_values_tlp_tbl.action(i) = PO_R12_CAT_UPG_PVT.g_action_tlp_create;

7245: FROM PO_LINES_INTERFACE POLI
7246: WHERE POLI.interface_line_id = POAVTI.interface_line_id)
7247: WHERE POAVTI.interface_attr_values_tlp_id = p_attr_values_tlp_tbl.interface_attr_values_tlp_id(i)
7248: AND p_attr_values_tlp_tbl.has_errors(i) = 'N'
7249: AND p_attr_values_tlp_tbl.action(i) = PO_R12_CAT_UPG_PVT.g_action_tlp_create;
7250:
7251: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of Interface TLP rows PROCESSED='||SQL%rowcount); END IF;
7252:
7253: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'END'); END IF;

Line 7670: AND intf_tlp.action IN (PO_R12_CAT_UPG_PVT.g_action_tlp_create, 'UPDATE')

7666: FROM PO_ATTR_VALUES_TLP_INTERFACE intf_tlp
7667: -- Not negative, means it was migrated successfully in prev steps
7668: WHERE intf_tlp.processing_id = p_request_processing_id
7669: AND intf_tlp.process_code = g_PROCESS_CODE_PROCESSED
7670: AND intf_tlp.action IN (PO_R12_CAT_UPG_PVT.g_action_tlp_create, 'UPDATE')
7671: AND intf_tlp.language = p_base_lang
7672: AND intf_tlp.req_template_name is not null
7673: AND intf_tlp.req_template_line_num is not null
7674: AND intf_tlp.req_template_line_num <> g_NOT_REQUIRED_ID

Line 7909: END PO_R12_CAT_UPG_PVT;

7905: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Unexpected exception'); END IF;
7906: RAISE_APPLICATION_ERROR(g_err_num,l_log_head||','||l_progress || ','|| SQLERRM);
7907: END get_distinct_orgs;
7908:
7909: END PO_R12_CAT_UPG_PVT;