eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OZF_OFFER_PVT dependencies on OZF_SD_REQUEST_HEADERS_ALL_B

Line 3885: FROM ozf_sd_request_headers_all_b sdr, ozf_offers off

3881: -- nepanda : end : fix for bug 8507709
3882: -- fix for bug 7004273 and 7201785
3883: CURSOR c_sd_req_header_rec(p_offer_id IN NUMBER) IS
3884: SELECT sdr.object_version_number, sdr.request_header_id
3885: FROM ozf_sd_request_headers_all_b sdr, ozf_offers off
3886: --WHERE nvl(sdr.authorization_number,sdr.request_number) = off.offer_code
3887: WHERE sdr.request_number = off.offer_code
3888: AND off.qp_list_header_id = p_offer_id
3889: AND sdr.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS', 'PENDING_OFFER_APPROVAL');

Line 4092: -- update ozf_sd_request_headers_all_b update activating

4088: ozf_utility_pvt.write_conc_log('p_offer_rec.qp_list_header_id '||p_offer_rec.qp_list_header_id);
4089:
4090:
4091: IF p_offer_rec.custom_setup_id = 118 THEN -- SD offers
4092: -- update ozf_sd_request_headers_all_b update activating
4093: OPEN c_sd_req_header_rec(p_offer_rec.qp_list_header_id);
4094: FETCH c_sd_req_header_rec INTO l_obj_ver_num , l_sdr_req_header_id;
4095: CLOSE c_sd_req_header_rec;
4096:

Line 4102: UPDATE ozf_sd_request_headers_all_b

4098: ozf_utility_pvt.write_conc_log('l_sdr_req_header_id '|| l_sdr_req_header_id);
4099:
4100: --fix for bug 7004273
4101:
4102: UPDATE ozf_sd_request_headers_all_b
4103: SET user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS', 'ACTIVE') ,
4104: object_version_number = l_obj_ver_num + 1
4105: WHERE request_header_id = l_sdr_req_header_id;
4106: END IF;

Line 6836: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','ACTIVE')

6832:
6833: IF p_new_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','ACTIVE')
6834: AND l_offer_rec.CUSTOM_SETUP_ID = 118 THEN
6835:
6836: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','ACTIVE')
6837: where offer_id= l_offer_rec.qp_list_header_id;
6838:
6839: END IF;
6840:

Line 6856: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','OFFER_REJECTED')

6852: IF l_offer_rec.CUSTOM_SETUP_ID = 118 THEN
6853: IF p_new_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','DENIED_TA')
6854: OR p_new_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','REJECTED') THEN
6855:
6856: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','OFFER_REJECTED')
6857: where offer_id= l_offer_rec.qp_list_header_id;
6858:
6859: END IF;
6860:

Line 10214: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','OFFER_REJECTED')

10210: IF p_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','DENIED_TA')
10211: OR p_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','REJECTED') THEN --
10212:
10213:
10214: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','OFFER_REJECTED')
10215: where offer_id=p_modifier_list_rec.qp_list_header_id;
10216:
10217: ELSIF p_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','ACTIVE') THEN
10218:

Line 10219: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','ACTIVE')

10215: where offer_id=p_modifier_list_rec.qp_list_header_id;
10216:
10217: ELSIF p_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','ACTIVE') THEN
10218:
10219: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','ACTIVE')
10220: where offer_id= p_modifier_list_rec.qp_list_header_id;
10221:
10222: END IF;
10223: END IF;

Line 11124: FROM ozf_sd_request_headers_all_b

11120:
11121:
11122: CURSOR c_get_supplier_site_id(l_sdr_header_id NUMBER) IS
11123: SELECT supplier_site_id
11124: FROM ozf_sd_request_headers_all_b
11125: WHERE request_header_id = l_sdr_header_id;
11126:
11127:
11128:

Line 11198: FROM ozf_sd_request_headers_all_b

11194: request_number,
11195: asignee_resource_id,
11196: request_basis,
11197: org_id
11198: FROM ozf_sd_request_headers_all_b
11199: WHERE request_header_id = l_sdr_header_id;
11200:
11201:
11202: l_modifier_list_rec Modifier_LIST_Rec_Type;

Line 11397: FROM ozf_sd_request_headers_all_b

11393: CURSOR cur_get_header_info IS
11394: SELECT sales_order_currency,
11395: request_currency_code,
11396: supplier_site_id
11397: FROM ozf_sd_request_headers_all_b
11398: WHERE request_header_id = p_sdr_header_id;
11399:
11400: CURSOR cur_get_qty_inc_flag(p_supplier_site_id NUMBER) IS
11401: SELECT allow_qty_increase

Line 11707: FROM ozf_sd_request_headers_all_b

11703: AND qualifier_attribute = 'QUALIFIER_ATTRIBUTE21'));
11704:
11705: CURSOR cur_get_internal_order_number IS
11706: SELECT internal_order_number,org_id
11707: FROM ozf_sd_request_headers_all_b
11708: WHERE request_header_id = p_sdr_header_id;
11709:
11710:
11711: CURSOR cur_get_order_header_id (p_internal_order_number NUMBER,p_org_id NUMBER)IS

Line 12175: FROM ozf_sd_request_headers_all_b

12171: AND system_status_code=l_new_status;
12172:
12173: CURSOR c_sdr_info(l_sdr_hdr_id NUMBER) IS
12174: SELECT accrual_type,cust_account_id,supplier_site_id
12175: FROM ozf_sd_request_headers_all_b
12176: WHERE request_header_id=l_sdr_hdr_id;
12177:
12178: CURSOR c_supp_trd_prfl_info(l_supplier_site_id NUMBER) IS
12179: SELECT cust_account_id, site_use_id

Line 12224: FROM OZF_SD_REQUEST_HEADERS_ALL_B

12220: AND arc_user_or_role_type = 'USER';
12221:
12222: CURSOR c_get_sdr_status(p_sdr_header_id NUMBER) IS
12223: SELECT user_status_id
12224: FROM OZF_SD_REQUEST_HEADERS_ALL_B
12225: WHERE request_header_id=p_sdr_header_id;
12226:
12227: CURSOR cur_is_theme_appr_req(p_custom_setup_id NUMBER) IS
12228: SELECT attr_available_flag

Line 12639: update ozf_sd_request_headers_all_b

12635: /*IF l_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','ACTIVE') THEN
12636:
12637: debug_message('p_sdr_header_id1111 = '|| p_sdr_header_id);
12638:
12639: update ozf_sd_request_headers_all_b
12640: set user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','ACTIVE')
12641: where request_header_id = p_sdr_header_id;
12642:
12643: END IF;*/