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_CS_COLLECTION dependencies on MSD_CS_DEFINITIONS

Line 41: p_cs_rec in out NOCOPY msd_cs_definitions_v1%rowtype,

37: p_cs_name in varchar2,
38: p_instance_id in number,
39: p_refresh_num in number);
40: Procedure Process_1_Sub (
41: p_cs_rec in out NOCOPY msd_cs_definitions_v1%rowtype,
42: p_cs_name in varchar2,
43: p_source_view in varchar2,
44: p_target_table in varchar2,
45: p_instance_id in number,

Line 86: p_cs_rec in msd_cs_definitions_v1%rowtype,

82: p_request_id in number) return varchar2;
83:
84: Procedure log_processed (
85: crec_data in msd_cs_dfn_utl.g_typ_source_stream,
86: p_cs_rec in msd_cs_definitions_v1%rowtype,
87: p_cs_name in varchar2,
88: p_instance_id in varchar2,
89: p_source_view in varchar2,
90: p_target_table in varchar2);

Line 94: p_cs_rec in msd_cs_definitions_v1%rowtype,

90: p_target_table in varchar2);
91:
92: Procedure log_error (
93: crec_data in msd_cs_dfn_utl.g_typ_source_stream,
94: p_cs_rec in msd_cs_definitions_v1%rowtype,
95: p_cs_name in varchar2,
96: p_instance_id in varchar2,
97: p_error_message in varchar2,
98: p_source_view in varchar2,

Line 112: p_cs_rec in msd_cs_definitions_v1%rowtype,

108: p_new_refresh_num in NUMBER);
109:
110: Procedure ins_row_fact(
111: crec_data in msd_cs_dfn_utl.g_typ_source_stream,
112: p_cs_rec in msd_cs_definitions_v1%rowtype,
113: p_cs_name in varchar2,
114: p_instance_id in varchar2,
115: p_new_refresh_num IN NUMBER);
116:

Line 119: p_cs_rec in msd_cs_definitions_v1%rowtype,

115: p_new_refresh_num IN NUMBER);
116:
117: Procedure ins_row_staging (
118: crec_data in msd_cs_dfn_utl.g_typ_source_stream,
119: p_cs_rec in msd_cs_definitions_v1%rowtype,
120: p_cs_name in varchar2,
121: p_instance_id in varchar2,
122: p_process_status in varchar2,
123: p_error_message in varchar2);

Line 127: p_cs_Rec in msd_cs_definitions_v1%rowtype,

