APPS.OZF_SD_REQUEST_PUB dependencies on OZF_SD_REQUEST_HEADERS_ALL_TL

Line 2827: INSERT INTO ozf_sd_request_headers_all_tl

2823: x_return_status := FND_API.G_RET_STS_SUCCESS;
2824:
2825: IF p_mode ='CREATE' OR p_mode ='COPY' THEN
2826:
2827: INSERT INTO ozf_sd_request_headers_all_tl
2828: (request_header_id,
2829: last_update_date,
2830: last_updated_by,
2831: creation_date,

Line 2864: FROM ozf_sd_request_headers_all_tl t

2860: p_org_id
2861: FROM fnd_languages l
2862: WHERE l.installed_flag IN('I', 'B')
2863: AND NOT EXISTS(SELECT NULL
2864: FROM ozf_sd_request_headers_all_tl t
2865: WHERE t.request_header_id = p_request_header_id
2866: AND t.language = l.language_code);
2867:
2868: ELSIF p_mode ='UPDATE' THEN

Line 2870: UPDATE ozf_sd_request_headers_all_tl

2866: AND t.language = l.language_code);
2867:
2868: ELSIF p_mode ='UPDATE' THEN
2869:
2870: UPDATE ozf_sd_request_headers_all_tl
2871: SET request_description = p_description
2872: ,org_id = p_org_id
2873: WHERE request_header_id =p_request_header_id;
2874:

Line 3951: FROM ozf_sd_request_headers_all_tl

3947: WHERE request_header_id =p_request_header_id;
3948:
3949: CURSOR c_old_sdr_tl(p_request_header_id IN NUMBER)IS
3950: SELECT request_description
3951: FROM ozf_sd_request_headers_all_tl
3952: WHERE request_header_id = p_request_header_id;
3953:
3954: CURSOR c_admin_check(p_resource_id IN NUMBER)IS
3955: SELECT jrgm.group_member_id

Line 5067: FROM ozf_sd_request_headers_all_tl

5063: WHERE request_header_id = p_request_header_id;
5064:
5065: CURSOR c_tl_description(p_request_header_id IN NUMBER)IS
5066: SELECT request_description
5067: FROM ozf_sd_request_headers_all_tl
5068: WHERE request_header_id = p_request_header_id;
5069:
5070: CURSOR c_product_flag_check(p_request_header_id IN NUMBER)IS
5071: SELECT COUNT(1)