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_V1

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 587: p_cs_rec in out NOCOPY msd_cs_definitions_v1%rowtype,

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

Line 701: p_cs_rec in msd_cs_definitions_v1%rowtype,

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

Line 799: p_cs_rec in msd_cs_definitions_v1%rowtype,

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

Line 853: p_cs_rec in msd_cs_definitions_v1%rowtype,

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

Line 891: p_cs_rec in msd_cs_definitions_v1%rowtype,

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

Line 949: p_cs_rec in msd_cs_definitions_v1%rowtype,

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

Line 1004: p_cs_rec in out NOCOPY msd_cs_definitions_v1%rowtype,

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

Line 1310: p_cs_rec in out NOCOPY msd_Cs_definitions_v1%rowtype,

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

Line 1949: p_cs_rec in out NOCOPY msd_cs_definitions_v1%rowtype,

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

Line 2082: p_cs_rec in msd_cs_definitions_v1%rowtype,

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