123: p_error_message in varchar2);
124:
125:
126: Procedure cs_collect_post_process (
127: p_cs_Rec in msd_cs_definitions_v1%rowtype,
128: p_cs_name in varchar2,
129: p_instance_id in varchar2 );
130:
131: Procedure Process_1 (

Line 132: p_cs_rec in out NOCOPY msd_cs_definitions_v1%rowtype,

128: p_cs_name in varchar2,
129: p_instance_id in varchar2 );
130:
131: Procedure Process_1 (
132: p_cs_rec in out NOCOPY msd_cs_definitions_v1%rowtype,
133: p_cs_name in varchar2,
134: p_db_link in varchar2,
135: p_source_view in varchar2,
136: p_target_table in varchar2,

Line 156: p_cs_rec in out NOCOPY msd_cs_definitions_v1%rowtype,

152: p_new_refresh_num IN NUMBER,
153: p_request_id in number);
154:
155: Procedure Process_2 (
156: p_cs_rec in out NOCOPY msd_cs_definitions_v1%rowtype,
157: p_cs_name in varchar2,
158: p_db_link in varchar2,
159: p_source_view in varchar2,
160: p_target_table in varchar2,

Line 192: p_cs_rec in out NOCOPY msd_Cs_definitions_v1%rowtype,

188: Procedure debug_line(p_sql in varchar2);
189:
190: Function validate_record (
191: crec_data in out NOCOPY msd_cs_dfn_utl.g_typ_source_stream,
192: p_cs_rec in out NOCOPY msd_Cs_definitions_v1%rowtype,
193: p_instance_id in varchar2,
194: p_err_mesg out NOCOPY varchar2) return boolean;
195:
196: Function Build_Designator_Where_Clause(

Line 197: p_cs_rec in msd_cs_definitions_v1%rowtype,

193: p_instance_id in varchar2,
194: p_err_mesg out NOCOPY varchar2) return boolean;
195:
196: Function Build_Designator_Where_Clause(
197: p_cs_rec in msd_cs_definitions_v1%rowtype,
198: p_process_type in varchar2,
199: p_cs_name in varchar2) return varchar2;
200:
201: /* Logic Starts here */

Line 229: select * from msd_cs_definitions_v1

225:
226: ll_name varchar2(80) := null;
227:
228: cursor c_get_cs is
229: select * from msd_cs_definitions_v1
230: where
231: cs_definition_id = p_definition_id and
232: nvl(valid_flag, 'N') = 'Y';
233:

Line 235: l_cs_rec msd_cs_definitions_v1%rowtype;

231: cs_definition_id = p_definition_id and
232: nvl(valid_flag, 'N') = 'Y';
233:
234: l_sql_stmt varchar2(32767);
235: l_cs_rec msd_cs_definitions_v1%rowtype;
236: l_target varchar2(60);
237: l_source varchar2(60);
238: l_dblink varchar2(60);
239: l_default_where varchar2(200);

Line 252: from msd_cs_definitions

248: Begin
249:
250: select DESCRIPTION
251: into ll_name
252: from msd_cs_definitions
253: where cs_definition_id = p_definition_id;
254:
255: show_line('Stream Name : ' || ll_name);
256:

Line 586: p_cs_rec in out NOCOPY msd_cs_definitions_v1%rowtype,

582: rollback;
583: End;
584:
585: Procedure Process_1 (
586: p_cs_rec in out NOCOPY msd_cs_definitions_v1%rowtype,
587: p_cs_name in varchar2,
588: p_db_link in varchar2,
589: p_source_view in varchar2,
590: p_target_table in varchar2,

Line 700: p_cs_rec in msd_cs_definitions_v1%rowtype,

696: End;
697:
698:
699: Procedure cs_collect_post_process (
700: p_cs_rec in msd_cs_definitions_v1%rowtype,
701: p_cs_name in varchar2,
702: p_instance_id in varchar2 ) is
703:
704: cursor c1 is

Line 798: p_cs_rec in msd_cs_definitions_v1%rowtype,

794:
795:
796: Procedure log_error (
797: crec_data in msd_cs_dfn_utl.g_typ_source_stream,
798: p_cs_rec in msd_cs_definitions_v1%rowtype,
799: p_cs_name in varchar2,
800: p_instance_id in varchar2,
801: p_error_message in varchar2,
802: p_source_view in varchar2,

Line 852: p_cs_rec in msd_cs_definitions_v1%rowtype,

848: End;
849:
850: Procedure log_processed (
851: crec_data in msd_cs_dfn_utl.g_typ_source_stream,
852: p_cs_rec in msd_cs_definitions_v1%rowtype,
853: p_cs_name in varchar2,
854: p_instance_id in varchar2,
855: p_source_view in varchar2,
856: p_target_table in varchar2) is

Line 890: p_cs_rec in msd_cs_definitions_v1%rowtype,

886: End;
887:
888: Procedure ins_row_staging (
889: crec_data in msd_cs_dfn_utl.g_typ_source_stream,
890: p_cs_rec in msd_cs_definitions_v1%rowtype,
891: p_cs_name in varchar2,
892: p_instance_id in varchar2,
893: p_process_status in varchar2,
894: p_error_message in varchar2) is

Line 948: p_cs_rec in msd_cs_definitions_v1%rowtype,

944: End;
945:
946: Procedure ins_row_fact(
947: crec_data in msd_cs_dfn_utl.g_typ_source_stream,
948: p_cs_rec in msd_cs_definitions_v1%rowtype,
949: p_cs_name in varchar2,
950: p_instance_id in varchar2,
951: p_new_refresh_num in NUMBER) is
952: Begin

Line 1003: p_cs_rec in out NOCOPY msd_cs_definitions_v1%rowtype,

999:
1000: End;
1001:
1002: Procedure Process_2 (
1003: p_cs_rec in out NOCOPY msd_cs_definitions_v1%rowtype,
1004: p_cs_name in varchar2,
1005: p_db_link in varchar2,
1006: p_source_view in varchar2,
1007: p_target_table in varchar2,

Line 1177: SELECT multiple_stream_flag FROM msd_cs_definitions

1173: select * from msd_cs_defn_column_dtls_v
1174: where cs_definition_id = p_cs_definition_id;
1175:
1176: CURSOR c_multi_stream IS
1177: SELECT multiple_stream_flag FROM msd_cs_definitions
1178: WHERE cs_definition_id = p_cs_definition_id;
1179:
1180: CURSOR c_cs_name IS
1181: select source_view_column_name

Line 1309: p_cs_rec in out NOCOPY msd_Cs_definitions_v1%rowtype,

1305: End;
1306:
1307: Function validate_record (
1308: crec_data in out NOCOPY msd_cs_dfn_utl.g_typ_source_stream,
1309: p_cs_rec in out NOCOPY msd_Cs_definitions_v1%rowtype,
1310: p_instance_id in varchar2,
1311: p_err_mesg out NOCOPY varchar2) return boolean is
1312:
1313: l_comments1 varchar2(1000);

Line 1879: from msd_cs_definitions

1875: where cs_definition_id = p_cs_definition_id;
1876:
1877: cursor c_multi_stream is
1878: select nvl(multiple_stream_flag,'N')
1879: from msd_cs_definitions
1880: where cs_definition_id = p_cs_definition_id;
1881:
1882: l_multi_flag VARCHAR2(10);
1883:

Line 1948: p_cs_rec in out NOCOPY msd_cs_definitions_v1%rowtype,

1944:
1945: End;
1946:
1947: Procedure Process_1_Sub (
1948: p_cs_rec in out NOCOPY msd_cs_definitions_v1%rowtype,
1949: p_cs_name in varchar2,
1950: p_source_view in varchar2,
1951: p_target_table in varchar2,
1952: p_instance_id in number,

Line 2081: p_cs_rec in msd_cs_definitions_v1%rowtype,

2077: raise;
2078: End;
2079:
2080: Function Build_Designator_Where_Clause(
2081: p_cs_rec in msd_cs_definitions_v1%rowtype,
2082: p_process_type in varchar2,
2083: p_cs_name in varchar2) return varchar2 is
2084:
2085: Cursor C1 is