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.20.12020000.3 2013/03/20 12:03:41 mvaradam 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 15379: l_rma_txn_tbl csi_diagnostics_pkg.rma_txn_tbl;

15375:
15376: --added for bug 5248037--
15377: MAX_BUFFER_SIZE number := 1000;
15378: l_rec_change BOOLEAN;
15379: l_rma_txn_tbl csi_diagnostics_pkg.rma_txn_tbl;
15380: l_instance_tbl csi_diagnostics_pkg.instance_tbl;
15381:
15382: --Modified rma_cur and inst_cur for 5248037--
15383: CURSOR rma_cur

Line 15380: l_instance_tbl csi_diagnostics_pkg.instance_tbl;

15376: --added for bug 5248037--
15377: MAX_BUFFER_SIZE number := 1000;
15378: l_rec_change BOOLEAN;
15379: l_rma_txn_tbl csi_diagnostics_pkg.rma_txn_tbl;
15380: l_instance_tbl csi_diagnostics_pkg.instance_tbl;
15381:
15382: --Modified rma_cur and inst_cur for 5248037--
15383: CURSOR rma_cur
15384: IS

Line 16498: csi_diagnostics_pkg.get_nl_trackable_report;

16494: RAISE comp_error;
16495: END IF;
16496: -- checks block -- show stoppers
16497: log(date_time_stamp||'get_nl_trackable_report');
16498: csi_diagnostics_pkg.get_nl_trackable_report;
16499:
16500: IF l_global_warning_flag = 'Y' THEN
16501: log('Inconsistent IB trackable flag setup in org items and master items detected.');
16502: log('Please fix the items in the report csinonl..dbg and then rerun the program.');

Line 16511: csi_diagnostics_pkg.check_org_uniqueness;

16507: END IF;
16508:
16509: -- reports block
16510: log(date_time_stamp||'check_org_uniqueness');
16511: csi_diagnostics_pkg.check_org_uniqueness;
16512:
16513: log(date_time_stamp||'get_non_srl_rma_report');
16514: csi_diagnostics_pkg.get_non_srl_rma_report(
16515: p_show_instances => p_show_instances);

