APPS.MSD_CS_COLLECTION dependencies on MSD_CS_DFN_UTL

Line 85: crec_data in msd_cs_dfn_utl.g_typ_source_stream,

81: p_parameter10 in varchar2,
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,

Line 93: crec_data in msd_cs_dfn_utl.g_typ_source_stream,

89: p_source_view in varchar2,
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,

Line 111: crec_data in msd_cs_dfn_utl.g_typ_source_stream,

107: p_instance_id in number,
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);

Line 118: crec_data in msd_cs_dfn_utl.g_typ_source_stream,

114: p_instance_id in varchar2,
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,

Line 191: crec_data in out NOCOPY msd_cs_dfn_utl.g_typ_source_stream,

187:
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:

Line 613: l_rec msd_cs_dfn_utl.G_TYP_SOURCE_STREAM;

609:
610: TYPE cur_type is REF CURSOR;
611:
612: l_cur cur_type;
613: l_rec msd_cs_dfn_utl.G_TYP_SOURCE_STREAM;
614: l_valid boolean;
615: l_err_msg varchar2(1000);
616: l_sql_stmt varchar2(5000);
617: l_where varchar2(3000);

Line 798: crec_data in msd_cs_dfn_utl.g_typ_source_stream,

794: End;
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,

Line 852: crec_data in msd_cs_dfn_utl.g_typ_source_stream,

848:
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,

Line 890: crec_data in msd_cs_dfn_utl.g_typ_source_stream,

886:
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,

Line 948: crec_data in msd_cs_dfn_utl.g_typ_source_stream,

944:
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

Line 1309: crec_data in out NOCOPY msd_cs_dfn_utl.g_typ_source_stream,

1305: end loop;
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:

Line 1959: l_rec msd_cs_dfn_utl.G_TYP_SOURCE_STREAM;

1955: p_new_refresh_num IN NUMBER) is
1956:
1957: TYPE cur_type is REF CURSOR;
1958: l_cur cur_type;
1959: l_rec msd_cs_dfn_utl.G_TYP_SOURCE_STREAM;
1960:
1961: l_valid boolean;
1962: l_err_msg varchar2(1000);
1963: