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

Line 41: msd_common_utilities.get_db_link(p_instance_id, x_dblink, x_retcode);

37: Begin
38:
39: retcode :=0;
40:
41: msd_common_utilities.get_db_link(p_instance_id, x_dblink, x_retcode);
42: if (x_retcode = -1) and (p_calendar_type_id <> MSD_COMMON_UTILITIES.GREGORIAN_CALENDAR) then
43: retcode :=-1;
44: errbuf := 'Error while getting db_link';
45: return;

Line 42: if (x_retcode = -1) and (p_calendar_type_id <> MSD_COMMON_UTILITIES.GREGORIAN_CALENDAR) then

38:
39: retcode :=0;
40:
41: msd_common_utilities.get_db_link(p_instance_id, x_dblink, x_retcode);
42: if (x_retcode = -1) and (p_calendar_type_id <> MSD_COMMON_UTILITIES.GREGORIAN_CALENDAR) then
43: retcode :=-1;
44: errbuf := 'Error while getting db_link';
45: return;
46: end if;

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

45: return;
46: end if;
47:
48: /* OPM Comment By Rajesh Patangya */
49: msd_common_utilities.get_inst_info(p_instance_id, o_dblink, o_icode,
50: o_apps_ver, o_dgmt, o_instance_type, o_retcode) ;
51: if (o_retcode = -1) and (p_calendar_type_id <> MSD_COMMON_UTILITIES.GREGORIAN_CALENDAR) then
52: retcode :=-1;
53: errbuf := 'Error while getting instance_info';

Line 51: if (o_retcode = -1) and (p_calendar_type_id <> MSD_COMMON_UTILITIES.GREGORIAN_CALENDAR) then

47:
48: /* OPM Comment By Rajesh Patangya */
49: msd_common_utilities.get_inst_info(p_instance_id, o_dblink, o_icode,
50: o_apps_ver, o_dgmt, o_instance_type, o_retcode) ;
51: if (o_retcode = -1) and (p_calendar_type_id <> MSD_COMMON_UTILITIES.GREGORIAN_CALENDAR) then
52: retcode :=-1;
53: errbuf := 'Error while getting instance_info';
54: return;
55: end if;

Line 57: if (p_calendar_type_id = MSD_COMMON_UTILITIES.GREGORIAN_CALENDAR) then

53: errbuf := 'Error while getting instance_info';
54: return;
55: end if;
56:
57: if (p_calendar_type_id = MSD_COMMON_UTILITIES.GREGORIAN_CALENDAR) then
58: x_source_table := null ;
59: calendar_code_and_type := 'DISCRETE' ;
60: elsif (p_calendar_type_id = MSD_COMMON_UTILITIES.MANUFACTURING_CALENDAR) then
61: x_source_table := MSD_COMMON_UTILITIES.MFG_TIME_SOURCE_TABLE || x_dblink ;

Line 60: elsif (p_calendar_type_id = MSD_COMMON_UTILITIES.MANUFACTURING_CALENDAR) then

56:
57: if (p_calendar_type_id = MSD_COMMON_UTILITIES.GREGORIAN_CALENDAR) then
58: x_source_table := null ;
59: calendar_code_and_type := 'DISCRETE' ;
60: elsif (p_calendar_type_id = MSD_COMMON_UTILITIES.MANUFACTURING_CALENDAR) then
61: x_source_table := MSD_COMMON_UTILITIES.MFG_TIME_SOURCE_TABLE || x_dblink ;
62:
63: /* OPM Comment By Rajesh Patangya */
64: o_source_table := MSD_COMMON_UTILITIES.OPM_MFG_TIME_SOURCE_TABLE || x_dblink ;

Line 61: x_source_table := MSD_COMMON_UTILITIES.MFG_TIME_SOURCE_TABLE || x_dblink ;

57: if (p_calendar_type_id = MSD_COMMON_UTILITIES.GREGORIAN_CALENDAR) then
58: x_source_table := null ;
59: calendar_code_and_type := 'DISCRETE' ;
60: elsif (p_calendar_type_id = MSD_COMMON_UTILITIES.MANUFACTURING_CALENDAR) then
61: x_source_table := MSD_COMMON_UTILITIES.MFG_TIME_SOURCE_TABLE || x_dblink ;
62:
63: /* OPM Comment By Rajesh Patangya */
64: o_source_table := MSD_COMMON_UTILITIES.OPM_MFG_TIME_SOURCE_TABLE || x_dblink ;
65: elsif (p_calendar_type_id = MSD_COMMON_UTILITIES.FISCAL_CALENDAR) then

Line 64: o_source_table := MSD_COMMON_UTILITIES.OPM_MFG_TIME_SOURCE_TABLE || x_dblink ;

60: elsif (p_calendar_type_id = MSD_COMMON_UTILITIES.MANUFACTURING_CALENDAR) then
61: x_source_table := MSD_COMMON_UTILITIES.MFG_TIME_SOURCE_TABLE || x_dblink ;
62:
63: /* OPM Comment By Rajesh Patangya */
64: o_source_table := MSD_COMMON_UTILITIES.OPM_MFG_TIME_SOURCE_TABLE || x_dblink ;
65: elsif (p_calendar_type_id = MSD_COMMON_UTILITIES.FISCAL_CALENDAR) then
66: x_source_table := MSD_COMMON_UTILITIES.FISCAL_TIME_SOURCE_TABLE|| x_dblink ;
67: calendar_code_and_type := 'DISCRETE' ;
68: end if ;

