APPS.AMS_LISTGENERATION_PKG dependencies on AMS_LIST_HEADERS_ALL

Line 20: -- 06/22/2000 tdonohoe modified c_listheader_dets to explicitly specify column values from the ams_list_headers_all table.

16: --
17: --
18: -- HISTORY
19: -- 06/21/1999 tdonohoe created
20: -- 06/22/2000 tdonohoe modified c_listheader_dets to explicitly specify column values from the ams_list_headers_all table.
21: -- End of Comments
22:
23:
24: --Retrieve all List Header parameters necessary for generation of the list.

Line 116: From ams_list_headers_all

112: ,attribute14
113: ,attribute15
114: ,timezone_id
115: ,user_entered_start_time
116: From ams_list_headers_all
117: Where list_header_id = p_list_header_id;
118:
119: --Retrieve all List Action details which generate the set of list entries for the list.
120: Cursor C_ListAction_Dets(p_list_header_id ams_list_headers_all.list_header_id%type)

Line 120: Cursor C_ListAction_Dets(p_list_header_id ams_list_headers_all.list_header_id%type)

116: From ams_list_headers_all
117: Where list_header_id = p_list_header_id;
118:
119: --Retrieve all List Action details which generate the set of list entries for the list.
120: Cursor C_ListAction_Dets(p_list_header_id ams_list_headers_all.list_header_id%type)
121: IS
122: SELECT
123: list_select_action_id
124: ,last_update_date

Line 152: Cursor C_Action_Entry_Count(p_list_header_id ams_list_headers_all.list_header_id%type)

148: ORDER BY order_number;
149:
150: --Retrieve the number of list entries for each list action, excluding entries which are
151: --marked as duplicates.
152: Cursor C_Action_Entry_Count(p_list_header_id ams_list_headers_all.list_header_id%type)
153: IS Select list_select_action_id,count(*)
154: From ams_list_entries
155: where list_header_id = p_list_header_id
156: and marked_as_duplicate_flag ='N'

Line 334: (p_list_header_id AMS_LIST_HEADERS_ALL.LIST_HEADER_ID%TYPE,

330: x_msg_data OUT NOCOPY VARCHAR2,
331: x_list_header_id OUT NOCOPY NUMBER ) ;
332:
333: PROCEDURE insert_list_mapping_usage
334: (p_list_header_id AMS_LIST_HEADERS_ALL.LIST_HEADER_ID%TYPE,
335: p_source_type_code AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE);
336: PROCEDURE GET_LIST_ENTRY_DATA
337: (p_list_header_id in number,
338: p_additional_where_condition in varchar2 default null,

Line 431: (p_list_header_id AMS_LIST_HEADERS_ALL.LIST_HEADER_ID%TYPE

427: x_msg_count OUT NOCOPY NUMBER,
428: x_msg_data OUT NOCOPY VARCHAR2) ;
429:
430: PROCEDURE Execute_Remote_Dedupe_List
431: (p_list_header_id AMS_LIST_HEADERS_ALL.LIST_HEADER_ID%TYPE
432: ,p_enable_word_replacement_flag AMS_LIST_HEADERS_ALL.ENABLE_WORD_REPLACEMENT_FLAG%TYPE
433: ,p_send_to_log VARCHAR2 := 'N'
434: ,p_object_name VARCHAR2 := 'AMS_LIST_ENTRIES'
435: );

Line 432: ,p_enable_word_replacement_flag AMS_LIST_HEADERS_ALL.ENABLE_WORD_REPLACEMENT_FLAG%TYPE

428: x_msg_data OUT NOCOPY VARCHAR2) ;
429:
430: PROCEDURE Execute_Remote_Dedupe_List
431: (p_list_header_id AMS_LIST_HEADERS_ALL.LIST_HEADER_ID%TYPE
432: ,p_enable_word_replacement_flag AMS_LIST_HEADERS_ALL.ENABLE_WORD_REPLACEMENT_FLAG%TYPE
433: ,p_send_to_log VARCHAR2 := 'N'
434: ,p_object_name VARCHAR2 := 'AMS_LIST_ENTRIES'
435: );
436: