APPS.IBE_MSITE_RESP_PKG dependencies on IBE_MSITE_RESPS_B

Line 34: CURSOR c IS SELECT rowid FROM ibe_msite_resps_b

30: x_rowid OUT NOCOPY VARCHAR2,
31: x_msite_resp_id OUT NOCOPY NUMBER
32: )
33: IS
34: CURSOR c IS SELECT rowid FROM ibe_msite_resps_b
35: WHERE msite_resp_id = x_msite_resp_id;
36: CURSOR c2 IS SELECT ibe_msite_resps_b_s1.nextval FROM dual;
37:
38: BEGIN

Line 36: CURSOR c2 IS SELECT ibe_msite_resps_b_s1.nextval FROM dual;

32: )
33: IS
34: CURSOR c IS SELECT rowid FROM ibe_msite_resps_b
35: WHERE msite_resp_id = x_msite_resp_id;
36: CURSOR c2 IS SELECT ibe_msite_resps_b_s1.nextval FROM dual;
37:
38: BEGIN
39:
40: -- Primary key validation check

Line 51: INSERT INTO ibe_msite_resps_b

47: CLOSE c2;
48: END IF;
49:
50: -- insert base
51: INSERT INTO ibe_msite_resps_b
52: (
53: msite_resp_id,
54: object_version_number,
55: msite_id,

Line 170: UPDATE ibe_msite_resps_b SET

166: IS
167: BEGIN
168:
169: -- update base
170: UPDATE ibe_msite_resps_b SET
171: object_version_number = object_version_number + 1,
172: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
173: start_date_active, p_start_date_active),
174: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,

Line 239: DELETE FROM ibe_msite_resps_b

235: IF (sql%NOTFOUND) THEN
236: RAISE NO_DATA_FOUND;
237: END IF;
238:
239: DELETE FROM ibe_msite_resps_b
240: WHERE msite_resp_id = p_msite_resp_id;
241:
242: IF (sql%NOTFOUND) THEN
243: RAISE NO_DATA_FOUND;

Line 254: FROM ibe_msite_resps_b B

250: BEGIN
251: delete FROM ibe_msite_resps_tl T
252: WHERE NOT EXISTS
253: (SELECT NULL
254: FROM ibe_msite_resps_b B
255: WHERE B.MSITE_RESP_ID = T.MSITE_RESP_ID
256: );
257:
258: UPDATE ibe_msite_resps_tl T SET