APPS.JTF_MSITE_RESP_PKG dependencies on JTF_MSITE_RESPS_B

Line 28: CURSOR c IS SELECT rowid FROM jtf_msite_resps_b

24: x_rowid OUT VARCHAR2,
25: x_msite_resp_id OUT NUMBER
26: )
27: IS
28: CURSOR c IS SELECT rowid FROM jtf_msite_resps_b
29: WHERE msite_resp_id = x_msite_resp_id;
30: CURSOR c2 IS SELECT jtf_msite_resps_b_s1.nextval FROM dual;
31:
32: BEGIN

Line 30: CURSOR c2 IS SELECT jtf_msite_resps_b_s1.nextval FROM dual;

26: )
27: IS
28: CURSOR c IS SELECT rowid FROM jtf_msite_resps_b
29: WHERE msite_resp_id = x_msite_resp_id;
30: CURSOR c2 IS SELECT jtf_msite_resps_b_s1.nextval FROM dual;
31:
32: BEGIN
33:
34: -- Primary key validation check

Line 45: INSERT INTO jtf_msite_resps_b

41: CLOSE c2;
42: END IF;
43:
44: -- insert base
45: INSERT INTO jtf_msite_resps_b
46: (
47: msite_resp_id,
48: object_version_number,
49: msite_id,

Line 162: UPDATE jtf_msite_resps_b SET

158: IS
159: BEGIN
160:
161: -- update base
162: UPDATE jtf_msite_resps_b SET
163: object_version_number = object_version_number + 1,
164: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
165: start_date_active, p_start_date_active),
166: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,

Line 231: DELETE FROM jtf_msite_resps_b

227: IF (sql%NOTFOUND) THEN
228: RAISE NO_DATA_FOUND;
229: END IF;
230:
231: DELETE FROM jtf_msite_resps_b
232: WHERE msite_resp_id = p_msite_resp_id;
233:
234: IF (sql%NOTFOUND) THEN
235: RAISE NO_DATA_FOUND;

Line 246: FROM jtf_msite_resps_b B

242: BEGIN
243: delete FROM jtf_msite_resps_tl T
244: WHERE NOT EXISTS
245: (SELECT NULL
246: FROM jtf_msite_resps_b B
247: WHERE B.MSITE_RESP_ID = T.MSITE_RESP_ID
248: );
249:
250: UPDATE jtf_msite_resps_tl T SET