Line 16514: csi_diagnostics_pkg.get_non_srl_rma_report(

16510: log(date_time_stamp||'check_org_uniqueness');
16511: csi_diagnostics_pkg.check_org_uniqueness;
16512:
16513: log(date_time_stamp||'get_non_srl_rma_report');
16514: csi_diagnostics_pkg.get_non_srl_rma_report(
16515: p_show_instances => p_show_instances);
16516: --
16517: -- Enable the Lookup Values that contain the Data Fix routines so that they all get executed.
16518: --

Line 16540: csi_diagnostics_pkg.Delete_Dup_Relationship;

16536: --
16537: IF Is_Routine_Enabled(l_lookup_tbl,'DELETE_DUP_RELATIONSHIP') THEN
16538: Update_Lookup('DELETE_DUP_RELATIONSHIP');
16539: log(date_time_stamp||'delete_dup_relationship');
16540: csi_diagnostics_pkg.Delete_Dup_Relationship;
16541: commit;
16542: ELSE
16543: log(date_time_stamp||'delete_dup_relationship already executed...');
16544: END IF;

Line 16549: csi_diagnostics_pkg.Update_No_Ctl_Srl_Lot_Inst;

16545:
16546: IF Is_Routine_Enabled(l_lookup_tbl,'UPDATE_NO_CTL_SRL_LOT_INST') THEN
16547: Update_Lookup('UPDATE_NO_CTL_SRL_LOT_INST');
16548: log(date_time_stamp||'update_no_ctl_srl_lot_inst');
16549: csi_diagnostics_pkg.Update_No_Ctl_Srl_Lot_Inst;
16550: commit;
16551: ELSE
16552: log(date_time_stamp||'Update_No_Ctl_Srl_Lot_Inst already executed...');
16553: END IF;

Line 16558: csi_diagnostics_pkg.Delete_Dup_Srl_Inv_Instance;

16554:
16555: IF Is_Routine_Enabled(l_lookup_tbl,'DELETE_DUP_SRL_INV_INSTANCE') THEN
16556: Update_Lookup('DELETE_DUP_SRL_INV_INSTANCE');
16557: log(date_time_stamp||'delete_dup_srl_inv_instance');
16558: csi_diagnostics_pkg.Delete_Dup_Srl_Inv_Instance;
16559: ELSE
16560: log(date_time_stamp||'Delete_Dup_Srl_Inv_Instance already executed...');
16561: END IF;
16562:

Line 16566: csi_diagnostics_pkg.Update_Dup_Srl_Instance;

16562:
16563: IF Is_Routine_Enabled(l_lookup_tbl,'UPDATE_DUP_SRL_INSTANCE') THEN
16564: Update_Lookup('UPDATE_DUP_SRL_INSTANCE');
16565: log(date_time_stamp||'update_dup_srl_instance');
16566: csi_diagnostics_pkg.Update_Dup_Srl_Instance;
16567: commit;
16568: ELSE
16569: log(date_time_stamp||'Update_Dup_Srl_Instance already executed...');
16570: END IF;

Line 16575: csi_diagnostics_pkg.Del_API_Dup_Srl_Instance;

16571:
16572: IF Is_Routine_Enabled(l_lookup_tbl,'DEL_API_DUP_SRL_INSTANCE') THEN
16573: Update_Lookup('DEL_API_DUP_SRL_INSTANCE');
16574: log(date_time_stamp||'del_api_dup_srl_instance');
16575: csi_diagnostics_pkg.Del_API_Dup_Srl_Instance;
16576: commit;
16577: ELSE
16578: log(date_time_stamp||'Del_API_Dup_Srl_Instance already executed...');
16579: END IF;

Line 16584: csi_diagnostics_pkg.Update_Instance_Usage;

16580:
16581: IF Is_Routine_Enabled(l_lookup_tbl,'UPDATE_INSTANCE_USAGE') THEN
16582: Update_Lookup('UPDATE_INSTANCE_USAGE');
16583: log(date_time_stamp||'update_instance_usage');
16584: csi_diagnostics_pkg.Update_Instance_Usage;
16585: commit;
16586: ELSE
16587: log(date_time_stamp||'Update_Instance_Usage already executed...');
16588: END IF;

Line 16593: csi_diagnostics_pkg.Update_Full_dump_flag;

16589:
16590: IF Is_Routine_Enabled(l_lookup_tbl,'UPDATE_FULL_DUMP_FLAG') THEN
16591: Update_Lookup('UPDATE_FULL_DUMP_FLAG');
16592: log(date_time_stamp||'update_full_dump_flag');
16593: csi_diagnostics_pkg.Update_Full_dump_flag;
16594: commit;
16595: ELSE
16596: log(date_time_stamp||'Update_Full_dump_flag already executed...');
16597: END IF;

Line 16602: csi_diagnostics_pkg.Update_Vld_Organization;

16598:
16599: IF Is_Routine_Enabled(l_lookup_tbl,'UPDATE_VLD_ORGANIZATION') THEN
16600: Update_Lookup('UPDATE_VLD_ORGANIZATION');
16601: log(date_time_stamp||'update_vld_organization');
16602: csi_diagnostics_pkg.Update_Vld_Organization;
16603: commit;
16604: ELSE
16605: log(date_time_stamp||'Update_Vld_Organization already executed...');
16606: END IF;

Line 16611: csi_diagnostics_pkg.Update_Revision;

16607:
16608: IF Is_Routine_Enabled(l_lookup_tbl,'UPDATE_REVISION') THEN
16609: Update_Lookup('UPDATE_REVISION');
16610: log(date_time_stamp||'update_revision');
16611: csi_diagnostics_pkg.Update_Revision;
16612: commit;
16613: ELSE
16614: log(date_time_stamp||'Update_Revision already executed...');
16615: END IF;

Line 16620: csi_diagnostics_pkg.merge_non_srl_inv_instance;

16616:
16617: IF Is_Routine_Enabled(l_lookup_tbl,'MERGE_NON_SRL_INV_INSTANCE') THEN
16618: Update_Lookup('MERGE_NON_SRL_INV_INSTANCE');
16619: log(date_time_stamp||'merge_non_srl_inv_instance');
16620: csi_diagnostics_pkg.merge_non_srl_inv_instance;
16621: commit;
16622: ELSE
16623: log(date_time_stamp||'merge_non_srl_inv_instance already executed...');
16624: END IF;

Line 16629: csi_diagnostics_pkg.delete_dup_account;

16625:
16626: IF Is_Routine_Enabled(l_lookup_tbl,'DELETE_DUP_ACCOUNT') THEN
16627: Update_Lookup('DELETE_DUP_ACCOUNT');
16628: log(date_time_stamp||'delete_dup_account');
16629: csi_diagnostics_pkg.delete_dup_account;
16630: commit;
16631: ELSE
16632: log(date_time_stamp||'delete_dup_account already executed...');
16633: END IF;

Line 16638: csi_diagnostics_pkg.update_instance_party_source;

16634:
16635: IF Is_Routine_Enabled(l_lookup_tbl,'UPDATE_INSTANCE_PARTY_SOURCE') THEN
16636: Update_Lookup('UPDATE_INSTANCE_PARTY_SOURCE');
16637: log(date_time_stamp||'update_instance_party_source');
16638: csi_diagnostics_pkg.update_instance_party_source;
16639: commit;
16640: ELSE
16641: log(date_time_stamp||'update_instance_party_source already executed...');
16642: END IF;

Line 16647: csi_diagnostics_pkg.update_contact_party_record;

16643:
16644: IF Is_Routine_Enabled(l_lookup_tbl,'UPDATE_CONTACT_PARTY_RECORD') THEN
16645: Update_Lookup('UPDATE_CONTACT_PARTY_RECORD');
16646: log(date_time_stamp||'update_contact_party_record');
16647: csi_diagnostics_pkg.update_contact_party_record;
16648: commit;
16649: ELSE
16650: log(date_time_stamp||'update_contact_party_record already executed...');
16651: END IF;

Line 16656: csi_diagnostics_pkg.revert_party_rel_type_update;

16652:
16653: IF Is_Routine_Enabled(l_lookup_tbl,'REVERT_PARTY_REL_TYPE_UPDATE') THEN
16654: Update_Lookup('REVERT_PARTY_REL_TYPE_UPDATE');
16655: log(date_time_stamp||'revert_party_rel_type_update');
16656: csi_diagnostics_pkg.revert_party_rel_type_update;
16657: commit;
16658: ELSE
16659: log(date_time_stamp||'revert_party_rel_type_update already executed...');
16660: END IF;

Line 16665: csi_diagnostics_pkg.update_master_organization_ID;

16661:
16662: IF Is_Routine_Enabled(l_lookup_tbl,'UPDATE_MASTER_ORGANIZATION_ID') THEN
16663: Update_Lookup('UPDATE_MASTER_ORGANIZATION_ID');
16664: log(date_time_stamp||'update_master_organization_id');
16665: csi_diagnostics_pkg.update_master_organization_ID;
16666: commit;
16667: ELSE
16668: log(date_time_stamp||'update_master_organization_ID already executed...');
16669: END IF;

Line 16674: csi_diagnostics_pkg.missing_mtl_txn_id_in_csi;

16670:
16671: IF Is_Routine_Enabled(l_lookup_tbl,'MISSING_MTL_TXN_ID_IN_CSI') THEN
16672: Update_Lookup('MISSING_MTL_TXN_ID_IN_CSI');
16673: log(date_time_stamp||'missing_mtl_txn_id_in_csi');
16674: csi_diagnostics_pkg.missing_mtl_txn_id_in_csi;
16675: commit;
16676: ELSE
16677: log(date_time_stamp||'missing_mtl_txn_id_in_csi already executed...');
16678: END IF;

Line 16683: csi_diagnostics_pkg.fix_wip_usage;

16679:
16680: IF Is_Routine_Enabled(l_lookup_tbl,'FIX_WIP_USAGE') THEN
16681: Update_Lookup('FIX_WIP_USAGE');
16682: log(date_time_stamp||'fix_wip_usage');
16683: csi_diagnostics_pkg.fix_wip_usage;
16684: commit;
16685: ELSE
16686: log(date_time_stamp||'fix_wip_usage already executed...');
16687: END IF;

Line 16692: csi_diagnostics_pkg.delete_dup_nsrl_wip_instances;

16688:
16689: IF Is_Routine_Enabled(l_lookup_tbl,'DELETE_DUP_NSRL_WIP_INSTANCES') THEN
16690: Update_Lookup('DELETE_DUP_NSRL_WIP_INSTANCES');
16691: log(date_time_stamp||'delete_dup_nsrl_wip_instances');
16692: csi_diagnostics_pkg.delete_dup_nsrl_wip_instances;
16693: commit;
16694: ELSE
16695: log(date_time_stamp||'delete_dup_nsrl_wip_instances already executed...');
16696: END IF;

Line 16701: csi_diagnostics_pkg.Delete_Dup_Org_Assignments;

16697:
16698: IF Is_Routine_Enabled(l_lookup_tbl,'DELETE_DUP_ORG_ASSIGNMENTS') THEN
16699: Update_Lookup('DELETE_DUP_ORG_ASSIGNMENTS');
16700: log(date_time_stamp||'Delete_Dup_Org_Assignments');
16701: csi_diagnostics_pkg.Delete_Dup_Org_Assignments;
16702: commit;
16703: ELSE
16704: log(date_time_stamp||'Delete_Dup_Org_Assignments already executed...');
16705: END IF;

Line 16735: csi_diagnostics_pkg.expire_non_trackable_instance;

16731:
16732: IF Is_Routine_Enabled(l_lookup_tbl,'EXPIRE_NON_TRACKABLE_INSTANCE') THEN
16733: Update_Lookup('EXPIRE_NON_TRACKABLE_INSTANCE');
16734: log(date_time_stamp||'expire_non_trackable_instance');
16735: csi_diagnostics_pkg.expire_non_trackable_instance;
16736: commit;
16737: ELSE
16738: log(date_time_stamp||'expire_non_trackable_instance already executed...');
16739: END IF;

Line 16742: csi_diagnostics_pkg.fix_srlsoi_returned_serials;

16738: log(date_time_stamp||'expire_non_trackable_instance already executed...');
16739: END IF;
16740:
16741: log(date_time_stamp||'fix_srlsoi_returned_serials');
16742: csi_diagnostics_pkg.fix_srlsoi_returned_serials;
16743:
16744: log(date_time_stamp||'mark_error_transactions');
16745: csi_diagnostics_pkg.mark_error_transactions;
16746:

Line 16745: csi_diagnostics_pkg.mark_error_transactions;

16741: log(date_time_stamp||'fix_srlsoi_returned_serials');
16742: csi_diagnostics_pkg.fix_srlsoi_returned_serials;
16743:
16744: log(date_time_stamp||'mark_error_transactions');
16745: csi_diagnostics_pkg.mark_error_transactions;
16746:
16747: log(date_time_stamp||'create_or_update_shipping_inst');
16748: csi_diagnostics_pkg.create_or_update_shipping_inst;
16749:

Line 16748: csi_diagnostics_pkg.create_or_update_shipping_inst;

16744: log(date_time_stamp||'mark_error_transactions');
16745: csi_diagnostics_pkg.mark_error_transactions;
16746:
16747: log(date_time_stamp||'create_or_update_shipping_inst');
16748: csi_diagnostics_pkg.create_or_update_shipping_inst;
16749:
16750: l_auto_populate_allowed := FND_PROFILE.VALUE('CSI_AUTO_POPULATE_INSTANCE'); --bug 5248037--
16751: log('Auto population allowed '||l_auto_populate_allowed);
16752:

Line 16756: csi_diagnostics_pkg.create_nsrl_rma_tld;

16752:
16753: --Added IF condition for bug 5248037--
16754: IF UPPER(l_auto_populate_allowed) = 'Y' THEN
16755: log(date_time_stamp||'create_nsrl_rma_tld');
16756: csi_diagnostics_pkg.create_nsrl_rma_tld;
16757: END IF;
16758:
16759: -- serial data spool and preprocess
16760: log(date_time_stamp||'get_srldata');

Line 16761: csi_diagnostics_pkg.get_srldata;

16757: END IF;
16758:
16759: -- serial data spool and preprocess
16760: log(date_time_stamp||'get_srldata');
16761: csi_diagnostics_pkg.get_srldata;
16762:
16763: log(date_time_stamp||'preprocess_srldata');
16764: csi_diagnostics_pkg.preprocess_srldata;
16765:

Line 16764: csi_diagnostics_pkg.preprocess_srldata;

16760: log(date_time_stamp||'get_srldata');
16761: csi_diagnostics_pkg.get_srldata;
16762:
16763: log(date_time_stamp||'preprocess_srldata');
16764: csi_diagnostics_pkg.preprocess_srldata;
16765:
16766: -- fix srl errors
16767: log(date_time_stamp||'fix_srldata');
16768: csi_diagnostics_pkg.fix_srldata;

Line 16768: csi_diagnostics_pkg.fix_srldata;

16764: csi_diagnostics_pkg.preprocess_srldata;
16765:
16766: -- fix srl errors
16767: log(date_time_stamp||'fix_srldata');
16768: csi_diagnostics_pkg.fix_srldata;
16769:
16770: -- serial correction reports
16771: log(date_time_stamp||'spool errors serial Info');
16772: csi_diagnostics_pkg.spool_srldata('ERRORS');

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

16768: csi_diagnostics_pkg.fix_srldata;
16769:
16770: -- serial correction reports
16771: log(date_time_stamp||'spool errors serial Info');
16772: csi_diagnostics_pkg.spool_srldata('ERRORS');
16773:
16774: -- serial correction reports
16775: log(date_time_stamp||'spool all serial info');
16776: csi_diagnostics_pkg.spool_srldata('ALL');

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

16772: csi_diagnostics_pkg.spool_srldata('ERRORS');
16773:
16774: -- serial correction reports
16775: log(date_time_stamp||'spool all serial info');
16776: csi_diagnostics_pkg.spool_srldata('ALL');
16777:
16778: -- spawn the resubmit interface for the marked errors
16779: log(date_time_stamp||'Resubmit errors for the corrected serial numbers');
16780: csi_resubmit_pub.Resubmit_Interface(

Line 16791: csi_diagnostics_pkg.forward_sync;

16787: populate_mtl_txn_creation_date;
16788:
16789: -- forward sync serial routine
16790: log(date_time_stamp||'forward_sync');
16791: csi_diagnostics_pkg.forward_sync;
16792: commit;
16793:
16794: -- Check whether all the instances are forward synched
16795: BEGIN

Line 16833: csi_diagnostics_pkg.sync_inv_serials;

16829: END IF;
16830: --
16831:
16832: log(date_time_stamp||'sync_inv_serials');
16833: csi_diagnostics_pkg.sync_inv_serials;
16834:
16835: log(date_time_stamp||'ib_inv_synch_non_srl');
16836: csi_diagnostics_pkg.ib_inv_synch_non_srl;
16837:

Line 16836: csi_diagnostics_pkg.ib_inv_synch_non_srl;

16832: log(date_time_stamp||'sync_inv_serials');
16833: csi_diagnostics_pkg.sync_inv_serials;
16834:
16835: log(date_time_stamp||'ib_inv_synch_non_srl');
16836: csi_diagnostics_pkg.ib_inv_synch_non_srl;
16837:
16838: log(date_time_stamp||'reverse_ib_inv_synch');
16839: csi_diagnostics_pkg.reverse_ib_inv_synch;
16840:

Line 16839: csi_diagnostics_pkg.reverse_ib_inv_synch;

16835: log(date_time_stamp||'ib_inv_synch_non_srl');
16836: csi_diagnostics_pkg.ib_inv_synch_non_srl;
16837:
16838: log(date_time_stamp||'reverse_ib_inv_synch');
16839: csi_diagnostics_pkg.reverse_ib_inv_synch;
16840:
16841: END IF;
16842:
16843: drop_mmt_trigger;

Line 16969: END csi_diagnostics_pkg;

16965: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
16966: RAISE;
16967: END create_oper_upd_worker;
16968:
16969: END csi_diagnostics_pkg;