APPS.AMS_IMP_COL_MAPPING_PKG dependencies on AMS_IMP_COL_MAPPING

Line 1: package body AMS_IMP_COL_MAPPING_PKG as

1: package body AMS_IMP_COL_MAPPING_PKG as
2: /* $Header: amslccmb.pls 115.7 2004/04/07 21:22:10 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_COL_MAPPING (

18: X_LAST_UPDATED_BY in NUMBER,
19: X_LAST_UPDATE_LOGIN in NUMBER
20: ) is
21: begin
22: insert into AMS_IMP_COL_MAPPING (
23: TABLE_NAME,
24: COLUMN_NAME,
25: MEANING,
26: REQUIRED_FLAG,

Line 67: from AMS_IMP_COL_MAPPING

63: MEANING,
64: REQUIRED_FLAG,
65: TARGET_TABLE_NAME,
66: COL_MAPPING_ID
67: from AMS_IMP_COL_MAPPING
68: where COL_MAPPING_ID = X_COL_MAPPING_ID
69: for update of COL_MAPPING_ID nowait;
70: begin
71: for tlinfo in c1 loop

Line 101: update AMS_IMP_COL_MAPPING set

97: X_LAST_UPDATED_BY in NUMBER,
98: X_LAST_UPDATE_LOGIN in NUMBER
99: ) is
100: begin
101: update AMS_IMP_COL_MAPPING set
102: TABLE_NAME = X_TABLE_NAME,
103: COLUMN_NAME = X_COLUMN_NAME,
104: MEANING = X_MEANING,
105: REQUIRED_FLAG = X_REQUIRED_FLAG,

Line 122: delete from AMS_IMP_COL_MAPPING

118: procedure DELETE_ROW (
119: X_COL_MAPPING_ID in NUMBER
120: ) is
121: begin
122: delete from AMS_IMP_COL_MAPPING
123: where COL_MAPPING_ID = X_COL_MAPPING_ID;
124:
125: if (sql%notfound) then
126: raise no_data_found;

Line 154: from AMS_IMP_COL_MAPPING

150: l_row_id varchar2(100);
151:
152: cursor c_chk_col_exists is
153: select 'x'
154: from AMS_IMP_COL_MAPPING
155: where COL_MAPPING_ID = X_COL_MAPPING_ID;
156:
157: cursor c_get_col_mapping_id is
158: select AMS_IMP_COL_MAPPING_s.nextval

Line 158: select AMS_IMP_COL_MAPPING_s.nextval

154: from AMS_IMP_COL_MAPPING
155: where COL_MAPPING_ID = X_COL_MAPPING_ID;
156:
157: cursor c_get_col_mapping_id is
158: select AMS_IMP_COL_MAPPING_s.nextval
159: from dual;
160:
161: BEGIN
162: if X_OWNER = 'SEED' then

Line 178: AMS_IMP_COL_MAPPING_PKG.INSERT_ROW (

174: close c_get_col_mapping_id;
175: else
176: l_colmap_id := X_COL_MAPPING_ID;
177: end if;
178: AMS_IMP_COL_MAPPING_PKG.INSERT_ROW (
179: X_ROWID => l_row_id,
180: X_COL_MAPPING_ID => X_COL_MAPPING_ID,
181: X_TABLE_NAME => X_TABLE_NAME,
182: X_COLUMN_NAME => X_COLUMN_NAME,

Line 196: AMS_IMP_COL_MAPPING_PKG.UPDATE_ROW (

192: else
193: close c_chk_col_exists;
194: l_colmap_id := X_COL_MAPPING_ID ;
195:
196: AMS_IMP_COL_MAPPING_PKG.UPDATE_ROW (
197: X_COL_MAPPING_ID => X_COL_MAPPING_ID,
198: X_TABLE_NAME => X_TABLE_NAME,
199: X_COLUMN_NAME => X_COLUMN_NAME,
200: X_MEANING => X_MEANING ,

Line 211: end AMS_IMP_COL_MAPPING_PKG;

207: end if;
208:
209: end LOAD_ROW;
210:
211: end AMS_IMP_COL_MAPPING_PKG;