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.AMS_LISTGENERATION_PKG dependencies on AMS_LIST_SRC_TYPE_USAGES

Line 959: -- 2. Delete from ams_list_src_type_usages

955: -----------------------------------------------------------------------------
956: -- Delete_List_Entries
957: -- 1. Delete List entries which may have occured from previous generations
958: --- of the list. Table Name : ams_list_tmp_entries and ams_list_entries
959: -- 2. Delete from ams_list_src_type_usages
960: -- List_src_type_usages store the source type code against each type
961: -- of list
962: -- 10/29/1999 TDONOHOE Created
963: -- 01/24/2001 GJOBY Changed from function to Procedure

Line 1020: --Delete all entries in the ams_list_src_type_usages table. --

1016: write_to_act_log('Entries deleted succesfully in remote instance','LIST', g_list_header_id,'LOW');
1017: end if;
1018: end if;
1019: ------------------------------------------------------------------------------
1020: --Delete all entries in the ams_list_src_type_usages table. --
1021: --These entries must be refreshed each time that a list is refreshed. --
1022: ------------------------------------------------------------------------------
1023: l_delete_action := 'List Source Type usages';
1024: write_to_act_log('Deleting entries from list src type usages tables.', 'LIST', g_list_header_id,'LOW');

Line 1025: DELETE FROM ams_list_src_type_usages

1021: --These entries must be refreshed each time that a list is refreshed. --
1022: ------------------------------------------------------------------------------
1023: l_delete_action := 'List Source Type usages';
1024: write_to_act_log('Deleting entries from list src type usages tables.', 'LIST', g_list_header_id,'LOW');
1025: DELETE FROM ams_list_src_type_usages
1026: WHERE list_header_id = p_list_header_id;
1027: write_to_act_log('Procedure delete_list_entries executed successfully.', 'LIST', g_list_header_id,'LOW');
1028: EXCEPTION
1029: WHEN OTHERS THEN

Line 1207: INSERT INTO ams_list_src_type_usages

1203: l_found NUMBER;
1204: BEGIN
1205:
1206:
1207: INSERT INTO ams_list_src_type_usages
1208: (
1209: list_source_type_usage_id
1210: ,last_update_date
1211: ,last_updated_by

Line 1220: AMS_LIST_SRC_TYPE_USAGES_S.NEXTVAL,

1216: ,source_type_code
1217: ,list_header_id
1218: )
1219: select
1220: AMS_LIST_SRC_TYPE_USAGES_S.NEXTVAL,
1221: SYSDATE,
1222: FND_GLOBAL.USER_ID,
1223: SYSDATE,
1224: FND_GLOBAL.USER_ID,

Line 1232: from ams_list_src_type_usages

1228: p_list_header_id
1229: from dual
1230: where not exists
1231: ( select 'x'
1232: from ams_list_src_type_usages
1233: where list_header_id = p_list_header_id
1234: and source_type_code = p_source_type_code ) ;
1235: EXCEPTION
1236: WHEN OTHERS THEN

Line 2479: INSERT INTO ams_list_src_type_usages

2475:
2476: /*Commented OUT NOCOPY due to perf reasons
2477: and list_entry_source_system_id||list_entry_source_system_type in (' ;
2478: */
2479: INSERT INTO ams_list_src_type_usages
2480: (
2481: list_source_type_usage_id
2482: ,last_update_date
2483: ,last_updated_by

Line 2492: AMS_LIST_SRC_TYPE_USAGES_S.NEXTVAL,

2488: ,source_type_code
2489: ,list_header_id
2490: )
2491: select
2492: AMS_LIST_SRC_TYPE_USAGES_S.NEXTVAL,
2493: SYSDATE,
2494: FND_GLOBAL.USER_ID,
2495: SYSDATE,
2496: FND_GLOBAL.USER_ID,

Line 2501: from ams_list_src_type_usages als

2497: FND_GLOBAL.USER_ID,
2498: 1,
2499: als.source_type_code,
2500: p_action_used_by_id
2501: from ams_list_src_type_usages als
2502: where not exists
2503: ( select 'x'
2504: from ams_list_src_type_usages als1
2505: where als1.list_header_id = p_action_used_by_id -- p_incl_object_id

Line 2504: from ams_list_src_type_usages als1

2500: p_action_used_by_id
2501: from ams_list_src_type_usages als
2502: where not exists
2503: ( select 'x'
2504: from ams_list_src_type_usages als1
2505: where als1.list_header_id = p_action_used_by_id -- p_incl_object_id
2506: and als.source_type_code = als1.source_type_code )
2507: and als.list_header_id = p_incl_object_id ;
2508: write_to_act_log('Insert statement constructed based on the list included.', 'LIST', g_list_header_id,'LOW');

Line 6401: ams_list_src_type_usages b

6397: a.source_object_name,
6398: a.source_object_pk_field,
6399: a.master_source_type_flag
6400: FROM ams_list_src_types a,
6401: ams_list_src_type_usages b
6402: WHERE a.source_type_code = b.source_type_code
6403: AND b.list_header_id = p_list_header_id
6404: AND master_source_type_flag = 'Y' ;
6405: cursor c_child_mapping(c_master_type_id in number) is

Line 6413: ams_list_src_type_usages b

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
6416: AND als.source_type_code = b.source_type_code
6417: AND b.list_header_id = p_list_header_id ;