APPS.AMS_LISTGENERATION_PKG dependencies on AMS_LIST_SRC_TYPES

Line 165: From ams_list_src_types

161: Cursor C_Mapping_Types IS Select list_source_type_id,
162: source_type_code,
163: source_object_name,
164: source_object_pk_field
165: From ams_list_src_types
166: Where master_source_type_flag = 'Y'
167: And list_source_type = 'TARGET';
168:
169: --Getting the set of sub types associated with a master type.

Line 172: From ams_list_src_types a,

168:
169: --Getting the set of sub types associated with a master type.
170: Cursor C_Mapping_SubTypes(p_master_source_type_id ams_list_src_type_assocs.master_source_type_id%type)
171: IS Select source_type_code
172: From ams_list_src_types a,
173: ams_list_src_type_assocs b
174: Where b.master_source_type_id = p_master_source_type_id
175: And b.sub_source_type_id = a.list_source_type_id;
176:

Line 335: p_source_type_code AMS_LIST_SRC_TYPES.SOURCE_TYPE_CODE%TYPE);

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,
339: x_return_status OUT NOCOPY varchar2 );