APPS.IBC_FILE_EXTN_MAPPINGS_PKG dependencies on IBC_FILE_EXTN_MAPPINGS_B

Line 15: cursor C is select ROWID from IBC_FILE_EXTN_MAPPINGS_B

11: X_LAST_UPDATE_DATE in DATE,
12: X_LAST_UPDATED_BY in NUMBER,
13: X_LAST_UPDATE_LOGIN in NUMBER
14: ) is
15: cursor C is select ROWID from IBC_FILE_EXTN_MAPPINGS_B
16: where MAPPING_ID = X_MAPPING_ID
17: ;
18: begin
19: insert into IBC_FILE_EXTN_MAPPINGS_B (

Line 19: insert into IBC_FILE_EXTN_MAPPINGS_B (

15: cursor C is select ROWID from IBC_FILE_EXTN_MAPPINGS_B
16: where MAPPING_ID = X_MAPPING_ID
17: ;
18: begin
19: insert into IBC_FILE_EXTN_MAPPINGS_B (
20: MAPPING_ID,
21: CONTENT_TYPE_CODE,
22: CREATION_DATE,
23: CREATED_BY,

Line 85: from IBC_FILE_EXTN_MAPPINGS_B

81: X_DESCRIPTION in VARCHAR2
82: ) is
83: cursor c is select
84: CONTENT_TYPE_CODE
85: from IBC_FILE_EXTN_MAPPINGS_B
86: where MAPPING_ID = X_MAPPING_ID
87: for update of MAPPING_ID nowait;
88: recinfo c%rowtype;
89:

Line 141: update IBC_FILE_EXTN_MAPPINGS_B set

137: X_LAST_UPDATED_BY in NUMBER,
138: X_LAST_UPDATE_LOGIN in NUMBER
139: ) is
140: begin
141: update IBC_FILE_EXTN_MAPPINGS_B set
142: CONTENT_TYPE_CODE = X_CONTENT_TYPE_CODE,
143: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
144: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
145: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 178: delete from IBC_FILE_EXTN_MAPPINGS_B

174: if (sql%notfound) then
175: raise no_data_found;
176: end if;
177:
178: delete from IBC_FILE_EXTN_MAPPINGS_B
179: where MAPPING_ID = X_MAPPING_ID;
180:
181: if (sql%notfound) then
182: raise no_data_found;

Line 192: from IBC_FILE_EXTN_MAPPINGS_B B

188: begin
189: delete from IBC_FILE_EXTN_MAPPINGS_TL T
190: where not exists
191: (select NULL
192: from IBC_FILE_EXTN_MAPPINGS_B B
193: where B.MAPPING_ID = T.MAPPING_ID
194: );
195:
196: update IBC_FILE_EXTN_MAPPINGS_TL T set (

Line 306: FROM IBC_FILE_EXTN_MAPPINGS_B

302: l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);
303:
304: -- get updatedby and update_date values if existing in db
305: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE INTO db_user_id, db_last_update_date
306: FROM IBC_FILE_EXTN_MAPPINGS_B
307: WHERE MAPPING_ID = p_mapping_id;
308:
309: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
310: db_user_id, db_last_update_date, p_upload_mode )) THEN