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.CSI_DIAGNOSTICS_PKG dependencies on CSI_DIAGNOSTICS_PKG

Line 1: PACKAGE BODY csi_diagnostics_pkg as

1: PACKAGE BODY csi_diagnostics_pkg as
2: /* $Header: csidiagb.pls 120.18 2007/10/24 00:34:50 lakmohan ship $ */
3:
4: g_no_lot constant number := 1;
5: g_lot constant number := 2;

Line 284: ,p_inst_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.instance_rec_tab

280: --
281: PROCEDURE Build_Inst_Rec_of_Table
282: (
283: p_inst_tbl IN csi_datastructures_pub.instance_tbl
284: ,p_inst_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.instance_rec_tab
285: ,p_inst_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
286: ) IS
287: BEGIN
288: FOR i in p_inst_tbl.FIRST .. p_inst_tbl.LAST LOOP

Line 285: ,p_inst_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM

281: PROCEDURE Build_Inst_Rec_of_Table
282: (
283: p_inst_tbl IN csi_datastructures_pub.instance_tbl
284: ,p_inst_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.instance_rec_tab
285: ,p_inst_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
286: ) IS
287: BEGIN
288: FOR i in p_inst_tbl.FIRST .. p_inst_tbl.LAST LOOP
289: select CSI_ITEM_INSTANCES_H_S.nextval

Line 372: ,p_ii_relationship_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.ii_relationship_rec_tab

368: --
369: PROCEDURE Build_Rel_Rec_of_Table
370: (
371: p_ii_relationship_tbl IN csi_datastructures_pub.ii_relationship_tbl
372: ,p_ii_relationship_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.ii_relationship_rec_tab
373: ,p_rel_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
374: ) IS
375: BEGIN
376: FOR i in p_ii_relationship_tbl.FIRST .. p_ii_relationship_tbl.LAST LOOP

Line 373: ,p_rel_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM

369: PROCEDURE Build_Rel_Rec_of_Table
370: (
371: p_ii_relationship_tbl IN csi_datastructures_pub.ii_relationship_tbl
372: ,p_ii_relationship_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.ii_relationship_rec_tab
373: ,p_rel_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
374: ) IS
375: BEGIN
376: FOR i in p_ii_relationship_tbl.FIRST .. p_ii_relationship_tbl.LAST LOOP
377: select CSI_II_RELATIONSHIPS_H_S.nextval

Line 413: ,p_version_label_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.version_label_rec_tab

409: --
410: PROCEDURE Build_Ver_Label_Rec_of_Table
411: (
412: p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
413: ,p_version_label_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.version_label_rec_tab
414: ,p_ver_label_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
415: ) IS
416: BEGIN
417: FOR i in p_version_label_tbl.FIRST .. p_version_label_tbl.LAST LOOP

Line 414: ,p_ver_label_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM

410: PROCEDURE Build_Ver_Label_Rec_of_Table
411: (
412: p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
413: ,p_version_label_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.version_label_rec_tab
414: ,p_ver_label_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
415: ) IS
416: BEGIN
417: FOR i in p_version_label_tbl.FIRST .. p_version_label_tbl.LAST LOOP
418: select CSI_I_VERSION_LABELS_H_S.nextval

Line 450: ,p_party_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.party_rec_tab

446: END Build_Ver_Label_Rec_of_Table;
447: --
448: PROCEDURE Build_Party_Rec_of_Table
449: ( p_party_tbl IN csi_datastructures_pub.party_tbl
450: ,p_party_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.party_rec_tab
451: ,p_party_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
452: ) IS
453: BEGIN
454: FOR i in p_party_tbl.FIRST .. p_party_tbl.LAST LOOP

Line 451: ,p_party_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM

447: --
448: PROCEDURE Build_Party_Rec_of_Table
449: ( p_party_tbl IN csi_datastructures_pub.party_tbl
450: ,p_party_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.party_rec_tab
451: ,p_party_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
452: ) IS
453: BEGIN
454: FOR i in p_party_tbl.FIRST .. p_party_tbl.LAST LOOP
455: select CSI_I_PARTIES_H_S.nextval

Line 492: ,p_account_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.account_rec_tab

488: --
489: PROCEDURE Build_Acct_Rec_of_Table
490: (
491: p_account_tbl IN csi_datastructures_pub.party_account_tbl
492: ,p_account_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.account_rec_tab
493: ,p_account_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
494: ) IS
495: BEGIN
496: FOR i in p_account_tbl.FIRST .. p_account_tbl.LAST LOOP

Line 493: ,p_account_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM

489: PROCEDURE Build_Acct_Rec_of_Table
490: (
491: p_account_tbl IN csi_datastructures_pub.party_account_tbl
492: ,p_account_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.account_rec_tab
493: ,p_account_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
494: ) IS
495: BEGIN
496: FOR i in p_account_tbl.FIRST .. p_account_tbl.LAST LOOP
497: select CSI_IP_ACCOUNTS_H_S.nextval

Line 535: ,p_org_units_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.org_units_rec_tab

531: --
532: PROCEDURE Build_Org_Rec_of_Table
533: (
534: p_org_tbl IN csi_datastructures_pub.organization_units_tbl
535: ,p_org_units_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.org_units_rec_tab
536: ,p_org_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
537: ) IS
538: BEGIN
539: FOR i in p_org_tbl.FIRST .. p_org_tbl.LAST LOOP

Line 536: ,p_org_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM

