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_TRANSLATE_TIME_DATA dependencies on MSD_COMMON_UTILITIES

Line 70: IF (p_calendar_type_id <> MSD_COMMON_UTILITIES.GREGORIAN_CALENDAR ) THEN

66: retcode :=0;
67: Savepoint Before_Delete ;
68:
69:
70: IF (p_calendar_type_id <> MSD_COMMON_UTILITIES.GREGORIAN_CALENDAR ) THEN
71: msd_common_utilities.get_db_link(p_instance_id, x_dblink, retcode);
72: if (retcode = -1) then
73: retcode :=-1;
74: return;

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

67: Savepoint Before_Delete ;
68:
69:
70: IF (p_calendar_type_id <> MSD_COMMON_UTILITIES.GREGORIAN_CALENDAR ) THEN
71: msd_common_utilities.get_db_link(p_instance_id, x_dblink, retcode);
72: if (retcode = -1) then
73: retcode :=-1;
74: return;
75: end if;

Line 80: IF (p_calendar_type_id = MSD_COMMON_UTILITIES.GREGORIAN_CALENDAR ) THEN

76: END IF;
77:
78:
79: /* TEST DWK */
80: IF (p_calendar_type_id = MSD_COMMON_UTILITIES.GREGORIAN_CALENDAR ) THEN
81: l_calendar_code := 'GREGORIAN';
82: ELSE
83: l_calendar_code := p_calendar_code;
84: END IF;

Line 104: IF (p_calendar_type_id = MSD_COMMON_UTILITIES.GREGORIAN_CALENDAR ) then

