APPS.AMS_IMP_CONFIG_COMPONENTS_PKG dependencies on AMS_IMP_CONFIG_COMPONENTS

Line 1: package body AMS_IMP_CONFIG_COMPONENTS_PKG as

1: package body AMS_IMP_CONFIG_COMPONENTS_PKG as
2: /* $Header: amsiccpb.pls 115.4 2004/04/07 19:12:12 usingh ship $ */
3: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
4: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
5: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

Line 23: insert into AMS_IMP_CONFIG_COMPONENTS (

19: X_LAST_UPDATED_BY in NUMBER,
20: X_LAST_UPDATE_LOGIN in NUMBER
21: ) is
22: begin
23: insert into AMS_IMP_CONFIG_COMPONENTS (
24: CREATION_DATE,
25: IMPORT_TYPE,
26: COMPONENT_TYPE,
27: IMPORT_MODULE,

Line 70: from AMS_IMP_CONFIG_COMPONENTS

66: COMPONENT_NAME,
67: ACCESS_ALLOWED,
68: OBJECT_VERSION_NUMBER,
69: CONFIG_COMPONENT_ID
70: from AMS_IMP_CONFIG_COMPONENTS
71: where CONFIG_COMPONENT_ID = X_CONFIG_COMPONENT_ID
72: for update of CONFIG_COMPONENT_ID nowait;
73: begin
74: for tlinfo in c1 loop

Line 105: update AMS_IMP_CONFIG_COMPONENTS set

101: X_LAST_UPDATED_BY in NUMBER,
102: X_LAST_UPDATE_LOGIN in NUMBER
103: ) is
104: begin
105: update AMS_IMP_CONFIG_COMPONENTS set
106: IMPORT_TYPE = X_IMPORT_TYPE,
107: COMPONENT_TYPE = X_COMPONENT_TYPE,
108: IMPORT_MODULE = X_IMPORT_MODULE,
109: COMPONENT_NAME = X_COMPONENT_NAME,

Line 126: delete from AMS_IMP_CONFIG_COMPONENTS

122: procedure DELETE_ROW (
123: X_CONFIG_COMPONENT_ID in NUMBER
124: ) is
125: begin
126: delete from AMS_IMP_CONFIG_COMPONENTS
127: where CONFIG_COMPONENT_ID = X_CONFIG_COMPONENT_ID;
128:
129: if (sql%notfound) then
130: raise no_data_found;

Line 158: from AMS_IMP_CONFIG_COMPONENTS

154: l_row_id varchar2(100);
155:
156: cursor c_chk_col_exists is
157: select 'x'
158: from AMS_IMP_CONFIG_COMPONENTS
159: where CONFIG_COMPONENT_ID = X_CONFIG_COMPONENT_ID;
160:
161: cursor c_get_con_com_id is
162: select AMS_IMP_CONFIG_COMPONENTS_S.nextval

Line 162: select AMS_IMP_CONFIG_COMPONENTS_S.nextval

158: from AMS_IMP_CONFIG_COMPONENTS
159: where CONFIG_COMPONENT_ID = X_CONFIG_COMPONENT_ID;
160:
161: cursor c_get_con_com_id is
162: select AMS_IMP_CONFIG_COMPONENTS_S.nextval
163: from dual;
164:
165: begin
166:

Line 184: AMS_IMP_CONFIG_COMPONENTS_PKG.INSERT_ROW (

180: close c_get_con_com_id;
181: else
182: l_concom_id := X_CONFIG_COMPONENT_ID;
183: end if;
184: AMS_IMP_CONFIG_COMPONENTS_PKG.INSERT_ROW (
185: X_ROWID => l_row_id,
186: X_CONFIG_COMPONENT_ID => X_CONFIG_COMPONENT_ID,
187: X_IMPORT_TYPE => X_IMPORT_TYPE,
188: X_COMPONENT_TYPE => X_COMPONENT_TYPE,

Line 202: AMS_IMP_CONFIG_COMPONENTS_PKG.UPDATE_ROW (

198:
199: else
200: close c_chk_col_exists;
201: l_concom_id := X_CONFIG_COMPONENT_ID;
202: AMS_IMP_CONFIG_COMPONENTS_PKG.UPDATE_ROW (
203: X_CONFIG_COMPONENT_ID => X_CONFIG_COMPONENT_ID,
204: X_IMPORT_TYPE => X_IMPORT_TYPE,
205: X_COMPONENT_TYPE => X_COMPONENT_TYPE,
206: X_IMPORT_MODULE => X_IMPORT_MODULE,

Line 215: end AMS_IMP_CONFIG_COMPONENTS_PKG;

211: X_LAST_UPDATED_BY => l_user_id,
212: X_LAST_UPDATE_LOGIN => 1);
213: end if;
214: end LOAD_ROW;
215: end AMS_IMP_CONFIG_COMPONENTS_PKG;