532: PROCEDURE Build_Org_Rec_of_Table
533: (
534: p_org_tbl IN csi_datastructures_pub.organization_units_tbl
535: ,p_org_units_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.org_units_rec_tab
536: ,p_org_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
537: ) IS
538: BEGIN
539: FOR i in p_org_tbl.FIRST .. p_org_tbl.LAST LOOP
540: select CSI_I_ORG_ASSIGNMENTS_H_S.nextval

Line 572: ,p_pricing_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.pricing_attribs_rec_tab

568: --
569: PROCEDURE Build_pricing_Rec_of_Table
570: (
571: p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl
572: ,p_pricing_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.pricing_attribs_rec_tab
573: ,p_pricing_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
574: ) IS
575: BEGIN
576: FOR i in p_pricing_tbl.FIRST .. p_pricing_tbl.LAST LOOP

Line 573: ,p_pricing_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM

569: PROCEDURE Build_pricing_Rec_of_Table
570: (
571: p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl
572: ,p_pricing_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.pricing_attribs_rec_tab
573: ,p_pricing_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
574: ) IS
575: BEGIN
576: FOR i in p_pricing_tbl.FIRST .. p_pricing_tbl.LAST LOOP
577: select CSI_I_PRICING_ATTRIBS_H_S.nextval

Line 708: ,p_ext_attr_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.extend_attrib_values_rec_tab

704: --
705: PROCEDURE Build_Ext_Attr_Rec_Table
706: (
707: p_ext_attr_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
708: ,p_ext_attr_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.extend_attrib_values_rec_tab
709: ,p_ext_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
710: ) IS
711:
712: BEGIN

Line 709: ,p_ext_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM

705: PROCEDURE Build_Ext_Attr_Rec_Table
706: (
707: p_ext_attr_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
708: ,p_ext_attr_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.extend_attrib_values_rec_tab
709: ,p_ext_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
710: ) IS
711:
712: BEGIN
713: FOR i in p_ext_attr_tbl.FIRST .. p_ext_attr_tbl.LAST LOOP

Line 747: ,p_asset_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.instance_asset_rec_tab

743: --
744: PROCEDURE Build_Asset_Rec_Table
745: (
746: p_asset_tbl IN csi_datastructures_pub.instance_asset_tbl
747: ,p_asset_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.instance_asset_rec_tab
748: ,p_asset_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
749: ) IS
750:
751: BEGIN

Line 748: ,p_asset_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM

744: PROCEDURE Build_Asset_Rec_Table
745: (
746: p_asset_tbl IN csi_datastructures_pub.instance_asset_tbl
747: ,p_asset_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.instance_asset_rec_tab
748: ,p_asset_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
749: ) IS
750:
751: BEGIN
752: FOR i in p_asset_tbl.FIRST .. p_asset_tbl.LAST LOOP

Line 1404: l_inst_rec_tab csi_diagnostics_pkg.instance_rec_tab;

1400: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1401: l_version_label_tbl csi_datastructures_pub.version_label_tbl;
1402: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1403: --
1404: l_inst_rec_tab csi_diagnostics_pkg.instance_rec_tab;
1405: l_version_label_rec_tab csi_diagnostics_pkg.version_label_rec_tab;
1406: l_party_rec_tab csi_diagnostics_pkg.party_rec_tab;
1407: l_account_rec_tab csi_diagnostics_pkg.account_rec_tab;
1408: l_ext_attr_rec_tab csi_diagnostics_pkg.extend_attrib_values_rec_tab;

Line 1405: l_version_label_rec_tab csi_diagnostics_pkg.version_label_rec_tab;

1401: l_version_label_tbl csi_datastructures_pub.version_label_tbl;
1402: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1403: --
1404: l_inst_rec_tab csi_diagnostics_pkg.instance_rec_tab;
1405: l_version_label_rec_tab csi_diagnostics_pkg.version_label_rec_tab;
1406: l_party_rec_tab csi_diagnostics_pkg.party_rec_tab;
1407: l_account_rec_tab csi_diagnostics_pkg.account_rec_tab;
1408: l_ext_attr_rec_tab csi_diagnostics_pkg.extend_attrib_values_rec_tab;
1409: l_asset_rec_tab csi_diagnostics_pkg.instance_asset_rec_tab;

Line 1406: l_party_rec_tab csi_diagnostics_pkg.party_rec_tab;

1402: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1403: --
1404: l_inst_rec_tab csi_diagnostics_pkg.instance_rec_tab;
1405: l_version_label_rec_tab csi_diagnostics_pkg.version_label_rec_tab;
1406: l_party_rec_tab csi_diagnostics_pkg.party_rec_tab;
1407: l_account_rec_tab csi_diagnostics_pkg.account_rec_tab;
1408: l_ext_attr_rec_tab csi_diagnostics_pkg.extend_attrib_values_rec_tab;
1409: l_asset_rec_tab csi_diagnostics_pkg.instance_asset_rec_tab;
1410: l_org_units_rec_tab csi_diagnostics_pkg.org_units_rec_tab;

Line 1407: l_account_rec_tab csi_diagnostics_pkg.account_rec_tab;

