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_TMP_ENTRIES

Line 958: --- of the list. Table Name : ams_list_tmp_entries and ams_list_entries

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

Line 2835: l_table_name varchar2(80) := ' ams_list_tmp_entries ';

2831: ) is
2832: l_final_sql varchar2(32767);
2833: l_insert_sql varchar2(32767);
2834: l_insert_sql1 varchar2(32767);
2835: l_table_name varchar2(80) := ' ams_list_tmp_entries ';
2836: BEGIN
2837: write_to_act_log('Executing process_insert_sql procedure', 'LIST', g_list_header_id,'LOW');
2838: /*
2839: if p_list_action_type <> 'INCLUDE' then

Line 4588: -- Entries from The AMS_LIST_TMP_ENTRIES table.

4584: --
4585: -- PURPOSE
4586:
4587: -- 1. Populate The AMS_LIST_ENTRIES table with a DISTINCT set of
4588: -- Entries from The AMS_LIST_TMP_ENTRIES table.
4589: -- 2. An Entry is considered UNIQUE by values in The list_entry_source_id
4590: -- and List_Entry_Source_Type fields from The AMS_LIST_TMP_ENTRIES table.
4591: -- 3. There may be more than one Entry in The AMS_LIST_TMP_ENTRIES table
4592: -- with The same values for The list_entry_source_id and

Line 4590: -- and List_Entry_Source_Type fields from The AMS_LIST_TMP_ENTRIES table.

4586:
4587: -- 1. Populate The AMS_LIST_ENTRIES table with a DISTINCT set of
4588: -- Entries from The AMS_LIST_TMP_ENTRIES table.
4589: -- 2. An Entry is considered UNIQUE by values in The list_entry_source_id
4590: -- and List_Entry_Source_Type fields from The AMS_LIST_TMP_ENTRIES table.
4591: -- 3. There may be more than one Entry in The AMS_LIST_TMP_ENTRIES table
4592: -- with The same values for The list_entry_source_id and
4593: -- List_Entry_Source_Type fields, in this case The Entry with
4594: -- the Highest Rank is choosen, if Two Equivalent entries have

Line 4591: -- 3. There may be more than one Entry in The AMS_LIST_TMP_ENTRIES table

4587: -- 1. Populate The AMS_LIST_ENTRIES table with a DISTINCT set of
4588: -- Entries from The AMS_LIST_TMP_ENTRIES table.
4589: -- 2. An Entry is considered UNIQUE by values in The list_entry_source_id
4590: -- and List_Entry_Source_Type fields from The AMS_LIST_TMP_ENTRIES table.
4591: -- 3. There may be more than one Entry in The AMS_LIST_TMP_ENTRIES table
4592: -- with The same values for The list_entry_source_id and
4593: -- List_Entry_Source_Type fields, in this case The Entry with
4594: -- the Highest Rank is choosen, if Two Equivalent entries have
4595: -- the same rank then one entry is choosen arbitrarily.

Line 4596: -- 4. The set of distinct entries in The AMS_LIST_TMP_ENTRIES table

4592: -- with The same values for The list_entry_source_id and
4593: -- List_Entry_Source_Type fields, in this case The Entry with
4594: -- the Highest Rank is choosen, if Two Equivalent entries have
4595: -- the same rank then one entry is choosen arbitrarily.
4596: -- 4. The set of distinct entries in The AMS_LIST_TMP_ENTRIES table
4597: -- have the SAVE_ROW_FLAG updated to 'Y'.
4598: -- Rows with this value are then inserted into the AMS_LIST_ENTRIES table.
4599: -- 5. if less entries exist in the AMS_LIST_ENTRIES_TABLE than specifed
4600: -- in the AMS_LIST_HEADERS_ALL

Line 4630: delete from ams_list_tmp_entries alte1

4626: WHERE list_header_id= x_list_header_id;
4627:
4628: BEGIN
4629: write_to_act_log('Executing procedure create_list_entries', 'LIST', g_list_header_id,'LOW');
4630: delete from ams_list_tmp_entries alte1
4631: where alte1.rowid > (select min(alte2.rowid)
4632: from ams_list_tmp_entries alte2
4633: where alte2.list_header_id = alte1.list_header_id
4634: and alte2.list_select_action_id

Line 4632: from ams_list_tmp_entries alte2

4628: BEGIN
4629: write_to_act_log('Executing procedure create_list_entries', 'LIST', g_list_header_id,'LOW');
4630: delete from ams_list_tmp_entries alte1
4631: where alte1.rowid > (select min(alte2.rowid)
4632: from ams_list_tmp_entries alte2
4633: where alte2.list_header_id = alte1.list_header_id
4634: and alte2.list_select_action_id
4635: = alte1.list_select_action_id
4636: and alte2.list_entry_source_key

Line 4639: delete from ams_list_tmp_entries alte1

4635: = alte1.list_select_action_id
4636: and alte2.list_entry_source_key
4637: = alte1.list_entry_source_key );
4638:
4639: delete from ams_list_tmp_entries alte1
4640: where alte1.rank > (select min(alte2.rank)
4641: from ams_list_tmp_entries alte2
4642: where alte2.list_header_id = alte1.list_header_id
4643: and alte2.list_entry_source_key

Line 4641: from ams_list_tmp_entries alte2

4637: = alte1.list_entry_source_key );
4638:
4639: delete from ams_list_tmp_entries alte1
4640: where alte1.rank > (select min(alte2.rank)
4641: from ams_list_tmp_entries alte2
4642: where alte2.list_header_id = alte1.list_header_id
4643: and alte2.list_entry_source_key
4644: = alte1.list_entry_source_key );
4645:

Line 4705: ams_list_tmp_entries t,

4701: 'N',
4702: 'Y',
4703: 1
4704: from ams_list_select_actions s,
4705: ams_list_tmp_entries t,
4706: ams_list_headers_all h
4707: where h.list_header_id = p_list_header_id
4708: and t.list_header_id = h.list_header_id
4709: and t.list_select_action_id = s.list_select_action_id

Line 12425: l_table_name varchar2(80) := ' ams_list_tmp_entries ';

12421: ) is
12422: l_final_sql varchar2(32767);
12423: l_insert_sql varchar2(32767);
12424: l_insert_sql1 varchar2(32767);
12425: l_table_name varchar2(80) := ' ams_list_tmp_entries ';
12426: BEGIN
12427: write_to_act_log('Execution of procedure process_rt_insert_sql started', 'LIST', g_list_header_id,'LOW');
12428:
12429: l_insert_sql := p_select_statement ;