DBA Data[Home] [Help]

APPS.AMS_LISTGENERATION_PKG dependencies on AMS_LIST_SRC_TYPE_ASSOCS

Line 2642: from ams_list_src_types a, ams_list_src_type_assocs b

2638: cursor c_child_source_type (l_child_src_type varchar2 )is
2639: select a.source_object_name ,
2640: a.source_object_name || '.' || b.sub_source_type_pk_column
2641: ,b.master_source_type_pk_column
2642: from ams_list_src_types a, ams_list_src_type_assocs b
2643: where a.source_type_code = l_child_src_type
2644: and b.sub_source_type_id = a.list_source_type_id
2645: and b.master_source_type_id = l_master_source_type_id ;
2646: l_count number;

Line 3000: ams_list_src_type_assocs.master_source_type_id%type)

2996: x_found OUT NOCOPY varchar2 ) is
2997:
2998:
2999: cursor c_mapping_subtypes(p_master_type_id
3000: ams_list_src_type_assocs.master_source_type_id%type)
3001: IS
3002: select source_type_code
3003: from ams_list_src_types a,
3004: ams_list_src_type_assocs b

Line 3004: ams_list_src_type_assocs b

3000: ams_list_src_type_assocs.master_source_type_id%type)
3001: IS
3002: select source_type_code
3003: from ams_list_src_types a,
3004: ams_list_src_type_assocs b
3005: where b.master_source_type_id = p_master_type_id
3006: and b.sub_source_type_id = a.list_source_type_id
3007: and b.enabled_flag = 'Y'
3008: and a.enabled_flag = 'Y'

Line 6411: FROM ams_list_src_type_assocs al,

6407: al.SUB_SOURCE_TYPE_PK_COLUMN,
6408: als.source_object_name,
6409: als.source_type_code,
6410: al.master_source_type_pk_column
6411: FROM ams_list_src_type_assocs al,
6412: ams_list_src_types als ,
6413: ams_list_src_type_usages b
6414: WHERE al.MASTER_SOURCE_TYPE_ID = c_master_type_id
6415: AND als.list_source_type_id = al.sub_source_type_id

Line 6423: l_sub_source_type_pk_column AMS_LIST_SRC_TYPE_ASSOCS.SUB_SOURCE_TYPE_PK_COLUMN%TYPE;

6419: l_source_type_code AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE;
6420: l_source_object_name AMS_LIST_SRC_TYPES.SOURCE_OBJECT_NAME%TYPE;
6421: l_source_object_pk_field AMS_LIST_SRC_TYPES.SOURCE_OBJECT_PK_FIELD%TYPE;
6422: l_master_source_type_flag AMS_LIST_SRC_TYPES.MASTER_SOURCE_TYPE_FLAG%TYPE;
6423: l_sub_source_type_pk_column AMS_LIST_SRC_TYPE_ASSOCS.SUB_SOURCE_TYPE_PK_COLUMN%TYPE;
6424: l_dummy_pk_column AMS_LIST_SRC_TYPE_ASSOCS.master_SOURCE_TYPE_PK_COLUMN%TYPE;
6425: l_SUB_SOURCE_TYPE_ID number;
6426: l_SUB_SOURCE_OBJECT_NAME varchar2(300);
6427: l_sub_source_type_code AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE;

Line 6424: l_dummy_pk_column AMS_LIST_SRC_TYPE_ASSOCS.master_SOURCE_TYPE_PK_COLUMN%TYPE;

6420: l_source_object_name AMS_LIST_SRC_TYPES.SOURCE_OBJECT_NAME%TYPE;
6421: l_source_object_pk_field AMS_LIST_SRC_TYPES.SOURCE_OBJECT_PK_FIELD%TYPE;
6422: l_master_source_type_flag AMS_LIST_SRC_TYPES.MASTER_SOURCE_TYPE_FLAG%TYPE;
6423: l_sub_source_type_pk_column AMS_LIST_SRC_TYPE_ASSOCS.SUB_SOURCE_TYPE_PK_COLUMN%TYPE;
6424: l_dummy_pk_column AMS_LIST_SRC_TYPE_ASSOCS.master_SOURCE_TYPE_PK_COLUMN%TYPE;
6425: l_SUB_SOURCE_TYPE_ID number;
6426: l_SUB_SOURCE_OBJECT_NAME varchar2(300);
6427: l_sub_source_type_code AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE;
6428: l_sub_source_master_type AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE;

Line 6919: ams_list_src_type_assocs ats

6915: and fd.FIELD_COLUMN_NAME is NOT NULL;
6916:
6917: cursor c_child_ds_fields_mapped is
6918: select 'Y' from ams_list_src_fields fd, ams_list_headers_all hd, ams_list_src_types ty,
6919: ams_list_src_type_assocs ats
6920: where hd.list_header_id = p_list_header_id
6921: and hd.LIST_SOURCE_TYPE = ty.source_type_code
6922: and ty.list_source_type_id = ats.master_source_type_id
6923: and ats.sub_source_type_id = fd.LIST_SOURCE_TYPE_ID