1403: --
1404: l_inst_rec_tab csi_diagnostics_pkg.instance_rec_tab;
1405: l_version_label_rec_tab csi_diagnostics_pkg.version_label_rec_tab;
1406: l_party_rec_tab csi_diagnostics_pkg.party_rec_tab;
1407: l_account_rec_tab csi_diagnostics_pkg.account_rec_tab;
1408: l_ext_attr_rec_tab csi_diagnostics_pkg.extend_attrib_values_rec_tab;
1409: l_asset_rec_tab csi_diagnostics_pkg.instance_asset_rec_tab;
1410: l_org_units_rec_tab csi_diagnostics_pkg.org_units_rec_tab;
1411: l_pricing_rec_tab csi_diagnostics_pkg.pricing_attribs_rec_tab;

Line 1408: l_ext_attr_rec_tab csi_diagnostics_pkg.extend_attrib_values_rec_tab;

1404: l_inst_rec_tab csi_diagnostics_pkg.instance_rec_tab;
1405: l_version_label_rec_tab csi_diagnostics_pkg.version_label_rec_tab;
1406: l_party_rec_tab csi_diagnostics_pkg.party_rec_tab;
1407: l_account_rec_tab csi_diagnostics_pkg.account_rec_tab;
1408: l_ext_attr_rec_tab csi_diagnostics_pkg.extend_attrib_values_rec_tab;
1409: l_asset_rec_tab csi_diagnostics_pkg.instance_asset_rec_tab;
1410: l_org_units_rec_tab csi_diagnostics_pkg.org_units_rec_tab;
1411: l_pricing_rec_tab csi_diagnostics_pkg.pricing_attribs_rec_tab;
1412: l_ii_relationship_rec_tab csi_diagnostics_pkg.ii_relationship_rec_tab;

Line 1409: l_asset_rec_tab csi_diagnostics_pkg.instance_asset_rec_tab;

1405: l_version_label_rec_tab csi_diagnostics_pkg.version_label_rec_tab;
1406: l_party_rec_tab csi_diagnostics_pkg.party_rec_tab;
1407: l_account_rec_tab csi_diagnostics_pkg.account_rec_tab;
1408: l_ext_attr_rec_tab csi_diagnostics_pkg.extend_attrib_values_rec_tab;
1409: l_asset_rec_tab csi_diagnostics_pkg.instance_asset_rec_tab;
1410: l_org_units_rec_tab csi_diagnostics_pkg.org_units_rec_tab;
1411: l_pricing_rec_tab csi_diagnostics_pkg.pricing_attribs_rec_tab;
1412: l_ii_relationship_rec_tab csi_diagnostics_pkg.ii_relationship_rec_tab;
1413: --

Line 1410: l_org_units_rec_tab csi_diagnostics_pkg.org_units_rec_tab;

1406: l_party_rec_tab csi_diagnostics_pkg.party_rec_tab;
1407: l_account_rec_tab csi_diagnostics_pkg.account_rec_tab;
1408: l_ext_attr_rec_tab csi_diagnostics_pkg.extend_attrib_values_rec_tab;
1409: l_asset_rec_tab csi_diagnostics_pkg.instance_asset_rec_tab;
1410: l_org_units_rec_tab csi_diagnostics_pkg.org_units_rec_tab;
1411: l_pricing_rec_tab csi_diagnostics_pkg.pricing_attribs_rec_tab;
1412: l_ii_relationship_rec_tab csi_diagnostics_pkg.ii_relationship_rec_tab;
1413: --
1414: l_inst_hist_tbl csi_diagnostics_pkg.T_NUM;

Line 1411: l_pricing_rec_tab csi_diagnostics_pkg.pricing_attribs_rec_tab;

1407: l_account_rec_tab csi_diagnostics_pkg.account_rec_tab;
1408: l_ext_attr_rec_tab csi_diagnostics_pkg.extend_attrib_values_rec_tab;
1409: l_asset_rec_tab csi_diagnostics_pkg.instance_asset_rec_tab;
1410: l_org_units_rec_tab csi_diagnostics_pkg.org_units_rec_tab;
1411: l_pricing_rec_tab csi_diagnostics_pkg.pricing_attribs_rec_tab;
1412: l_ii_relationship_rec_tab csi_diagnostics_pkg.ii_relationship_rec_tab;
1413: --
1414: l_inst_hist_tbl csi_diagnostics_pkg.T_NUM;
1415: l_party_hist_tbl csi_diagnostics_pkg.T_NUM;

Line 1412: l_ii_relationship_rec_tab csi_diagnostics_pkg.ii_relationship_rec_tab;

1408: l_ext_attr_rec_tab csi_diagnostics_pkg.extend_attrib_values_rec_tab;
1409: l_asset_rec_tab csi_diagnostics_pkg.instance_asset_rec_tab;
1410: l_org_units_rec_tab csi_diagnostics_pkg.org_units_rec_tab;
1411: l_pricing_rec_tab csi_diagnostics_pkg.pricing_attribs_rec_tab;
1412: l_ii_relationship_rec_tab csi_diagnostics_pkg.ii_relationship_rec_tab;
1413: --
1414: l_inst_hist_tbl csi_diagnostics_pkg.T_NUM;
1415: l_party_hist_tbl csi_diagnostics_pkg.T_NUM;
1416: l_account_hist_tbl csi_diagnostics_pkg.T_NUM;

Line 1414: l_inst_hist_tbl csi_diagnostics_pkg.T_NUM;

1410: l_org_units_rec_tab csi_diagnostics_pkg.org_units_rec_tab;
1411: l_pricing_rec_tab csi_diagnostics_pkg.pricing_attribs_rec_tab;
1412: l_ii_relationship_rec_tab csi_diagnostics_pkg.ii_relationship_rec_tab;
1413: --
1414: l_inst_hist_tbl csi_diagnostics_pkg.T_NUM;
1415: l_party_hist_tbl csi_diagnostics_pkg.T_NUM;
1416: l_account_hist_tbl csi_diagnostics_pkg.T_NUM;
1417: l_org_hist_tbl csi_diagnostics_pkg.T_NUM;
1418: l_ext_hist_tbl csi_diagnostics_pkg.T_NUM;

