APPS.JTF_MSITE_RESP_PVT dependencies on JTF_MSITE_RESPS_B

Line 153: IS SELECT msite_resp_id FROM jtf_msite_resps_b

149: l_api_version CONSTANT NUMBER := 1.0;
150: l_tmp_id NUMBER;
151:
152: CURSOR c1(l_c_msite_resp_id IN NUMBER)
153: IS SELECT msite_resp_id FROM jtf_msite_resps_b
154: WHERE msite_resp_id = l_c_msite_resp_id;
155:
156: CURSOR c2(l_c_msite_id IN NUMBER, l_c_responsibility_id IN NUMBER,
157: l_c_application_id IN NUMBER)

Line 158: IS SELECT msite_resp_id FROM jtf_msite_resps_b

154: WHERE msite_resp_id = l_c_msite_resp_id;
155:
156: CURSOR c2(l_c_msite_id IN NUMBER, l_c_responsibility_id IN NUMBER,
157: l_c_application_id IN NUMBER)
158: IS SELECT msite_resp_id FROM jtf_msite_resps_b
159: WHERE msite_id = l_c_msite_id
160: AND responsibility_id = l_c_responsibility_id
161: AND application_id = l_c_application_id;
162:

Line 169: -- application_id exists in jtf_msite_resps_b

165: -- Initialize status to SUCCESS
166: x_return_status := FND_API.G_RET_STS_SUCCESS;
167:
168: -- Check if msite_resp_id or combination of msite_id, responsibility_id,
169: -- application_id exists in jtf_msite_resps_b
170: IF ((p_msite_resp_id IS NOT NULL) AND
171: (p_msite_resp_id <> FND_API.G_MISS_NUM))
172: THEN
173:

Line 762: IS SELECT msite_resp_id FROM jtf_msite_resps_b

758: l_msite_resp_id NUMBER;
759:
760: CURSOR c1(l_c_msite_id IN NUMBER, l_c_responsibility_id IN NUMBER,
761: l_c_application_id IN NUMBER)
762: IS SELECT msite_resp_id FROM jtf_msite_resps_b
763: WHERE msite_id = l_c_msite_id
764: AND responsibility_id = l_c_responsibility_id
765: AND application_id = l_c_application_id;
766:

Line 952: IS SELECT msite_resp_id FROM jtf_msite_resps_b

948: l_msite_resp_id NUMBER;
949:
950: CURSOR c1(l_c_msite_id IN NUMBER, l_c_responsibility_id IN NUMBER,
951: l_c_application_id IN NUMBER)
952: IS SELECT msite_resp_id FROM jtf_msite_resps_b
953: WHERE msite_id = l_c_msite_id
954: AND responsibility_id = l_c_responsibility_id
955: AND application_id = l_c_application_id;
956:

Line 1018: -- delete for jtf_msite_resps_b and _tl tables

1014: FND_MSG_PUB.Add;
1015: RAISE FND_API.G_EXC_ERROR;
1016: END IF;
1017:
1018: -- delete for jtf_msite_resps_b and _tl tables
1019: BEGIN
1020: Jtf_Msite_Resp_Pkg.delete_row(l_msite_resp_id);
1021: EXCEPTION
1022: WHEN NO_DATA_FOUND THEN