Line 6943: ams_list_src_type_assocs e

6939: SELECT d.field_column_name field_column_name1,d.field_column_name
6940: FROM ams_list_src_types a,
6941: ams_list_headers_all b,
6942: ams_list_src_fields d,
6943: ams_list_src_type_assocs e
6944: WHERE a.source_type_code = b.list_source_type
6945: and b.list_header_id = p_list_header_id
6946: and e.master_source_type_id = a.list_source_type_id
6947: and d.list_source_type_id = e.sub_source_type_id

Line 6973: ams_list_src_type_assocs e

6969: SELECT d.source_column_name, d.field_column_name, d.de_list_source_type_code stc
6970: FROM ams_list_src_types a,
6971: ams_list_headers_all b,
6972: ams_list_src_fields d,
6973: ams_list_src_type_assocs e
6974: WHERE a.source_type_code = b.list_source_type
6975: and b.list_header_id = g_list_header_id
6976: and e.master_source_type_id = a.list_source_type_id
6977: and d.list_source_type_id = e.sub_source_type_id

Line 7948: ams_list_src_type_assocs.master_source_type_id%type)is

7944: FROM ams_list_src_types a
7945: WHERE a.source_type_code = p_master_type
7946: AND a.master_source_type_flag = 'Y';
7947: cursor c_mapping_subtypes(p_master_type_id
7948: ams_list_src_type_assocs.master_source_type_id%type)is
7949: select ','||''''||source_type_code||''''
7950: from ams_list_src_types a,
7951: ams_list_src_type_assocs b
7952: where b.master_source_type_id = p_master_type_id

Line 7951: ams_list_src_type_assocs b

7947: cursor c_mapping_subtypes(p_master_type_id
7948: ams_list_src_type_assocs.master_source_type_id%type)is
7949: select ','||''''||source_type_code||''''
7950: from ams_list_src_types a,
7951: ams_list_src_type_assocs b
7952: where b.master_source_type_id = p_master_type_id
7953: and b.sub_source_type_id = a.list_source_type_id;
7954:
7955: l_master_type_id number;

Line 9594: ams_list_src_type_assocs ats

9590: and fd.FIELD_COLUMN_NAME is NOT NULL;
9591:
9592: cursor c_child_ds_fields_mapped is
9593: select 'Y' from ams_list_src_fields fd, ams_list_headers_all hd, ams_list_src_types ty,
9594: ams_list_src_type_assocs ats
9595: where hd.list_header_id = p_list_header_id
9596: and hd.LIST_SOURCE_TYPE = ty.source_type_code
9597: and ty.list_source_type_id = ats.master_source_type_id
9598: and ats.sub_source_type_id = fd.LIST_SOURCE_TYPE_ID

Line 9631: ams_list_src_type_assocs ats

9627: and fd.tca_column_id is NOT NULL;
9628:
9629: cursor c_child_ds_tca_mapped is
9630: select 'Y' from ams_list_src_fields fd, ams_list_headers_all hd, ams_list_src_types ty,
9631: ams_list_src_type_assocs ats
9632: where hd.list_header_id = p_list_header_id
9633: and hd.LIST_SOURCE_TYPE = ty.source_type_code
9634: and ty.list_source_type_id = ats.master_source_type_id
9635: and ats.sub_source_type_id = fd.LIST_SOURCE_TYPE_ID

Line 9654: ams_list_src_type_assocs e

9650: SELECT d.field_column_name field_column_name1,d.field_column_name
9651: FROM ams_list_src_types a,
9652: ams_list_headers_all b,
9653: ams_list_src_fields d,
9654: ams_list_src_type_assocs e
9655: WHERE a.source_type_code = b.list_source_type
9656: and b.list_header_id = p_list_header_id
9657: and e.master_source_type_id = a.list_source_type_id
9658: and d.list_source_type_id = e.sub_source_type_id

Line 9685: ams_list_src_type_assocs e

9681: SELECT d.source_column_name, d.field_column_name, d.de_list_source_type_code stc
9682: FROM ams_list_src_types a,
9683: ams_list_headers_all b,
9684: ams_list_src_fields d,
9685: ams_list_src_type_assocs e
9686: WHERE a.source_type_code = b.list_source_type
9687: and b.list_header_id = g_list_header_id
9688: and e.master_source_type_id = a.list_source_type_id
9689: and d.list_source_type_id = e.sub_source_type_id

Line 12399: from ams_list_src_types a, ams_list_src_type_assocs b

12395: cursor c_child_source_type (l_child_src_type varchar2 )is
12396: select a.source_object_name ,
12397: a.source_object_name || '.' || b.sub_source_type_pk_column
12398: ,b.master_source_type_pk_column
12399: from ams_list_src_types a, ams_list_src_type_assocs b
12400: where a.source_type_code = l_child_src_type
12401: and b.sub_source_type_id = a.list_source_type_id;
12402: l_count number;
12403: l_master_object_name varchar2(4000);