Line 1415: l_party_hist_tbl csi_diagnostics_pkg.T_NUM;

1411: l_pricing_rec_tab csi_diagnostics_pkg.pricing_attribs_rec_tab;
1412: l_ii_relationship_rec_tab csi_diagnostics_pkg.ii_relationship_rec_tab;
1413: --
1414: l_inst_hist_tbl csi_diagnostics_pkg.T_NUM;
1415: l_party_hist_tbl csi_diagnostics_pkg.T_NUM;
1416: l_account_hist_tbl csi_diagnostics_pkg.T_NUM;
1417: l_org_hist_tbl csi_diagnostics_pkg.T_NUM;
1418: l_ext_hist_tbl csi_diagnostics_pkg.T_NUM;
1419: l_asset_hist_tbl csi_diagnostics_pkg.T_NUM;

Line 1416: l_account_hist_tbl csi_diagnostics_pkg.T_NUM;

1412: l_ii_relationship_rec_tab csi_diagnostics_pkg.ii_relationship_rec_tab;
1413: --
1414: l_inst_hist_tbl csi_diagnostics_pkg.T_NUM;
1415: l_party_hist_tbl csi_diagnostics_pkg.T_NUM;
1416: l_account_hist_tbl csi_diagnostics_pkg.T_NUM;
1417: l_org_hist_tbl csi_diagnostics_pkg.T_NUM;
1418: l_ext_hist_tbl csi_diagnostics_pkg.T_NUM;
1419: l_asset_hist_tbl csi_diagnostics_pkg.T_NUM;
1420: l_pricing_hist_tbl csi_diagnostics_pkg.T_NUM;

Line 1417: l_org_hist_tbl csi_diagnostics_pkg.T_NUM;

1413: --
1414: l_inst_hist_tbl csi_diagnostics_pkg.T_NUM;
1415: l_party_hist_tbl csi_diagnostics_pkg.T_NUM;
1416: l_account_hist_tbl csi_diagnostics_pkg.T_NUM;
1417: l_org_hist_tbl csi_diagnostics_pkg.T_NUM;
1418: l_ext_hist_tbl csi_diagnostics_pkg.T_NUM;
1419: l_asset_hist_tbl csi_diagnostics_pkg.T_NUM;
1420: l_pricing_hist_tbl csi_diagnostics_pkg.T_NUM;
1421: l_rel_hist_tbl csi_diagnostics_pkg.T_NUM;

Line 1418: l_ext_hist_tbl csi_diagnostics_pkg.T_NUM;

1414: l_inst_hist_tbl csi_diagnostics_pkg.T_NUM;
1415: l_party_hist_tbl csi_diagnostics_pkg.T_NUM;
1416: l_account_hist_tbl csi_diagnostics_pkg.T_NUM;
1417: l_org_hist_tbl csi_diagnostics_pkg.T_NUM;
1418: l_ext_hist_tbl csi_diagnostics_pkg.T_NUM;
1419: l_asset_hist_tbl csi_diagnostics_pkg.T_NUM;
1420: l_pricing_hist_tbl csi_diagnostics_pkg.T_NUM;
1421: l_rel_hist_tbl csi_diagnostics_pkg.T_NUM;
1422: l_ver_label_hist_tbl csi_diagnostics_pkg.T_NUM;

Line 1419: l_asset_hist_tbl csi_diagnostics_pkg.T_NUM;

1415: l_party_hist_tbl csi_diagnostics_pkg.T_NUM;
1416: l_account_hist_tbl csi_diagnostics_pkg.T_NUM;
1417: l_org_hist_tbl csi_diagnostics_pkg.T_NUM;
1418: l_ext_hist_tbl csi_diagnostics_pkg.T_NUM;
1419: l_asset_hist_tbl csi_diagnostics_pkg.T_NUM;
1420: l_pricing_hist_tbl csi_diagnostics_pkg.T_NUM;
1421: l_rel_hist_tbl csi_diagnostics_pkg.T_NUM;
1422: l_ver_label_hist_tbl csi_diagnostics_pkg.T_NUM;
1423: --

Line 1420: l_pricing_hist_tbl csi_diagnostics_pkg.T_NUM;

1416: l_account_hist_tbl csi_diagnostics_pkg.T_NUM;
1417: l_org_hist_tbl csi_diagnostics_pkg.T_NUM;
1418: l_ext_hist_tbl csi_diagnostics_pkg.T_NUM;
1419: l_asset_hist_tbl csi_diagnostics_pkg.T_NUM;
1420: l_pricing_hist_tbl csi_diagnostics_pkg.T_NUM;
1421: l_rel_hist_tbl csi_diagnostics_pkg.T_NUM;
1422: l_ver_label_hist_tbl csi_diagnostics_pkg.T_NUM;
1423: --
1424: l_owner_src_table VARCHAR2(30);

Line 1421: l_rel_hist_tbl csi_diagnostics_pkg.T_NUM;

