APPS.AMS_LIST_SRC_TYPES_PVT dependencies on AMS_LIST_SRC_TYPES

Line 1: PACKAGE BODY AMS_LIST_SRC_TYPES_PVT AS

1: PACKAGE BODY AMS_LIST_SRC_TYPES_PVT AS
2: /* $Header: amsvstvb.pls 120.3 2005/06/07 11:53:44 appldev $ */
3:
4: -----------------------------------------------------------
5: -- PACKAGE

Line 6: -- AMS_LIST_SRC_TYPES_PVT

2: /* $Header: amsvstvb.pls 120.3 2005/06/07 11:53:44 appldev $ */
3:
4: -----------------------------------------------------------
5: -- PACKAGE
6: -- AMS_LIST_SRC_TYPES_PVT
7: --
8: -- PURPOSE
9: -- The purpose of this package is to creat and update the
10: -- views for Master list source type.

Line 48: G_PKG_NAME CONSTANT VARCHAR2(30):='AMS_LIST_SRC_TYPES_PVT';

44: AMS_LOG_PROCEDURE constant number := FND_LOG.LEVEL_PROCEDURE;
45: AMS_LOG_EXCEPTION constant Number := FND_LOG.LEVEL_EXCEPTION;
46: AMS_LOG_STATEMENT constant Number := FND_LOG.LEVEL_STATEMENT;
47:
48: G_PKG_NAME CONSTANT VARCHAR2(30):='AMS_LIST_SRC_TYPES_PVT';
49: G_module_name constant varchar2(100):='oracle.apps.ams.plsql.'||g_pkg_name;
50:
51: PROCEDURE master_source_type_view(
52: p_api_version IN NUMBER,

Line 96: FROM ams_list_src_types --ams_list_src_types_vl

92:
93:
94: cursor c_list_src_type_name is
95: SELECT SUBSTR(REPLACE(source_type_code,' ','_'),1,20), source_type_code
96: FROM ams_list_src_types --ams_list_src_types_vl
97: WHERE list_source_type_id = p_list_source_type_id;
98:
99:
100: cursor c_master is

Line 127: ams_list_src_types_vl ast

123: and aso.SUB_SOURCE_TYPE_ID in (
124: SELECT distinct asa.sub_source_type_id
125: FROM ams_list_src_fields_vl asf,
126: ams_list_src_type_assocs asa,
127: ams_list_src_types_vl ast
128: WHERE asa.master_source_type_id = aso.master_source_type_id
129: AND asa.sub_source_type_id = aso.SUB_SOURCE_TYPE_ID
130: AND asa.sub_source_type_id = asf.list_source_type_id
131: AND asa.sub_source_type_id = ast.list_source_type_id

Line 157: ams_list_src_types_vl ast

153: and aso.SUB_SOURCE_TYPE_ID in (
154: SELECT distinct asa.sub_source_type_id
155: FROM ams_list_src_fields_vl asf,
156: ams_list_src_type_assocs asa,
157: ams_list_src_types_vl ast
158: WHERE asa.master_source_type_id = aso.master_source_type_id
159: AND asa.sub_source_type_id = aso.SUB_SOURCE_TYPE_ID
160: AND asa.sub_source_type_id = asf.list_source_type_id
161: AND asa.sub_source_type_id = ast.list_source_type_id

Line 169: SELECT list_source_type_id FROM ams_list_src_types_vl WHERE source_type_code = 'FAX';

165: */
166:
167:
168: cursor c_fax_sub_types is
169: SELECT list_source_type_id FROM ams_list_src_types_vl WHERE source_type_code = 'FAX';
170:
171: cursor c_sub_type is
172: SELECT asf.list_source_field_id, asf.field_column_name, substr(replace(asf.source_column_name,' ','_'),1,26)||'_S'||to_char(i_number)
173: FROM ams_list_src_fields asf,

Line 185: ams_list_src_types_vl ast

181: /* SQL ID: 11756019 Fix
182: SELECT asf.list_source_field_id, asf.field_column_name, substr(replace(asf.source_column_name,' ','_'),1,26)||'_S'||to_char(i_number)
183: FROM ams_list_src_fields_vl asf,
184: ams_list_src_type_assocs asa,
185: ams_list_src_types_vl ast
186: WHERE asa.master_source_type_id = p_list_source_type_id
187: AND asa.sub_source_type_id = L_SUB_SOURCE_TYPE_ID
188: AND asa.sub_source_type_id = asf.list_source_type_id
189: AND asa.sub_source_type_id = ast.list_source_type_id

Line 210: ams_list_src_types_vl ast

206: /* SQL ID: 11756034 fix: musman
207: SELECT count(*)
208: FROM ams_list_src_fields_vl asf,
209: ams_list_src_type_assocs asa,
210: ams_list_src_types_vl ast
211: WHERE asa.master_source_type_id = p_list_source_type_id
212: AND asa.sub_source_type_id = L_SUB_SOURCE_TYPE_ID
213: AND asa.sub_source_type_id = asf.list_source_type_id
214: AND asa.sub_source_type_id = ast.list_source_type_id

Line 225: ams_list_src_types_vl ast

221: cursor c_dup_st is
222: SELECT COUNT(*)
223: FROM ams_list_src_fields_vl asf,
224: ams_list_src_type_assocs asa,
225: ams_list_src_types_vl ast
226: WHERE asa.master_source_type_id = p_list_source_type_id
227: AND asa.sub_source_type_id = asf.list_source_type_id
228: AND asa.sub_source_type_id = ast.list_source_type_id
229: AND NVL(asf.enabled_flag,'Y') = 'Y'

Line 722: SELECT list_source_type, master_source_type_flag FROM ams_list_src_types_vl

718: -- Status Local Variables
719: l_return_status VARCHAR2(1); -- Return value from procedures
720:
721: cursor c_source_type is
722: SELECT list_source_type, master_source_type_flag FROM ams_list_src_types_vl
723: WHERE list_source_type_id = p_list_source_type_id;
724:
725:
726: begin

Line 904: end AMS_LIST_SRC_TYPES_PVT;

900: p_encoded => FND_API.G_FALSE
901: );
902: end process_views;
903:
904: end AMS_LIST_SRC_TYPES_PVT;