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 70: MSD_COMMON_UTILITIES.COLLECT_ILP := 2;

66: p_instance_id);
67: IF (nvl(retcode, 0) <> 0) THEN
68: return;
69: END IF;
70: MSD_COMMON_UTILITIES.COLLECT_ILP := 2;
71:
72: IF ( nvl(p_collection_type, MSD_COMMON_UTILITIES.COLLECT_ALL) =
73: MSD_COMMON_UTILITIES.COLLECT_ALL ) then
74:

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

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

Line 73: MSD_COMMON_UTILITIES.COLLECT_ALL ) then

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

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

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

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

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

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

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

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

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

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

115:
116:
117:
118: /* Added logic to delete duplicate data */
119: Delete_duplicate(p_instance_id, MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE);
120:
121: if retcode <> '0' then
122: g_retcode := retcode;
123: end if;

Line 150: MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE);

146: if retcode = '-1' then
147:
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 178: MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE);

174:
175: WHEN others THEN
176: BEGIN
177: Delete_duplicate(p_instance_id ,
178: MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE);
179: Delete_duplicate_lvl_assoc(errbuf, retcode, p_instance_id);
180: COMMIT;
181: EXCEPTION
182: WHEN others THEN

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

275:
276: retcode :=0;
277:
278:
279: msd_common_utilities.get_db_link(p_instance_id, x_dblink, retcode);
280: if (retcode = -1) then
281: retcode :=-1;
282: errbuf := 'Error while getting db_link';
283: --dbms_output.put_line('Error while getting db_link');

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

285: end if;
286:
287:
288: /* OPM Comment By Rajesh Patangya */
289: msd_common_utilities.get_inst_info(p_instance_id, o_dblink, o_icode,
290: o_apps_ver, o_dgmt, o_instance_type, o_retcode) ;
291: if (o_retcode = -1) then
292: retcode :=-1;
293: errbuf := 'Error while getting instance_info';

Line 299: x_dest_table := MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE ;

295: end if;
296:
297:
298: /* DWK Always 2 step collection */
299: x_dest_table := MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE ;
300: v_dest_ass_table := MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE;
301:
302:
303: /* DWK Relationship LOOP */

Line 300: v_dest_ass_table := MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE;

296:
297:
298: /* DWK Always 2 step collection */
299: x_dest_table := MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE ;
300: v_dest_ass_table := MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE;
301:
302:
303: /* DWK Relationship LOOP */
304: For Relationship_Rec IN Relationship(p_level_id, p_parent_level_id) LOOP