1417: l_org_hist_tbl csi_diagnostics_pkg.T_NUM;
1418: l_ext_hist_tbl csi_diagnostics_pkg.T_NUM;
1419: l_asset_hist_tbl csi_diagnostics_pkg.T_NUM;
1420: l_pricing_hist_tbl csi_diagnostics_pkg.T_NUM;
1421: l_rel_hist_tbl csi_diagnostics_pkg.T_NUM;
1422: l_ver_label_hist_tbl csi_diagnostics_pkg.T_NUM;
1423: --
1424: l_owner_src_table VARCHAR2(30);
1425: l_owner_party NUMBER;

Line 1422: l_ver_label_hist_tbl csi_diagnostics_pkg.T_NUM;

1418: l_ext_hist_tbl csi_diagnostics_pkg.T_NUM;
1419: l_asset_hist_tbl csi_diagnostics_pkg.T_NUM;
1420: l_pricing_hist_tbl csi_diagnostics_pkg.T_NUM;
1421: l_rel_hist_tbl csi_diagnostics_pkg.T_NUM;
1422: l_ver_label_hist_tbl csi_diagnostics_pkg.T_NUM;
1423: --
1424: l_owner_src_table VARCHAR2(30);
1425: l_owner_party NUMBER;
1426: l_owner_account NUMBER;

Line 15368: l_rma_txn_tbl csi_diagnostics_pkg.rma_txn_tbl;

15364:
15365: --added for bug 5248037--
15366: MAX_BUFFER_SIZE number := 1000;
15367: l_rec_change BOOLEAN;
15368: l_rma_txn_tbl csi_diagnostics_pkg.rma_txn_tbl;
15369: l_instance_tbl csi_diagnostics_pkg.instance_tbl;
15370:
15371: --Modified rma_cur and inst_cur for 5248037--
15372: CURSOR rma_cur

Line 15369: l_instance_tbl csi_diagnostics_pkg.instance_tbl;

15365: --added for bug 5248037--
15366: MAX_BUFFER_SIZE number := 1000;
15367: l_rec_change BOOLEAN;
15368: l_rma_txn_tbl csi_diagnostics_pkg.rma_txn_tbl;
15369: l_instance_tbl csi_diagnostics_pkg.instance_tbl;
15370:
15371: --Modified rma_cur and inst_cur for 5248037--
15372: CURSOR rma_cur
15373: IS

Line 16487: csi_diagnostics_pkg.get_nl_trackable_report;

16483: RAISE comp_error;
16484: END IF;
16485: -- checks block -- show stoppers
16486: log(date_time_stamp||'get_nl_trackable_report');
16487: csi_diagnostics_pkg.get_nl_trackable_report;
16488:
16489: IF l_global_warning_flag = 'Y' THEN
16490: log('Inconsistent IB trackable flag setup in org items and master items detected.');
16491: log('Please fix the items in the report csinonl..dbg and then rerun the program.');

Line 16500: csi_diagnostics_pkg.check_org_uniqueness;

16496: END IF;
16497:
16498: -- reports block
16499: log(date_time_stamp||'check_org_uniqueness');
16500: csi_diagnostics_pkg.check_org_uniqueness;
16501:
16502: log(date_time_stamp||'get_non_srl_rma_report');
16503: csi_diagnostics_pkg.get_non_srl_rma_report(
16504: p_show_instances => p_show_instances);