100:
101: /* You need to generate all the Gregorian Hierarchy for this
102: Date range mentioned below */
103: /* DWK outer IF 1 */
104: IF (p_calendar_type_id = MSD_COMMON_UTILITIES.GREGORIAN_CALENDAR ) then
105:
106: Generate_Gregorian( errbuf,
107: retcode,
108: l_calendar_code,

Line 114: ELSIF (p_calendar_type_id = MSD_COMMON_UTILITIES.MANUFACTURING_CALENDAR) or

110: p_to_date ) ;
111:
112: /* In this section the Hierarchy is already exploded to the Day Level */
113: /* ELSIF for outer IF 1 */
114: ELSIF (p_calendar_type_id = MSD_COMMON_UTILITIES.MANUFACTURING_CALENDAR) or
115: ( ( (p_calendar_type_id = MSD_COMMON_UTILITIES.FISCAL_CALENDAR)
116: or
117: (p_calendar_type_id = MSD_COMMON_UTILITIES.COMPOSITE_CALENDAR)
118:

Line 115: ( ( (p_calendar_type_id = MSD_COMMON_UTILITIES.FISCAL_CALENDAR)

111:
112: /* In this section the Hierarchy is already exploded to the Day Level */
113: /* ELSIF for outer IF 1 */
114: ELSIF (p_calendar_type_id = MSD_COMMON_UTILITIES.MANUFACTURING_CALENDAR) or
115: ( ( (p_calendar_type_id = MSD_COMMON_UTILITIES.FISCAL_CALENDAR)
116: or
117: (p_calendar_type_id = MSD_COMMON_UTILITIES.COMPOSITE_CALENDAR)
118:
119: )

Line 117: (p_calendar_type_id = MSD_COMMON_UTILITIES.COMPOSITE_CALENDAR)

113: /* ELSIF for outer IF 1 */
114: ELSIF (p_calendar_type_id = MSD_COMMON_UTILITIES.MANUFACTURING_CALENDAR) or
115: ( ( (p_calendar_type_id = MSD_COMMON_UTILITIES.FISCAL_CALENDAR)
116: or
117: (p_calendar_type_id = MSD_COMMON_UTILITIES.COMPOSITE_CALENDAR)
118:
119: )
120: and
121: (p_source_table = MSD_COMMON_UTILITIES.TIME_STAGING_TABLE) ) then

Line 121: (p_source_table = MSD_COMMON_UTILITIES.TIME_STAGING_TABLE) ) then

117: (p_calendar_type_id = MSD_COMMON_UTILITIES.COMPOSITE_CALENDAR)
118:
119: )
120: and
121: (p_source_table = MSD_COMMON_UTILITIES.TIME_STAGING_TABLE) ) then
122:
123: v_sql_stmt := 'insert into ' || p_dest_table || ' ( ' ||
124: 'instance, ' ||
125: 'calendar_type, ' ||

Line 185: if (p_source_table = MSD_COMMON_UTILITIES.TIME_STAGING_TABLE) then

181: ' where calendar_code = NVL(:l_calendar_code, calendar_code)' ;
182:
183: -- If it is from the staging area then we need to add the
184: -- filter for unique instance id
185: if (p_source_table = MSD_COMMON_UTILITIES.TIME_STAGING_TABLE) then
186: v_sql_stmt := v_sql_stmt || ' and instance = :p_instance_id ';
187: end if ;
188:
189: if ((p_calendar_type_id = MSD_COMMON_UTILITIES.MANUFACTURING_CALENDAR)

Line 189: if ((p_calendar_type_id = MSD_COMMON_UTILITIES.MANUFACTURING_CALENDAR)

185: if (p_source_table = MSD_COMMON_UTILITIES.TIME_STAGING_TABLE) then
186: v_sql_stmt := v_sql_stmt || ' and instance = :p_instance_id ';
187: end if ;
188:
189: if ((p_calendar_type_id = MSD_COMMON_UTILITIES.MANUFACTURING_CALENDAR)
190: and
191: (p_source_table <> MSD_COMMON_UTILITIES.TIME_STAGING_TABLE)
192: and (l_calendar_code is null)) then
193: v_sql_stmt := v_sql_stmt || ' and calendar_code in (SELECT distinct mod.calendar_code FROM msd_organization_definitions';

Line 191: (p_source_table <> MSD_COMMON_UTILITIES.TIME_STAGING_TABLE)

187: end if ;
188:
189: if ((p_calendar_type_id = MSD_COMMON_UTILITIES.MANUFACTURING_CALENDAR)
190: and
191: (p_source_table <> MSD_COMMON_UTILITIES.TIME_STAGING_TABLE)
192: and (l_calendar_code is null)) then
193: v_sql_stmt := v_sql_stmt || ' and calendar_code in (SELECT distinct mod.calendar_code FROM msd_organization_definitions';
194: v_sql_stmt := v_sql_stmt || x_dblink || ' mod' || ', msd_app_instance_orgs' || x_dblink || ' maio' || ' WHERE mod.organization_id = maio.organization_id) ';
195: end if;

Line 202: if (p_source_table = MSD_COMMON_UTILITIES.TIME_STAGING_TABLE) then

198: /* DWK Populate dates which falls within day range */
199: v_sql_stmt := v_sql_stmt || v_day_range_stmt;
200:
201:
202: if (p_source_table = MSD_COMMON_UTILITIES.TIME_STAGING_TABLE) then
203: EXECUTE IMMEDIATE v_sql_stmt
204: using l_calendar_code,
205: p_instance_id,
206: nvl(p_from_date, to_date('01-01-0001', 'DD-MM-RRRR')),

Line 292: if (p_calendar_type_id = MSD_COMMON_UTILITIES.MANUFACTURING_CALENDAR) and

288:
289: END IF; /* End of outer IF 1 */
290:
291: -- fill in missing dates for manufacturing calendar on the fact
292: if (p_calendar_type_id = MSD_COMMON_UTILITIES.MANUFACTURING_CALENDAR) and
293: (p_dest_table = MSD_COMMON_UTILITIES.TIME_FACT_TABLE) then
294: fix_manufacturing(errbuf, retcode, p_calendar_code);
295: end if;
296:

Line 293: (p_dest_table = MSD_COMMON_UTILITIES.TIME_FACT_TABLE) then

289: END IF; /* End of outer IF 1 */
290:
291: -- fill in missing dates for manufacturing calendar on the fact
292: if (p_calendar_type_id = MSD_COMMON_UTILITIES.MANUFACTURING_CALENDAR) and
293: (p_dest_table = MSD_COMMON_UTILITIES.TIME_FACT_TABLE) then
294: fix_manufacturing(errbuf, retcode, p_calendar_code);
295: end if;
296:
297: COMMIT;

Line 346: if (p_dest_table = MSD_COMMON_UTILITIES.TIME_FACT_TABLE) then

342: Begin
343:
344: x_count := p_month_end_date - p_month_start_date ;
345:
346: if (p_dest_table = MSD_COMMON_UTILITIES.TIME_FACT_TABLE) then
347:
348: For v_num_of_days in 0..(p_month_end_date - p_month_start_date) LOOP
349:
350: g_seq_num := g_seq_num + 1 ;

Line 405: elsif (p_dest_table = MSD_COMMON_UTILITIES.TIME_STAGING_TABLE) then

401:
402:
403: End Loop ;
404:
405: elsif (p_dest_table = MSD_COMMON_UTILITIES.TIME_STAGING_TABLE) then
406:
407: For v_num_of_days in 0..(p_month_end_date - p_month_start_date) LOOP
408:
409: g_seq_num := g_seq_num + 1 ;