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.MSD_COLLECT_LEVEL_VALUES dependencies on MSD_COMMON_UTILITIES

Line 71: IF ( nvl(p_collection_type, MSD_COMMON_UTILITIES.COLLECT_ALL) =

67: return;
68: END IF;
69:
70:
71: IF ( nvl(p_collection_type, MSD_COMMON_UTILITIES.COLLECT_ALL) =
72: MSD_COMMON_UTILITIES.COLLECT_ALL ) then
73:
74: collect_all_data(
75: errbuf => errbuf,

Line 72: MSD_COMMON_UTILITIES.COLLECT_ALL ) then

68: END IF;
69:
70:
71: IF ( nvl(p_collection_type, MSD_COMMON_UTILITIES.COLLECT_ALL) =
72: MSD_COMMON_UTILITIES.COLLECT_ALL ) then
73:
74: collect_all_data(
75: errbuf => errbuf,
76: retcode => retcode,

Line 79: ELSIF ( p_collection_type = MSD_COMMON_UTILITIES.COLLECT_DP ) then

75: errbuf => errbuf,
76: retcode => retcode,
77: p_instance_id => p_instance_id);
78:
79: ELSIF ( p_collection_type = MSD_COMMON_UTILITIES.COLLECT_DP ) then
80:
81: collect_demand_plan_data(
82: errbuf => errbuf,
83: retcode => retcode,

Line 88: elsif ( p_collection_type = MSD_COMMON_UTILITIES.COLLECT_DIMENSION ) then

84: p_instance_id => p_instance_id,
85: p_demand_plan_id => to_number(p_collection_var) );
86:
87:
88: elsif ( p_collection_type = MSD_COMMON_UTILITIES.COLLECT_DIMENSION ) then
89:
90: collect_dimension_data(
91: errbuf => errbuf,
92: retcode => retcode,

Line 97: elsif ( p_collection_type = MSD_COMMON_UTILITIES.COLLECT_HIERARCHY ) then

93: p_instance_id => p_instance_id,
94: p_dimension_code => p_collection_var);
95:
96:
97: elsif ( p_collection_type = MSD_COMMON_UTILITIES.COLLECT_HIERARCHY ) then
98:
99: collect_hierarchy_data(
100: errbuf => errbuf,
101: retcode => retcode,

Line 105: elsif ( p_collection_type = MSD_COMMON_UTILITIES.COLLECT_LEVEL ) then

101: retcode => retcode,
102: p_instance_id => p_instance_id,
103: p_hierarchy_id => to_number(p_collection_var) );
104:
105: elsif ( p_collection_type = MSD_COMMON_UTILITIES.COLLECT_LEVEL ) then
106:
107: collect_level_data(
108: errbuf => errbuf,
109: retcode => retcode,

Line 118: Delete_duplicate(p_instance_id, MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE);

114:
115:
116:
117: /* Added logic to delete duplicate data */
118: Delete_duplicate(p_instance_id, MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE);
119:
120: /* Delete duplicate level association from staging table */
121: Delete_duplicate_lvl_assoc(errbuf, retcode, p_instance_id);
122:

Line 150: MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE);

146:
147: WHEN others THEN
148: BEGIN
149: Delete_duplicate(p_instance_id ,
150: MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE);
151: Delete_duplicate_lvl_assoc(errbuf, retcode, p_instance_id);
152: COMMIT;
153: EXCEPTION
154: WHEN others THEN

Line 242: msd_common_utilities.get_db_link(p_instance_id, x_dblink, retcode);

238:
239: retcode :=0;
240:
241:
242: msd_common_utilities.get_db_link(p_instance_id, x_dblink, retcode);
243: if (retcode = -1) then
244: retcode :=-1;
245: errbuf := 'Error while getting db_link';
246: --dbms_output.put_line('Error while getting db_link');

Line 252: msd_common_utilities.get_inst_info(p_instance_id, o_dblink, o_icode,

248: end if;
249:
250:
251: /* OPM Comment By Rajesh Patangya */
252: msd_common_utilities.get_inst_info(p_instance_id, o_dblink, o_icode,
253: o_apps_ver, o_dgmt, o_instance_type, o_retcode) ;
254: if (o_retcode = -1) then
255: retcode :=-1;
256: errbuf := 'Error while getting instance_info';

Line 262: x_dest_table := MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE ;

258: end if;
259:
260:
261: /* DWK Always 2 step collection */
262: x_dest_table := MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE ;
263: v_dest_ass_table := MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE;
264:
265:
266: /* DWK Relationship LOOP */

Line 263: v_dest_ass_table := MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE;

259:
260:
261: /* DWK Always 2 step collection */
262: x_dest_table := MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE ;
263: v_dest_ass_table := MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE;
264:
265:
266: /* DWK Relationship LOOP */
267: For Relationship_Rec IN Relationship(p_level_id, p_parent_level_id) LOOP

Line 283: p_level_name := MSD_COMMON_UTILITIES.get_level_name(p_level_id);

279: FROM msd_hierarchies
280: WHERE hierarchy_id = Relationship_Rec.hierarchy_id
281: AND plan_type is null; --vinekuma
282:
283: p_level_name := MSD_COMMON_UTILITIES.get_level_name(p_level_id);
284: p_parent_level_name := MSD_COMMON_UTILITIES.get_level_name(p_parent_level_id);
285:
286: fnd_file.put_line(fnd_file.log, ' ');
287: fnd_file.put_line(fnd_file.log, 'Relationship view is not defined for ' ||

Line 284: p_parent_level_name := MSD_COMMON_UTILITIES.get_level_name(p_parent_level_id);

280: WHERE hierarchy_id = Relationship_Rec.hierarchy_id
281: AND plan_type is null; --vinekuma
282:
283: p_level_name := MSD_COMMON_UTILITIES.get_level_name(p_level_id);
284: p_parent_level_name := MSD_COMMON_UTILITIES.get_level_name(p_parent_level_id);
285:
286: fnd_file.put_line(fnd_file.log, ' ');
287: fnd_file.put_line(fnd_file.log, 'Relationship view is not defined for ' ||
288: 'Hierarchy : '|| p_hierarchy_name || '. (No Data Collected.)');

Line 299: msd_common_utilities.get_dimension_code (p_level_id,

295: x_source_table := Relationship_Rec.relationship_view || x_dblink ;
296:
297: /* OPM Comment Rajesh Patangya */
298: IF (o_instance_type in (2,4) AND o_apps_ver = 3) THEN
299: msd_common_utilities.get_dimension_code (p_level_id,
300: o_dimension_code,
301: o_retcode );
302: IF (o_retcode = -1) THEN
303: log_debug('Error Condition : Error while getting dimension Code');

Line 445: MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE,

441: end loop;
442:
443: /* zia bug #1610855: Fix parentless children */
444: fix_orphans(p_instance_id, p_level_id,
445: MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE,
446: MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE,
447: null);
448:
449: /* Bug# 5530511 - Delete_Childless_Parent_All should be called after

Line 446: MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE,

442:
443: /* zia bug #1610855: Fix parentless children */
444: fix_orphans(p_instance_id, p_level_id,
445: MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE,
446: MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE,
447: null);
448:
449: /* Bug# 5530511 - Delete_Childless_Parent_All should be called after
450: * the call to fix_orphans

Line 541: MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE,

537:
538: For Level_Rec IN Level_Cursor (p_hierarchy_id) LOOP
539: /* zia bug #1610855: Fix parentless children */
540: fix_orphans(p_instance_id, Level_Rec.level_id,
541: MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE,
542: MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE,
543: p_hierarchy_id);
544: end loop;
545:

Line 542: MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE,

538: For Level_Rec IN Level_Cursor (p_hierarchy_id) LOOP
539: /* zia bug #1610855: Fix parentless children */
540: fix_orphans(p_instance_id, Level_Rec.level_id,
541: MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE,
542: MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE,
543: p_hierarchy_id);
544: end loop;
545:
546: /* Bug# 5530511 - Delete_Childless_Parent_All should be called after

Line 637: MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE,

633: For Level_Rec IN Level_Cursor(p_dimension_code) LOOP
634:
635: /* zia bug #1610855: Fix parentless children */
636: fix_orphans(p_instance_id, Level_Rec.level_id,
637: MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE,
638: MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE,
639: null);
640: end loop;
641:

Line 638: MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE,

634:
635: /* zia bug #1610855: Fix parentless children */
636: fix_orphans(p_instance_id, Level_Rec.level_id,
637: MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE,
638: MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE,
639: null);
640: end loop;
641:
642: /* Bug# 5530511 - Delete_Childless_Parent_All should be called after

Line 875: return MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE ;

871: BEGIN
872: x_direct_load_profile := (fnd_profile.value('MSD_ONE_STEP_COLLECTION')='Y');
873:
874: if (x_direct_load_profile) then
875: return MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE ;
876: else
877: return MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE ;
878: end if;
879: END get_dest_table;

Line 877: return MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE ;

873:
874: if (x_direct_load_profile) then
875: return MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE ;
876: else
877: return MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE ;
878: end if;
879: END get_dest_table;
880:
881:

Line 888: return MSD_COMMON_UTILITIES.LEVEL_ASSOC_FACT_TABLE ;

884: BEGIN
885: x_direct_load_profile := (fnd_profile.value('MSD_ONE_STEP_COLLECTION')='Y');
886:
887: if (x_direct_load_profile) then
888: return MSD_COMMON_UTILITIES.LEVEL_ASSOC_FACT_TABLE ;
889: else
890: return MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE;
891: end if;
892: END get_assoc_table;

Line 890: return MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE;

886:
887: if (x_direct_load_profile) then
888: return MSD_COMMON_UTILITIES.LEVEL_ASSOC_FACT_TABLE ;
889: else
890: return MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE;
891: end if;
892: END get_assoc_table;
893:
894:

Line 985: if p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE then

981: /* This procedure deletes duplicate records from staging level_values
982: Key - Instance + Level_Id + SR_LEVEL_PK
983: */
984:
985: if p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE then
986: delete from msd_st_level_values a where
987: a.instance = p_instance_id and
988: rowid <> (select max(rowid) from msd_st_level_values b
989: where a.instance = b.instance

Line 1091: l_dest_table := MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE;

1087: /* 1 step collection */
1088: /* Bug# 4919130 - Always delete childless parents from staging table.
1089: IF (fnd_profile.value('MSD_ONE_STEP_COLLECTION') = 'Y') THEN
1090:
1091: l_dest_table := MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE;
1092:
1093: FOR Level_Rec IN c_level LOOP
1094: Delete_Childless_Parent ( errbuf,
1095: retcode,

Line 1104: l_dest_table := MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE ;

1100: */
1101: /* 2 step collection */
1102: /* Bug# 4919130 - Always delete childless parents from staging table.
1103: ELSE
1104: l_dest_table := MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE ;
1105: */
1106:
1107: FOR Level_Rec IN c_st_level LOOP
1108: Delete_Childless_Parent ( errbuf,

Line 1159: IF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) THEN

1155: where instance = '-999' and level_pk = -999;
1156:
1157: /* For 2 step collection */
1158: /* Bug# 4919130 - Always delete childless parents from staging table.
1159: IF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) THEN
1160: */
1161:
1162: insert into msd_backup_level_values (instance , level_id, sr_level_pk, level_pk )
1163: select '-999' , level_id, sr_level_pk, -999

Line 1181: ELSIF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE) THEN

1177: b.sr_level_pk = a.sr_level_pk and level_pk = -999);
1178:
1179: /* For 1 step collection */
1180: /* Bug# 4919130 - Always delete childless parents from staging table.
1181: ELSIF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE) THEN
1182:
1183: insert into msd_backup_level_values (instance , level_id, sr_level_pk, level_pk )
1184: select '-999' , level_id, sr_level_pk, -999
1185: from msd_level_values