Line 65: elsif (p_calendar_type_id = MSD_COMMON_UTILITIES.FISCAL_CALENDAR) then

61: x_source_table := MSD_COMMON_UTILITIES.MFG_TIME_SOURCE_TABLE || x_dblink ;
62:
63: /* OPM Comment By Rajesh Patangya */
64: o_source_table := MSD_COMMON_UTILITIES.OPM_MFG_TIME_SOURCE_TABLE || x_dblink ;
65: elsif (p_calendar_type_id = MSD_COMMON_UTILITIES.FISCAL_CALENDAR) then
66: x_source_table := MSD_COMMON_UTILITIES.FISCAL_TIME_SOURCE_TABLE|| x_dblink ;
67: calendar_code_and_type := 'DISCRETE' ;
68: end if ;
69:

Line 66: x_source_table := MSD_COMMON_UTILITIES.FISCAL_TIME_SOURCE_TABLE|| x_dblink ;

62:
63: /* OPM Comment By Rajesh Patangya */
64: o_source_table := MSD_COMMON_UTILITIES.OPM_MFG_TIME_SOURCE_TABLE || x_dblink ;
65: elsif (p_calendar_type_id = MSD_COMMON_UTILITIES.FISCAL_CALENDAR) then
66: x_source_table := MSD_COMMON_UTILITIES.FISCAL_TIME_SOURCE_TABLE|| x_dblink ;
67: calendar_code_and_type := 'DISCRETE' ;
68: end if ;
69:
70: --dbms_output.put_line(x_source_table) ;

Line 75: x_dest_table := MSD_COMMON_UTILITIES.TIME_FACT_TABLE ;

71:
72: x_direct_load_profile := (fnd_profile.value('MSD_ONE_STEP_COLLECTION')='Y');
73:
74: if (x_direct_load_profile) then
75: x_dest_table := MSD_COMMON_UTILITIES.TIME_FACT_TABLE ;
76: else
77: x_dest_table := MSD_COMMON_UTILITIES.TIME_STAGING_TABLE ;
78: end if;
79:

Line 77: x_dest_table := MSD_COMMON_UTILITIES.TIME_STAGING_TABLE ;

73:
74: if (x_direct_load_profile) then
75: x_dest_table := MSD_COMMON_UTILITIES.TIME_FACT_TABLE ;
76: else
77: x_dest_table := MSD_COMMON_UTILITIES.TIME_STAGING_TABLE ;
78: end if;
79:
80: --dbms_output.put_line(x_dest_table) ;
81: --dbms_output.put_line(p_from_date) ;

Line 87: if (p_calendar_type_id = MSD_COMMON_UTILITIES.GREGORIAN_CALENDAR) then

83:
84: x_from_date := FND_DATE.canonical_to_date(p_from_date);
85: x_to_date := FND_DATE.canonical_to_date(p_to_date);
86:
87: if (p_calendar_type_id = MSD_COMMON_UTILITIES.GREGORIAN_CALENDAR) then
88: if (p_from_date is null) then
89: x_from_date := to_date('01/01/1980','DD/MM/RRRR');
90: end if;
91: if (p_to_date is null) then

Line 104: if ( (p_calendar_type_id = MSD_COMMON_UTILITIES.MANUFACTURING_CALENDAR) or

100:
101: --dbms_output.put_line(x_from_date) ;
102: --dbms_output.put_line(x_to_date) ;
103:
104: if ( (p_calendar_type_id = MSD_COMMON_UTILITIES.MANUFACTURING_CALENDAR) or
105: (p_calendar_type_id = MSD_COMMON_UTILITIES.FISCAL_CALENDAR)) then
106:
107: /* Bug# 4620927 */
108: -- if o_instance_type = 1 Then /* DIS instance */

Line 105: (p_calendar_type_id = MSD_COMMON_UTILITIES.FISCAL_CALENDAR)) then

101: --dbms_output.put_line(x_from_date) ;
102: --dbms_output.put_line(x_to_date) ;
103:
104: if ( (p_calendar_type_id = MSD_COMMON_UTILITIES.MANUFACTURING_CALENDAR) or
105: (p_calendar_type_id = MSD_COMMON_UTILITIES.FISCAL_CALENDAR)) then
106:
107: /* Bug# 4620927 */
108: -- if o_instance_type = 1 Then /* DIS instance */
109: if o_instance_type = 1 OR o_apps_ver >= 4 Then /* DIS 11i instance OR R12 instance of any type */

Line 127: if p_calendar_type_id = MSD_COMMON_UTILITIES.FISCAL_CALENDAR then

123:
124: calendar_code_and_type := 'DISCRETE' ;
125:
126: elsif o_apps_ver = 3 AND o_instance_type = 2 then /* OPM instance */
127: if p_calendar_type_id = MSD_COMMON_UTILITIES.FISCAL_CALENDAR then
128: -- sudesh Bug # 3899742
129: begin
130:
131: x_sql_stmt := 'select 1 from dual where exists( select null from '||x_source_table||' where calendar_code = nvl(:p_calendar_code, calendar_code)) ';

Line 181: if ((l_calendar_count = 0) AND (p_calendar_type_id = MSD_COMMON_UTILITIES.MANUFACTURING_CALENDAR)) then

177:
178: calendar_code_and_type := 'DISCRETE' ;
179:
180:
181: if ((l_calendar_count = 0) AND (p_calendar_type_id = MSD_COMMON_UTILITIES.MANUFACTURING_CALENDAR)) then
182: x_sql_stmt := NULL ;
183:
184: -- sudesh Bug # 3899742
185: begin