APPS.AMS_IMP_LIST_IMPORT_TYPES_PKG dependencies on AMS_IMP_LIST_IMPORT_TYPES

Line 1: package body AMS_IMP_LIST_IMPORT_TYPES_PKG as

1: package body AMS_IMP_LIST_IMPORT_TYPES_PKG as
2: /* $Header: amsilmtb.pls 115.6 2004/04/07 21:52:13 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 22: insert into AMS_IMP_LIST_IMPORT_TYPES (

18: X_LAST_UPDATED_BY in NUMBER,
19: X_LAST_UPDATE_LOGIN in NUMBER
20: ) is
21: begin
22: insert into AMS_IMP_LIST_IMPORT_TYPES (
23: IMPORT_TYPE_ID,
24: LAST_UPDATE_DATE,
25: LAST_UPDATED_BY,
26: CREATION_DATE,

Line 67: from AMS_IMP_LIST_IMPORT_TYPES

63: VIEW_NAME,
64: B2B_FLAG,
65: CONCURRENT_PROGRAM,
66: WORKBOOK_NAME
67: from AMS_IMP_LIST_IMPORT_TYPES
68: where IMPORT_TYPE_ID = X_IMPORT_TYPE_ID
69: for update of IMPORT_TYPE_ID nowait;
70:
71: begin

Line 106: update AMS_IMP_LIST_IMPORT_TYPES set

102: X_LAST_UPDATED_BY in NUMBER,
103: X_LAST_UPDATE_LOGIN in NUMBER
104: ) is
105: begin
106: update AMS_IMP_LIST_IMPORT_TYPES set
107: IMPORT_TYPE = X_IMPORT_TYPE,
108: VIEW_NAME = X_VIEW_NAME,
109: B2B_FLAG = X_B2B_FLAG,
110: CONCURRENT_PROGRAM = X_CONCURRENT_PROGRAM,

Line 127: delete from AMS_IMP_LIST_IMPORT_TYPES

123: procedure DELETE_ROW (
124: X_IMPORT_TYPE_ID in NUMBER
125: ) is
126: begin
127: delete from AMS_IMP_LIST_IMPORT_TYPES
128: where IMPORT_TYPE_ID = X_IMPORT_TYPE_ID;
129:
130: if (sql%notfound) then
131: raise no_data_found;

Line 158: from ams_imp_list_import_types

154: l_row_id varchar2(100);
155:
156: cursor c_chk_col_exists is
157: select 'x'
158: from ams_imp_list_import_types
159: where IMPORT_TYPE_ID = X_IMPORT_TYPE_ID;
160:
161: cursor c_get_import_type_id is
162: select ams_imp_list_import_types_s.nextval

Line 162: select ams_imp_list_import_types_s.nextval

158: from ams_imp_list_import_types
159: where IMPORT_TYPE_ID = X_IMPORT_TYPE_ID;
160:
161: cursor c_get_import_type_id is
162: select ams_imp_list_import_types_s.nextval
163: from dual;
164: BEGIN
165: if X_OWNER = 'SEED' then
166: l_user_id := 1;

Line 182: AMS_IMP_LIST_IMPORT_TYPES_PKG.INSERT_ROW (

178: close c_get_import_type_id;
179: else
180: l_imptype_id := X_IMPORT_TYPE_ID;
181: end if;
182: AMS_IMP_LIST_IMPORT_TYPES_PKG.INSERT_ROW (
183: X_ROWID => l_row_id,
184: X_IMPORT_TYPE_ID => X_IMPORT_TYPE_ID,
185: X_IMPORT_TYPE => X_IMPORT_TYPE,
186: X_VIEW_NAME => X_VIEW_NAME,

Line 199: AMS_IMP_LIST_IMPORT_TYPES_PKG.UPDATE_ROW (

195:
196: else
197: close c_chk_col_exists;
198: l_imptype_id := X_IMPORT_TYPE_ID;
199: AMS_IMP_LIST_IMPORT_TYPES_PKG.UPDATE_ROW (
200: X_IMPORT_TYPE_ID => X_IMPORT_TYPE_ID,
201: X_IMPORT_TYPE => X_IMPORT_TYPE,
202: X_VIEW_NAME => X_VIEW_NAME,
203: X_B2B_FLAG => X_B2B_FLAG,

Line 213: end AMS_IMP_LIST_IMPORT_TYPES_PKG;

209: end if;
210:
211: end LOAD_ROW;
212:
213: end AMS_IMP_LIST_IMPORT_TYPES_PKG;
214: