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 612: l_rec msd_cs_dfn_utl.G_TYP_SOURCE_STREAM;

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

Line 797: crec_data in msd_cs_dfn_utl.g_typ_source_stream,

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

Line 851: crec_data in msd_cs_dfn_utl.g_typ_source_stream,

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

Line 889: crec_data in msd_cs_dfn_utl.g_typ_source_stream,

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

Line 947: crec_data in msd_cs_dfn_utl.g_typ_source_stream,

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

Line 1308: crec_data in out NOCOPY msd_cs_dfn_utl.g_typ_source_stream,

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

Line 1958: l_rec msd_cs_dfn_utl.G_TYP_SOURCE_STREAM;

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