APPS.OZF_SD_REQUEST_PUB dependencies on OZF_SD_REQUEST_HEADERS_ALL_B

Line 493: FROM ozf_sd_request_headers_all_b

489: AND org_id = p_org_id;
490:
491: CURSOR c_request_header_id_count(p_request_header_id IN VARCHAR2)IS
492: SELECT COUNT(1)
493: FROM ozf_sd_request_headers_all_b
494: WHERE request_header_id = p_request_header_id;
495:
496: CURSOR c_request_number_count(p_request_number IN VARCHAR2)IS
497: SELECT COUNT(1)

Line 498: FROM ozf_sd_request_headers_all_b

494: WHERE request_header_id = p_request_header_id;
495:
496: CURSOR c_request_number_count(p_request_number IN VARCHAR2)IS
497: SELECT COUNT(1)
498: FROM ozf_sd_request_headers_all_b
499: WHERE request_number =p_request_number;
500:
501: CURSOR c_system_status_code(p_user_status_id IN VARCHAR2)IS
502: SELECT system_status_code

Line 2147: SELECT OZF_SD_REQUEST_HEADERS_ALL_B_S.nextval

2143: --l_request_source VARCHAR2(30) :='API';
2144: l_root_request_header_id NUMBER;
2145:
2146: CURSOR c_reqest_header_seq IS
2147: SELECT OZF_SD_REQUEST_HEADERS_ALL_B_S.nextval
2148: FROM dual;
2149:
2150: CURSOR c_code_prefix(p_request_type_setup_id IN NUMBER) IS
2151: SELECT source_code_suffix

Line 2719: FROM ozf_sd_request_headers_all_b

2715:
2716:
2717: CURSOR c_qp_list_header_id(p_request_header_id IN NUMBER)IS
2718: SELECT offer_id
2719: FROM ozf_sd_request_headers_all_b
2720: WHERE request_header_id =p_request_header_id;
2721: /*
2722: --//To check the offer status
2723: CURSOR c_offer_status_code (p_qp_list_header_id IN NUMBER)IS

Line 2881: FROM ozf_sd_request_headers_all_b

2877: AND custom_setup_id = p_request_type_setup_id;
2878:
2879: CURSOR c_request_number(p_request_number IN VARCHAR2)IS
2880: SELECT request_number
2881: FROM ozf_sd_request_headers_all_b
2882: WHERE request_number =p_request_number;
2883:
2884: BEGIN
2885: -- Standard Start of API savepoint

Line 3373: FROM ozf_sd_Request_headers_all_b

3369: supplier_contact_phone_number,
3370: request_type_setup_id,
3371: request_basis,
3372: supplier_contact_name --//Bugfix : 7822442
3373: FROM ozf_sd_Request_headers_all_b
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

Line 3415: FROM ozf_sd_request_headers_all_b

3411: AND user_id = p_user_id;
3412:
3413: CURSOR c_request_header_id(p_request_header_id IN VARCHAR2)IS
3414: SELECT request_header_id
3415: FROM ozf_sd_request_headers_all_b
3416: WHERE request_header_id = p_request_header_id;
3417:
3418: CURSOR c_request_number(p_request_number IN VARCHAR2)IS
3419: SELECT request_number

Line 3420: FROM ozf_sd_request_headers_all_b

3416: WHERE request_header_id = p_request_header_id;
3417:
3418: CURSOR c_request_number(p_request_number IN VARCHAR2)IS
3419: SELECT request_number
3420: FROM ozf_sd_request_headers_all_b
3421: WHERE request_number =p_request_number;
3422:
3423: CURSOR c_user_status_name(p_user_status_id IN NUMBER)IS
3424: SELECT name

Line 3436: FROM ozf_sd_request_headers_all_b

3432: AND supplier_site_id =p_supplier_site_id;
3433:
3434: CURSOR c_qp_list_header_id(p_request_header_id IN NUMBER)IS
3435: SELECT offer_id
3436: FROM ozf_sd_request_headers_all_b
3437: WHERE request_header_id =p_request_header_id;
3438:
3439: BEGIN
3440: -- Standard Start of API savepoint

Line 4264: UPDATE ozf_sd_request_headers_all_b

4260: END IF;
4261:
4262: IF l_new_status_code ='PENDING_OFFER_APPROVAL' THEN
4263: --//Updating SD Request Header table with offer information
4264: UPDATE ozf_sd_request_headers_all_b
4265: SET offer_id = l_qp_list_header_id,
4266: offer_type = 'ACCRUAL'
4267: WHERE request_header_id = p_SDR_hdr_rec.request_header_id;
4268: END IF;

Line 4430: FROM ozf_sd_request_headers_all_b

4426: l_resource_id NUMBER;
4427:
4428: CURSOR c_source_request_header_id(p_request_header_id IN NUMBER)IS
4429: SELECT request_header_id
4430: FROM ozf_sd_request_headers_all_b
4431: WHERE request_header_id = p_request_header_id;
4432:
4433: CURSOR c_new_request_no(p_request_number IN VARCHAR2)IS
4434: SELECT request_number

Line 4435: FROM ozf_sd_request_headers_all_b

4431: WHERE request_header_id = p_request_header_id;
4432:
4433: CURSOR c_new_request_no(p_request_number IN VARCHAR2)IS
4434: SELECT request_number
4435: FROM ozf_sd_request_headers_all_b
4436: WHERE request_number = p_request_number;
4437:
4438: CURSOR c_cust_account_id(p_cust_account_id IN NUMBER) IS
4439: SELECT cust_account_id

Line 4478: FROM ozf_sd_request_headers_all_b

4474: supplier_contact_phone_number,
4475: request_type_setup_id,
4476: request_basis,
4477: supplier_contact_name --//Bugfix : 7822442
4478: FROM ozf_sd_request_headers_all_b
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