APPS.OZF_SD_REQUEST_PUB dependencies on OZF_SD_REQUEST_HEADERS_ALL_B

Line 672: FROM ozf_sd_request_headers_all_b

668: AND org_id = p_org_id;
669:
670: CURSOR c_request_header_id_count(p_request_header_id IN VARCHAR2)IS
671: SELECT COUNT(1)
672: FROM ozf_sd_request_headers_all_b
673: WHERE request_header_id = p_request_header_id;
674:
675: CURSOR c_request_number_count(p_request_number IN VARCHAR2)IS
676: SELECT COUNT(1)

Line 677: FROM ozf_sd_request_headers_all_b

673: WHERE request_header_id = p_request_header_id;
674:
675: CURSOR c_request_number_count(p_request_number IN VARCHAR2)IS
676: SELECT COUNT(1)
677: FROM ozf_sd_request_headers_all_b
678: WHERE request_number =p_request_number;
679:
680: CURSOR c_system_status_code(p_user_status_id IN VARCHAR2)IS
681: SELECT system_status_code

Line 2678: SELECT OZF_SD_REQUEST_HEADERS_ALL_B_S.nextval

2674: --l_request_source VARCHAR2(30) :='API';
2675: l_root_request_header_id NUMBER;
2676:
2677: CURSOR c_reqest_header_seq IS
2678: SELECT OZF_SD_REQUEST_HEADERS_ALL_B_S.nextval
2679: FROM dual;
2680:
2681: CURSOR c_code_prefix(p_request_type_setup_id IN NUMBER) IS
2682: SELECT source_code_suffix

Line 3292: FROM ozf_sd_request_headers_all_b

3288:
3289:
3290: CURSOR c_qp_list_header_id(p_request_header_id IN NUMBER)IS
3291: SELECT offer_id
3292: FROM ozf_sd_request_headers_all_b
3293: WHERE request_header_id =p_request_header_id;
3294: /*
3295: --//To check the offer status
3296: CURSOR c_offer_status_code (p_qp_list_header_id IN NUMBER)IS

Line 3454: FROM ozf_sd_request_headers_all_b

3450: AND custom_setup_id = p_request_type_setup_id;
3451:
3452: CURSOR c_request_number(p_request_number IN VARCHAR2)IS
3453: SELECT request_number
3454: FROM ozf_sd_request_headers_all_b
3455: WHERE request_number =p_request_number;
3456:
3457: BEGIN
3458: -- Standard Start of API savepoint

Line 3946: FROM ozf_sd_Request_headers_all_b

3942: supplier_contact_phone_number,
3943: request_type_setup_id,
3944: request_basis,
3945: supplier_contact_name --//Bugfix : 7822442
3946: FROM ozf_sd_Request_headers_all_b
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

Line 3985: FROM ozf_sd_request_headers_all_b

3981: AND user_id = p_user_id;
3982:
3983: CURSOR c_request_header_id(p_request_header_id IN VARCHAR2)IS
3984: SELECT request_header_id
3985: FROM ozf_sd_request_headers_all_b
3986: WHERE request_header_id = p_request_header_id;
3987:
3988: CURSOR c_request_number(p_request_number IN VARCHAR2)IS
3989: SELECT request_number

Line 3990: FROM ozf_sd_request_headers_all_b

3986: WHERE request_header_id = p_request_header_id;
3987:
3988: CURSOR c_request_number(p_request_number IN VARCHAR2)IS
3989: SELECT request_number
3990: FROM ozf_sd_request_headers_all_b
3991: WHERE request_number =p_request_number;
3992:
3993: CURSOR c_user_status_name(p_user_status_id IN NUMBER)IS
3994: SELECT name

Line 4006: FROM ozf_sd_request_headers_all_b

4002: AND supplier_site_id =p_supplier_site_id;
4003:
4004: CURSOR c_qp_list_header_id(p_request_header_id IN NUMBER)IS
4005: SELECT offer_id
4006: FROM ozf_sd_request_headers_all_b
4007: WHERE request_header_id =p_request_header_id;
4008:
4009: BEGIN
4010: -- Standard Start of API savepoint

Line 4848: UPDATE ozf_sd_request_headers_all_b

4844: END IF;
4845:
4846: IF l_new_status_code ='PENDING_OFFER_APPROVAL' THEN
4847: --//Updating SD Request Header table with offer information
4848: UPDATE ozf_sd_request_headers_all_b
4849: SET offer_id = l_qp_list_header_id,
4850: offer_type = 'ACCRUAL'
4851: WHERE request_header_id = p_SDR_hdr_rec.request_header_id;
4852: END IF;

Line 5014: FROM ozf_sd_request_headers_all_b

5010: l_resource_id NUMBER;
5011:
5012: CURSOR c_source_request_header_id(p_request_header_id IN NUMBER)IS
5013: SELECT request_header_id
5014: FROM ozf_sd_request_headers_all_b
5015: WHERE request_header_id = p_request_header_id;
5016:
5017: CURSOR c_new_request_no(p_request_number IN VARCHAR2)IS
5018: SELECT request_number

Line 5019: FROM ozf_sd_request_headers_all_b

5015: WHERE request_header_id = p_request_header_id;
5016:
5017: CURSOR c_new_request_no(p_request_number IN VARCHAR2)IS
5018: SELECT request_number
5019: FROM ozf_sd_request_headers_all_b
5020: WHERE request_number = p_request_number;
5021:
5022: CURSOR c_cust_account_id(p_cust_account_id IN NUMBER) IS
5023: SELECT cust_account_id

Line 5062: FROM ozf_sd_request_headers_all_b

5058: supplier_contact_phone_number,
5059: request_type_setup_id,
5060: request_basis,
5061: supplier_contact_name --//Bugfix : 7822442
5062: FROM ozf_sd_request_headers_all_b
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