APPS.AMS_EXP_TEMPLATE_PKG dependencies on AMS_EXP_TEMPLATE

Line 1: package body AMS_EXP_TEMPLATE_PKG as

1: package body AMS_EXP_TEMPLATE_PKG as
2: /* $Header: amsextmb.pls 115.3 2002/11/14 21:55:44 jieli noship $ */
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 24: insert into AMS_EXP_TEMPLATE (

20: X_LAST_UPDATED_BY in NUMBER,
21: X_LAST_UPDATE_LOGIN in NUMBER
22: ) is
23: begin
24: insert into AMS_EXP_TEMPLATE (
25: SET_CLAUSE,
26: EXPORT_TYPE,
27: EXP_TEMPLATE_ID,
28: LAST_UPDATED_BY,

Line 75: from AMS_EXP_TEMPLATE

71: SEEDED_SELECT_CLAUSE,
72: FROM_CLAUSE,
73: JOIN_CONDITION,
74: EXP_TEMPLATE_ID
75: from AMS_EXP_TEMPLATE
76: where EXP_TEMPLATE_ID = X_EXP_TEMPLATE_ID
77: for update of EXP_TEMPLATE_ID nowait;
78: begin
79: for tlinfo in c1 loop

Line 112: update AMS_EXP_TEMPLATE set

108: X_LAST_UPDATED_BY in NUMBER,
109: X_LAST_UPDATE_LOGIN in NUMBER
110: ) is
111: begin
112: update AMS_EXP_TEMPLATE set
113: SET_CLAUSE = X_SET_CLAUSE,
114: EXPORT_TYPE = X_EXPORT_TYPE,
115: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
116: TEMPLATE_NAME = X_TEMPLATE_NAME,

Line 134: delete from AMS_EXP_TEMPLATE

130: procedure DELETE_ROW (
131: X_EXP_TEMPLATE_ID in NUMBER
132: ) is
133: begin
134: delete from AMS_EXP_TEMPLATE
135: where EXP_TEMPLATE_ID = X_EXP_TEMPLATE_ID;
136:
137: if (sql%notfound) then
138: raise no_data_found;

Line 162: from AMS_EXP_TEMPLATE

158: l_row_id varchar2(100);
159:
160: cursor c_chk_col_exists is
161: select 'x'
162: from AMS_EXP_TEMPLATE
163: where EXP_TEMPLATE_ID = X_EXP_TEMPLATE_ID;
164:
165: cursor c_get_con_com_id is
166: select AMS_EXP_TEMPLATE_S.nextval

Line 166: select AMS_EXP_TEMPLATE_S.nextval

162: from AMS_EXP_TEMPLATE
163: where EXP_TEMPLATE_ID = X_EXP_TEMPLATE_ID;
164:
165: cursor c_get_con_com_id is
166: select AMS_EXP_TEMPLATE_S.nextval
167: from dual;
168:
169:
170: begin

Line 189: AMS_EXP_TEMPLATE_PKG.INSERT_ROW (

185: close c_get_con_com_id;
186: else
187: l_concom_id := X_EXP_TEMPLATE_ID;
188: end if;
189: AMS_EXP_TEMPLATE_PKG.INSERT_ROW (
190: X_ROWID => l_row_id,
191: X_EXP_TEMPLATE_ID => X_EXP_TEMPLATE_ID,
192: X_SET_CLAUSE => X_SET_CLAUSE,
193: X_EXPORT_TYPE => X_EXPORT_TYPE,

Line 208: AMS_EXP_TEMPLATE_PKG.UPDATE_ROW(

204: else
205: close c_chk_col_exists;
206: l_concom_id := X_EXP_TEMPLATE_ID;
207:
208: AMS_EXP_TEMPLATE_PKG.UPDATE_ROW(
209: X_EXP_TEMPLATE_ID => X_EXP_TEMPLATE_ID,
210: X_SET_CLAUSE => X_SET_CLAUSE,
211: X_EXPORT_TYPE => X_EXPORT_TYPE,
212: X_OBJECT_VERSION_NUMBER => l_obj_verno,

Line 223: end AMS_EXP_TEMPLATE_PKG;

219: X_LAST_UPDATE_LOGIN => 0);
220: end if;
221: end LOAD_ROW;
222:
223: end AMS_EXP_TEMPLATE_PKG;