[Home] [Help]
48: cursor c_child_source_type (l_child_src_type varchar2 )is
49: select a.source_object_name ,
50: a.source_object_name || '.' || b.sub_source_type_pk_column
51: ,b.master_source_type_pk_column
52: from ams_list_src_types a, ams_list_src_type_assocs b
53: where a.source_type_code = l_child_src_type
54: and b.sub_source_type_id = a.list_source_type_id;
55: l_count number;
56: l_master_object_name varchar2(4000);
352: FROM ams_list_src_types a
353: WHERE a.source_type_code = p_master_type
354: AND a.master_source_type_flag = 'Y';
355: cursor c_mapping_subtypes(p_master_type_id
356: ams_list_src_type_assocs.master_source_type_id%type)is
357: select source_type_code
358: from ams_list_src_types a,
359: ams_list_src_type_assocs b
360: where b.master_source_type_id = p_master_type_id
355: cursor c_mapping_subtypes(p_master_type_id
356: ams_list_src_type_assocs.master_source_type_id%type)is
357: select source_type_code
358: from ams_list_src_types a,
359: ams_list_src_type_assocs b
360: where b.master_source_type_id = p_master_type_id
361: and b.sub_source_type_id = a.list_source_type_id;
362:
363: /* bug:4467062 fix:musman
412: t_master_type_id NUMBER;
413: l_child_count number :=0;
414:
415: cursor c_mapping_childtypes(p_master_type_id
416: ams_list_src_type_assocs.master_source_type_id%type)
417: IS
418: select source_type_code
419: from ams_list_src_types a,
420: ams_list_src_type_assocs b
416: ams_list_src_type_assocs.master_source_type_id%type)
417: IS
418: select source_type_code
419: from ams_list_src_types a,
420: ams_list_src_type_assocs b
421: where b.master_source_type_id = p_master_type_id
422: and b.sub_source_type_id = a.list_source_type_id
423: and b.enabled_flag = 'Y'
424: and a.enabled_flag = 'Y'