APPS.OZF_SD_REQUEST_PUB dependencies on OZF_SD_REQUEST_HEADERS_ALL_TL

Line 2296: INSERT INTO ozf_sd_request_headers_all_tl

2292: x_return_status := FND_API.G_RET_STS_SUCCESS;
2293:
2294: IF p_mode ='CREATE' OR p_mode ='COPY' THEN
2295:
2296: INSERT INTO ozf_sd_request_headers_all_tl
2297: (request_header_id,
2298: last_update_date,
2299: last_updated_by,
2300: creation_date,

Line 2333: FROM ozf_sd_request_headers_all_tl t

2329: p_org_id
2330: FROM fnd_languages l
2331: WHERE l.installed_flag IN('I', 'B')
2332: AND NOT EXISTS(SELECT NULL
2333: FROM ozf_sd_request_headers_all_tl t
2334: WHERE t.request_header_id = p_request_header_id
2335: AND t.language = l.language_code);
2336:
2337: ELSIF p_mode ='UPDATE' THEN

Line 2339: UPDATE ozf_sd_request_headers_all_tl

2335: AND t.language = l.language_code);
2336:
2337: ELSIF p_mode ='UPDATE' THEN
2338:
2339: UPDATE ozf_sd_request_headers_all_tl
2340: SET request_description = p_description
2341: ,org_id = p_org_id
2342: WHERE request_header_id =p_request_header_id;
2343:

Line 3378: FROM ozf_sd_request_headers_all_tl

3374: WHERE request_header_id =p_request_header_id;
3375:
3376: CURSOR c_old_sdr_tl(p_request_header_id IN NUMBER)IS
3377: SELECT request_description
3378: FROM ozf_sd_request_headers_all_tl
3379: WHERE request_header_id = p_request_header_id;
3380:
3381: CURSOR c_admin_check(p_resource_id IN NUMBER)IS
3382: SELECT jrgm.group_member_id

Line 4483: FROM ozf_sd_request_headers_all_tl

4479: WHERE request_header_id = p_request_header_id;
4480:
4481: CURSOR c_tl_description(p_request_header_id IN NUMBER)IS
4482: SELECT request_description
4483: FROM ozf_sd_request_headers_all_tl
4484: WHERE request_header_id = p_request_header_id;
4485:
4486: CURSOR c_product_flag_check(p_request_header_id IN NUMBER)IS
4487: SELECT COUNT(1)