Line 313: msd_common_utilities.get_dimension_code (p_level_id,

309: x_source_table := Relationship_Rec.relationship_view || x_dblink ;
310:
311: /* OPM Comment Rajesh Patangya */
312: IF (o_instance_type in (2,4) AND o_apps_ver = 3) THEN
313: msd_common_utilities.get_dimension_code (p_level_id,
314: o_dimension_code,
315: o_retcode );
316: IF (o_retcode = -1) THEN
317: log_debug('Error Condition : Error while getting dimension Code');

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

402: select hierarchy_name INTO p_hierarchy_name
403: FROM msd_hierarchies
404: WHERE hierarchy_id = Null_Relationship_Rec.hierarchy_id;
405:
406: p_level_name := MSD_COMMON_UTILITIES.get_level_name(p_level_id);
407: p_parent_level_name := MSD_COMMON_UTILITIES.get_level_name(p_parent_level_id);
408:
409: fnd_file.put_line(fnd_file.log, ' ');
410: fnd_file.put_line(fnd_file.log, 'Relationship view is not defined for ' ||

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

403: FROM msd_hierarchies
404: WHERE hierarchy_id = Null_Relationship_Rec.hierarchy_id;
405:
406: p_level_name := MSD_COMMON_UTILITIES.get_level_name(p_level_id);
407: p_parent_level_name := MSD_COMMON_UTILITIES.get_level_name(p_parent_level_id);
408:
409: fnd_file.put_line(fnd_file.log, ' ');
410: fnd_file.put_line(fnd_file.log, 'Relationship view is not defined for ' ||
411: 'Hierarchy : '|| p_hierarchy_name || '. (No Data Collected.)');

Line 476: MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE,

472: end loop;
473:
474: /* zia bug #1610855: Fix parentless children */
475: fix_orphans(p_instance_id, p_level_id,
476: MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE,
477: MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE,
478: null);
479:
480: /* Bug# 5530511 - Delete_Childless_Parent_All should be called after

Line 477: MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE,

473:
474: /* zia bug #1610855: Fix parentless children */
475: fix_orphans(p_instance_id, p_level_id,
476: MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE,
477: MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE,
478: null);
479:
480: /* Bug# 5530511 - Delete_Childless_Parent_All should be called after
481: * the call to fix_orphans

Line 581: MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE,

577:
578: For Level_Rec IN Level_Cursor (p_hierarchy_id) LOOP
579: /* zia bug #1610855: Fix parentless children */
580: fix_orphans(p_instance_id, Level_Rec.level_id,
581: MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE,
582: MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE,
583: p_hierarchy_id);
584: end loop;
585:

Line 582: MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE,

578: For Level_Rec IN Level_Cursor (p_hierarchy_id) LOOP
579: /* zia bug #1610855: Fix parentless children */
580: fix_orphans(p_instance_id, Level_Rec.level_id,
581: MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE,
582: MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE,
583: p_hierarchy_id);
584: end loop;
585:
586: /* Bug# 5530511 - Delete_Childless_Parent_All should be called after

Line 657: MSD_COMMON_UTILITIES.COLLECT_ILP := 0;

653: For Dim_Level_Parent_Rec IN Dim_Level_Parent (p_dimension_code) LOOP
654:
655: if (p_dimension_code = 'PRD' and pop_lev <> Dim_Level_Parent_Rec.level_id) then
656:
657: MSD_COMMON_UTILITIES.COLLECT_ILP := 0;
658:
659: open Pop_Item_List_Price(p_dimension_code, Dim_Level_Parent_Rec.level_id);
660: fetch Pop_Item_List_Price into count_lev;
661: close Pop_Item_List_Price;

Line 672: MSD_COMMON_UTILITIES.COLLECT_ILP := 1;

668: count_lev := count_lev - 1;
669:
670: if (count_lev = 0) then
671:
672: MSD_COMMON_UTILITIES.COLLECT_ILP := 1;
673:
674: end if;
675:
676: if(count_store = 1) then

Line 678: MSD_COMMON_UTILITIES.COLLECT_ILP := 2;

674: end if;
675:
676: if(count_store = 1) then
677:
678: MSD_COMMON_UTILITIES.COLLECT_ILP := 2;
679:
680: end if;
681:
682:

Line 714: MSD_COMMON_UTILITIES.COLLECT_ILP := 0;

710: end if;
711:
712: end loop ;
713:
714: MSD_COMMON_UTILITIES.COLLECT_ILP := 0;
715:
716: For Level_Rec IN Level_Cursor(p_dimension_code) LOOP
717:
718: /* zia bug #1610855: Fix parentless children */

Line 720: MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE,

716: For Level_Rec IN Level_Cursor(p_dimension_code) LOOP
717:
718: /* zia bug #1610855: Fix parentless children */
719: fix_orphans(p_instance_id, Level_Rec.level_id,
720: MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE,
721: MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE,
722: null);
723: end loop;
724:

Line 721: MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE,

717:
718: /* zia bug #1610855: Fix parentless children */
719: fix_orphans(p_instance_id, Level_Rec.level_id,
720: MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE,
721: MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE,
722: null);
723: end loop;
724:
725: /* Bug# 5530511 - Delete_Childless_Parent_All should be called after

Line 958: return MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE ;

954: BEGIN
955: x_direct_load_profile := (fnd_profile.value('MSD_ONE_STEP_COLLECTION')='Y');
956:
957: if (x_direct_load_profile) then
958: return MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE ;
959: else
960: return MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE ;
961: end if;
962: END get_dest_table;

Line 960: return MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE ;

956:
957: if (x_direct_load_profile) then
958: return MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE ;
959: else
960: return MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE ;
961: end if;
962: END get_dest_table;
963:
964:

Line 971: return MSD_COMMON_UTILITIES.LEVEL_ASSOC_FACT_TABLE ;

967: BEGIN
968: x_direct_load_profile := (fnd_profile.value('MSD_ONE_STEP_COLLECTION')='Y');
969:
970: if (x_direct_load_profile) then
971: return MSD_COMMON_UTILITIES.LEVEL_ASSOC_FACT_TABLE ;
972: else
973: return MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE;
974: end if;
975: END get_assoc_table;

Line 973: return MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE;

969:
970: if (x_direct_load_profile) then
971: return MSD_COMMON_UTILITIES.LEVEL_ASSOC_FACT_TABLE ;
972: else
973: return MSD_COMMON_UTILITIES.LEVEL_ASSOC_STAGING_TABLE;
974: end if;
975: END get_assoc_table;
976:
977:

Line 1068: if p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE then

1064: /* This procedure deletes duplicate records from staging level_values
1065: Key - Instance + Level_Id + SR_LEVEL_PK
1066: */
1067:
1068: if p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE then
1069: delete from msd_st_level_values a where
1070: a.instance = p_instance_id and
1071: rowid <> (select max(rowid) from msd_st_level_values b
1072: where a.instance = b.instance

Line 1174: l_dest_table := MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE;

1170: /* 1 step collection */
1171: /* Bug# 4919130 - Always delete childless parents from staging table.
1172: IF (fnd_profile.value('MSD_ONE_STEP_COLLECTION') = 'Y') THEN
1173:
1174: l_dest_table := MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE;
1175:
1176: FOR Level_Rec IN c_level LOOP
1177: Delete_Childless_Parent ( errbuf,
1178: retcode,

Line 1187: l_dest_table := MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE ;

1183: */
1184: /* 2 step collection */
1185: /* Bug# 4919130 - Always delete childless parents from staging table.
1186: ELSE
1187: l_dest_table := MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE ;
1188: */
1189:
1190: FOR Level_Rec IN c_st_level LOOP
1191: Delete_Childless_Parent ( errbuf,

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

1238: where instance = '-999' and level_pk = -999;
1239:
1240: /* For 2 step collection */
1241: /* Bug# 4919130 - Always delete childless parents from staging table.
1242: IF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) THEN
1243: */
1244:
1245: insert into msd_backup_level_values (instance , level_id, sr_level_pk, level_pk )
1246: select '-999' , level_id, sr_level_pk, -999

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

1268: st_b.sr_level_pk = st_a.sr_level_pk and level_pk = -999);
1269:
1270: /* For 1 step collection */
1271: /* Bug# 4919130 - Always delete childless parents from staging table.
1272: ELSIF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE) THEN
1273:
1274: insert into msd_backup_level_values (instance , level_id, sr_level_pk, level_pk )
1275: select '-999' , level_id, sr_level_pk, -999
1276: from msd_level_values