Line 16503: csi_diagnostics_pkg.get_non_srl_rma_report(

16499: log(date_time_stamp||'check_org_uniqueness');
16500: csi_diagnostics_pkg.check_org_uniqueness;
16501:
16502: log(date_time_stamp||'get_non_srl_rma_report');
16503: csi_diagnostics_pkg.get_non_srl_rma_report(
16504: p_show_instances => p_show_instances);
16505: --
16506: -- Enable the Lookup Values that contain the Data Fix routines so that they all get executed.
16507: --

Line 16529: csi_diagnostics_pkg.Delete_Dup_Relationship;

16525: --
16526: IF Is_Routine_Enabled(l_lookup_tbl,'DELETE_DUP_RELATIONSHIP') THEN
16527: Update_Lookup('DELETE_DUP_RELATIONSHIP');
16528: log(date_time_stamp||'delete_dup_relationship');
16529: csi_diagnostics_pkg.Delete_Dup_Relationship;
16530: commit;
16531: ELSE
16532: log(date_time_stamp||'delete_dup_relationship already executed...');
16533: END IF;

Line 16538: csi_diagnostics_pkg.Update_No_Ctl_Srl_Lot_Inst;

16534:
16535: IF Is_Routine_Enabled(l_lookup_tbl,'UPDATE_NO_CTL_SRL_LOT_INST') THEN
16536: Update_Lookup('UPDATE_NO_CTL_SRL_LOT_INST');
16537: log(date_time_stamp||'update_no_ctl_srl_lot_inst');
16538: csi_diagnostics_pkg.Update_No_Ctl_Srl_Lot_Inst;
16539: commit;
16540: ELSE
16541: log(date_time_stamp||'Update_No_Ctl_Srl_Lot_Inst already executed...');
16542: END IF;

Line 16547: csi_diagnostics_pkg.Delete_Dup_Srl_Inv_Instance;

16543:
16544: IF Is_Routine_Enabled(l_lookup_tbl,'DELETE_DUP_SRL_INV_INSTANCE') THEN
16545: Update_Lookup('DELETE_DUP_SRL_INV_INSTANCE');
16546: log(date_time_stamp||'delete_dup_srl_inv_instance');
16547: csi_diagnostics_pkg.Delete_Dup_Srl_Inv_Instance;
16548: ELSE
16549: log(date_time_stamp||'Delete_Dup_Srl_Inv_Instance already executed...');
16550: END IF;
16551:

Line 16555: csi_diagnostics_pkg.Update_Dup_Srl_Instance;

16551:
16552: IF Is_Routine_Enabled(l_lookup_tbl,'UPDATE_DUP_SRL_INSTANCE') THEN
16553: Update_Lookup('UPDATE_DUP_SRL_INSTANCE');
16554: log(date_time_stamp||'update_dup_srl_instance');
16555: csi_diagnostics_pkg.Update_Dup_Srl_Instance;
16556: commit;
16557: ELSE
16558: log(date_time_stamp||'Update_Dup_Srl_Instance already executed...');
16559: END IF;

Line 16564: csi_diagnostics_pkg.Del_API_Dup_Srl_Instance;

16560:
16561: IF Is_Routine_Enabled(l_lookup_tbl,'DEL_API_DUP_SRL_INSTANCE') THEN
16562: Update_Lookup('DEL_API_DUP_SRL_INSTANCE');
16563: log(date_time_stamp||'del_api_dup_srl_instance');
16564: csi_diagnostics_pkg.Del_API_Dup_Srl_Instance;
16565: commit;
16566: ELSE
16567: log(date_time_stamp||'Del_API_Dup_Srl_Instance already executed...');
16568: END IF;

Line 16573: csi_diagnostics_pkg.Update_Instance_Usage;

16569:
16570: IF Is_Routine_Enabled(l_lookup_tbl,'UPDATE_INSTANCE_USAGE') THEN
16571: Update_Lookup('UPDATE_INSTANCE_USAGE');
16572: log(date_time_stamp||'update_instance_usage');
16573: csi_diagnostics_pkg.Update_Instance_Usage;
16574: commit;
16575: ELSE
16576: log(date_time_stamp||'Update_Instance_Usage already executed...');
16577: END IF;

Line 16582: csi_diagnostics_pkg.Update_Full_dump_flag;

16578:
16579: IF Is_Routine_Enabled(l_lookup_tbl,'UPDATE_FULL_DUMP_FLAG') THEN
16580: Update_Lookup('UPDATE_FULL_DUMP_FLAG');
16581: log(date_time_stamp||'update_full_dump_flag');
16582: csi_diagnostics_pkg.Update_Full_dump_flag;
16583: commit;
16584: ELSE
16585: log(date_time_stamp||'Update_Full_dump_flag already executed...');
16586: END IF;

Line 16591: csi_diagnostics_pkg.Update_Vld_Organization;

16587:
16588: IF Is_Routine_Enabled(l_lookup_tbl,'UPDATE_VLD_ORGANIZATION') THEN
16589: Update_Lookup('UPDATE_VLD_ORGANIZATION');
16590: log(date_time_stamp||'update_vld_organization');
16591: csi_diagnostics_pkg.Update_Vld_Organization;
16592: commit;
16593: ELSE
16594: log(date_time_stamp||'Update_Vld_Organization already executed...');
16595: END IF;

Line 16600: csi_diagnostics_pkg.Update_Revision;

16596:
16597: IF Is_Routine_Enabled(l_lookup_tbl,'UPDATE_REVISION') THEN
16598: Update_Lookup('UPDATE_REVISION');
16599: log(date_time_stamp||'update_revision');
16600: csi_diagnostics_pkg.Update_Revision;
16601: commit;
16602: ELSE
16603: log(date_time_stamp||'Update_Revision already executed...');
16604: END IF;

Line 16609: csi_diagnostics_pkg.merge_non_srl_inv_instance;

16605:
16606: IF Is_Routine_Enabled(l_lookup_tbl,'MERGE_NON_SRL_INV_INSTANCE') THEN
16607: Update_Lookup('MERGE_NON_SRL_INV_INSTANCE');
16608: log(date_time_stamp||'merge_non_srl_inv_instance');
16609: csi_diagnostics_pkg.merge_non_srl_inv_instance;
16610: commit;
16611: ELSE
16612: log(date_time_stamp||'merge_non_srl_inv_instance already executed...');
16613: END IF;

Line 16618: csi_diagnostics_pkg.delete_dup_account;

16614:
16615: IF Is_Routine_Enabled(l_lookup_tbl,'DELETE_DUP_ACCOUNT') THEN
16616: Update_Lookup('DELETE_DUP_ACCOUNT');
16617: log(date_time_stamp||'delete_dup_account');
16618: csi_diagnostics_pkg.delete_dup_account;
16619: commit;
16620: ELSE
16621: log(date_time_stamp||'delete_dup_account already executed...');
16622: END IF;

Line 16627: csi_diagnostics_pkg.update_instance_party_source;

16623:
16624: IF Is_Routine_Enabled(l_lookup_tbl,'UPDATE_INSTANCE_PARTY_SOURCE') THEN
16625: Update_Lookup('UPDATE_INSTANCE_PARTY_SOURCE');
16626: log(date_time_stamp||'update_instance_party_source');
16627: csi_diagnostics_pkg.update_instance_party_source;
16628: commit;
16629: ELSE
16630: log(date_time_stamp||'update_instance_party_source already executed...');
16631: END IF;

Line 16636: csi_diagnostics_pkg.update_contact_party_record;

16632:
16633: IF Is_Routine_Enabled(l_lookup_tbl,'UPDATE_CONTACT_PARTY_RECORD') THEN
16634: Update_Lookup('UPDATE_CONTACT_PARTY_RECORD');
16635: log(date_time_stamp||'update_contact_party_record');
16636: csi_diagnostics_pkg.update_contact_party_record;
16637: commit;
16638: ELSE
16639: log(date_time_stamp||'update_contact_party_record already executed...');
16640: END IF;

Line 16645: csi_diagnostics_pkg.revert_party_rel_type_update;

16641:
16642: IF Is_Routine_Enabled(l_lookup_tbl,'REVERT_PARTY_REL_TYPE_UPDATE') THEN
16643: Update_Lookup('REVERT_PARTY_REL_TYPE_UPDATE');
16644: log(date_time_stamp||'revert_party_rel_type_update');
16645: csi_diagnostics_pkg.revert_party_rel_type_update;
16646: commit;
16647: ELSE
16648: log(date_time_stamp||'revert_party_rel_type_update already executed...');
16649: END IF;

Line 16654: csi_diagnostics_pkg.update_master_organization_ID;

16650:
16651: IF Is_Routine_Enabled(l_lookup_tbl,'UPDATE_MASTER_ORGANIZATION_ID') THEN
16652: Update_Lookup('UPDATE_MASTER_ORGANIZATION_ID');
16653: log(date_time_stamp||'update_master_organization_id');
16654: csi_diagnostics_pkg.update_master_organization_ID;
16655: commit;
16656: ELSE
16657: log(date_time_stamp||'update_master_organization_ID already executed...');
16658: END IF;

Line 16663: csi_diagnostics_pkg.missing_mtl_txn_id_in_csi;

16659:
16660: IF Is_Routine_Enabled(l_lookup_tbl,'MISSING_MTL_TXN_ID_IN_CSI') THEN
16661: Update_Lookup('MISSING_MTL_TXN_ID_IN_CSI');
16662: log(date_time_stamp||'missing_mtl_txn_id_in_csi');
16663: csi_diagnostics_pkg.missing_mtl_txn_id_in_csi;
16664: commit;
16665: ELSE
16666: log(date_time_stamp||'missing_mtl_txn_id_in_csi already executed...');
16667: END IF;

Line 16672: csi_diagnostics_pkg.fix_wip_usage;

16668:
16669: IF Is_Routine_Enabled(l_lookup_tbl,'FIX_WIP_USAGE') THEN
16670: Update_Lookup('FIX_WIP_USAGE');
16671: log(date_time_stamp||'fix_wip_usage');
16672: csi_diagnostics_pkg.fix_wip_usage;
16673: commit;
16674: ELSE
16675: log(date_time_stamp||'fix_wip_usage already executed...');
16676: END IF;

Line 16681: csi_diagnostics_pkg.delete_dup_nsrl_wip_instances;

16677:
16678: IF Is_Routine_Enabled(l_lookup_tbl,'DELETE_DUP_NSRL_WIP_INSTANCES') THEN
16679: Update_Lookup('DELETE_DUP_NSRL_WIP_INSTANCES');
16680: log(date_time_stamp||'delete_dup_nsrl_wip_instances');
16681: csi_diagnostics_pkg.delete_dup_nsrl_wip_instances;
16682: commit;
16683: ELSE
16684: log(date_time_stamp||'delete_dup_nsrl_wip_instances already executed...');
16685: END IF;

Line 16690: csi_diagnostics_pkg.Delete_Dup_Org_Assignments;

16686:
16687: IF Is_Routine_Enabled(l_lookup_tbl,'DELETE_DUP_ORG_ASSIGNMENTS') THEN
16688: Update_Lookup('DELETE_DUP_ORG_ASSIGNMENTS');
16689: log(date_time_stamp||'Delete_Dup_Org_Assignments');
16690: csi_diagnostics_pkg.Delete_Dup_Org_Assignments;
16691: commit;
16692: ELSE
16693: log(date_time_stamp||'Delete_Dup_Org_Assignments already executed...');
16694: END IF;

Line 16724: csi_diagnostics_pkg.expire_non_trackable_instance;

16720:
16721: IF Is_Routine_Enabled(l_lookup_tbl,'EXPIRE_NON_TRACKABLE_INSTANCE') THEN
16722: Update_Lookup('EXPIRE_NON_TRACKABLE_INSTANCE');
16723: log(date_time_stamp||'expire_non_trackable_instance');
16724: csi_diagnostics_pkg.expire_non_trackable_instance;
16725: commit;
16726: ELSE
16727: log(date_time_stamp||'expire_non_trackable_instance already executed...');
16728: END IF;

Line 16731: csi_diagnostics_pkg.fix_srlsoi_returned_serials;

16727: log(date_time_stamp||'expire_non_trackable_instance already executed...');
16728: END IF;
16729:
16730: log(date_time_stamp||'fix_srlsoi_returned_serials');
16731: csi_diagnostics_pkg.fix_srlsoi_returned_serials;
16732:
16733: log(date_time_stamp||'mark_error_transactions');
16734: csi_diagnostics_pkg.mark_error_transactions;
16735:

Line 16734: csi_diagnostics_pkg.mark_error_transactions;

16730: log(date_time_stamp||'fix_srlsoi_returned_serials');
16731: csi_diagnostics_pkg.fix_srlsoi_returned_serials;
16732:
16733: log(date_time_stamp||'mark_error_transactions');
16734: csi_diagnostics_pkg.mark_error_transactions;
16735:
16736: log(date_time_stamp||'create_or_update_shipping_inst');
16737: csi_diagnostics_pkg.create_or_update_shipping_inst;
16738:

Line 16737: csi_diagnostics_pkg.create_or_update_shipping_inst;

16733: log(date_time_stamp||'mark_error_transactions');
16734: csi_diagnostics_pkg.mark_error_transactions;
16735:
16736: log(date_time_stamp||'create_or_update_shipping_inst');
16737: csi_diagnostics_pkg.create_or_update_shipping_inst;
16738:
16739: l_auto_populate_allowed := FND_PROFILE.VALUE('CSI_AUTO_POPULATE_INSTANCE'); --bug 5248037--
16740: log('Auto population allowed '||l_auto_populate_allowed);
16741:

Line 16745: csi_diagnostics_pkg.create_nsrl_rma_tld;

16741:
16742: --Added IF condition for bug 5248037--
16743: IF UPPER(l_auto_populate_allowed) = 'Y' THEN
16744: log(date_time_stamp||'create_nsrl_rma_tld');
16745: csi_diagnostics_pkg.create_nsrl_rma_tld;
16746: END IF;
16747:
16748: -- serial data spool and preprocess
16749: log(date_time_stamp||'get_srldata');

Line 16750: csi_diagnostics_pkg.get_srldata;

16746: END IF;
16747:
16748: -- serial data spool and preprocess
16749: log(date_time_stamp||'get_srldata');
16750: csi_diagnostics_pkg.get_srldata;
16751:
16752: log(date_time_stamp||'preprocess_srldata');
16753: csi_diagnostics_pkg.preprocess_srldata;
16754:

Line 16753: csi_diagnostics_pkg.preprocess_srldata;

16749: log(date_time_stamp||'get_srldata');
16750: csi_diagnostics_pkg.get_srldata;
16751:
16752: log(date_time_stamp||'preprocess_srldata');
16753: csi_diagnostics_pkg.preprocess_srldata;
16754:
16755: -- fix srl errors
16756: log(date_time_stamp||'fix_srldata');
16757: csi_diagnostics_pkg.fix_srldata;

Line 16757: csi_diagnostics_pkg.fix_srldata;

16753: csi_diagnostics_pkg.preprocess_srldata;
16754:
16755: -- fix srl errors
16756: log(date_time_stamp||'fix_srldata');
16757: csi_diagnostics_pkg.fix_srldata;
16758:
16759: -- serial correction reports
16760: log(date_time_stamp||'spool errors serial Info');
16761: csi_diagnostics_pkg.spool_srldata('ERRORS');

Line 16761: csi_diagnostics_pkg.spool_srldata('ERRORS');

16757: csi_diagnostics_pkg.fix_srldata;
16758:
16759: -- serial correction reports
16760: log(date_time_stamp||'spool errors serial Info');
16761: csi_diagnostics_pkg.spool_srldata('ERRORS');
16762:
16763: -- serial correction reports
16764: log(date_time_stamp||'spool all serial info');
16765: csi_diagnostics_pkg.spool_srldata('ALL');

Line 16765: csi_diagnostics_pkg.spool_srldata('ALL');

16761: csi_diagnostics_pkg.spool_srldata('ERRORS');
16762:
16763: -- serial correction reports
16764: log(date_time_stamp||'spool all serial info');
16765: csi_diagnostics_pkg.spool_srldata('ALL');
16766:
16767: -- spawn the resubmit interface for the marked errors
16768: log(date_time_stamp||'Resubmit errors for the corrected serial numbers');
16769: csi_resubmit_pub.Resubmit_Interface(

Line 16780: csi_diagnostics_pkg.forward_sync;

16776: populate_mtl_txn_creation_date;
16777:
16778: -- forward sync serial routine
16779: log(date_time_stamp||'forward_sync');
16780: csi_diagnostics_pkg.forward_sync;
16781: commit;
16782:
16783: -- Check whether all the instances are forward synched
16784: BEGIN

Line 16822: csi_diagnostics_pkg.sync_inv_serials;

16818: END IF;
16819: --
16820:
16821: log(date_time_stamp||'sync_inv_serials');
16822: csi_diagnostics_pkg.sync_inv_serials;
16823:
16824: log(date_time_stamp||'ib_inv_synch_non_srl');
16825: csi_diagnostics_pkg.ib_inv_synch_non_srl;
16826:

Line 16825: csi_diagnostics_pkg.ib_inv_synch_non_srl;

16821: log(date_time_stamp||'sync_inv_serials');
16822: csi_diagnostics_pkg.sync_inv_serials;
16823:
16824: log(date_time_stamp||'ib_inv_synch_non_srl');
16825: csi_diagnostics_pkg.ib_inv_synch_non_srl;
16826:
16827: log(date_time_stamp||'reverse_ib_inv_synch');
16828: csi_diagnostics_pkg.reverse_ib_inv_synch;
16829:

Line 16828: csi_diagnostics_pkg.reverse_ib_inv_synch;

16824: log(date_time_stamp||'ib_inv_synch_non_srl');
16825: csi_diagnostics_pkg.ib_inv_synch_non_srl;
16826:
16827: log(date_time_stamp||'reverse_ib_inv_synch');
16828: csi_diagnostics_pkg.reverse_ib_inv_synch;
16829:
16830: END IF;
16831:
16832: drop_mmt_trigger;

Line 16958: END csi_diagnostics_pkg;

16954: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
16955: RAISE;
16956: END create_oper_upd_worker;
16957:
16958: END csi_diagnostics_pkg;