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 4595: -- Entries from The AMS_LIST_TMP_ENTRIES table.

4591: --
4592: -- PURPOSE
4593:
4594: -- 1. Populate The AMS_LIST_ENTRIES table with a DISTINCT set of
4595: -- Entries from The AMS_LIST_TMP_ENTRIES table.
4596: -- 2. An Entry is considered UNIQUE by values in The list_entry_source_id
4597: -- and List_Entry_Source_Type fields from The AMS_LIST_TMP_ENTRIES table.
4598: -- 3. There may be more than one Entry in The AMS_LIST_TMP_ENTRIES table
4599: -- with The same values for The list_entry_source_id and

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

4593:
4594: -- 1. Populate The AMS_LIST_ENTRIES table with a DISTINCT set of
4595: -- Entries from The AMS_LIST_TMP_ENTRIES table.
4596: -- 2. An Entry is considered UNIQUE by values in The list_entry_source_id
4597: -- and List_Entry_Source_Type fields from The AMS_LIST_TMP_ENTRIES table.
4598: -- 3. There may be more than one Entry in The AMS_LIST_TMP_ENTRIES table
4599: -- with The same values for The list_entry_source_id and
4600: -- List_Entry_Source_Type fields, in this case The Entry with
4601: -- the Highest Rank is choosen, if Two Equivalent entries have

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

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

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

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

Line 4637: delete from ams_list_tmp_entries alte1

4633: WHERE list_header_id= x_list_header_id;
4634:
4635: BEGIN
4636: write_to_act_log('Executing procedure create_list_entries', 'LIST', g_list_header_id,'LOW');
4637: delete from ams_list_tmp_entries alte1
4638: where alte1.rowid > (select min(alte2.rowid)
4639: from ams_list_tmp_entries alte2
4640: where alte2.list_header_id = alte1.list_header_id
4641: and alte2.list_select_action_id

Line 4639: from ams_list_tmp_entries alte2

4635: BEGIN
4636: write_to_act_log('Executing procedure create_list_entries', 'LIST', g_list_header_id,'LOW');
4637: delete from ams_list_tmp_entries alte1
4638: where alte1.rowid > (select min(alte2.rowid)
4639: from ams_list_tmp_entries alte2
4640: where alte2.list_header_id = alte1.list_header_id
4641: and alte2.list_select_action_id
4642: = alte1.list_select_action_id
4643: and alte2.list_entry_source_key

Line 4646: delete from ams_list_tmp_entries alte1

4642: = alte1.list_select_action_id
4643: and alte2.list_entry_source_key
4644: = alte1.list_entry_source_key );
4645:
4646: delete from ams_list_tmp_entries alte1
4647: where alte1.rank > (select min(alte2.rank)
4648: from ams_list_tmp_entries alte2
4649: where alte2.list_header_id = alte1.list_header_id
4650: and alte2.list_entry_source_key

Line 4648: from ams_list_tmp_entries alte2

4644: = alte1.list_entry_source_key );
4645:
4646: delete from ams_list_tmp_entries alte1
4647: where alte1.rank > (select min(alte2.rank)
4648: from ams_list_tmp_entries alte2
4649: where alte2.list_header_id = alte1.list_header_id
4650: and alte2.list_entry_source_key
4651: = alte1.list_entry_source_key );
4652:

Line 4712: ams_list_tmp_entries t,

4708: 'N',
4709: 'Y',
4710: 1
4711: from ams_list_select_actions s,
4712: ams_list_tmp_entries t,
4713: ams_list_headers_all h
4714: where h.list_header_id = p_list_header_id
4715: and t.list_header_id = h.list_header_id
4716: and t.list_select_action_id = s.list_select_action_id

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

12522: ) is
12523: l_final_sql varchar2(32767);
12524: l_insert_sql varchar2(32767);
12525: l_insert_sql1 varchar2(32767);
12526: l_table_name varchar2(80) := ' ams_list_tmp_entries ';
12527: BEGIN
12528: write_to_act_log('Execution of procedure process_rt_insert_sql started', 'LIST', g_list_header_id,'LOW');
12529:
12530: l_insert_sql := p_select_statement ;