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.

APPS.OZF_OFFER_PVT dependencies on OZF_SD_REQUEST_HEADERS_ALL_B

Line 3710: FROM ozf_sd_request_headers_all_b sdr, ozf_offers off

3706:
3707: -- fix for bug 7004273 and 7201785
3708: CURSOR c_sd_req_header_rec(p_offer_id IN NUMBER) IS
3709: SELECT sdr.object_version_number, sdr.request_header_id
3710: FROM ozf_sd_request_headers_all_b sdr, ozf_offers off
3711: --WHERE nvl(sdr.authorization_number,sdr.request_number) = off.offer_code
3712: WHERE sdr.request_number = off.offer_code
3713: AND off.qp_list_header_id = p_offer_id
3714: AND sdr.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS', 'PENDING_OFFER_APPROVAL');

Line 3911: -- update ozf_sd_request_headers_all_b update activating

3907: ozf_utility_pvt.write_conc_log('p_offer_rec.qp_list_header_id '||p_offer_rec.qp_list_header_id);
3908:
3909:
3910: IF p_offer_rec.custom_setup_id = 118 THEN -- SD offers
3911: -- update ozf_sd_request_headers_all_b update activating
3912: OPEN c_sd_req_header_rec(p_offer_rec.qp_list_header_id);
3913: FETCH c_sd_req_header_rec INTO l_obj_ver_num , l_sdr_req_header_id;
3914: CLOSE c_sd_req_header_rec;
3915:

Line 3921: UPDATE ozf_sd_request_headers_all_b

3917: ozf_utility_pvt.write_conc_log('l_sdr_req_header_id '|| l_sdr_req_header_id);
3918:
3919: --fix for bug 7004273
3920:
3921: UPDATE ozf_sd_request_headers_all_b
3922: SET user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS', 'ACTIVE') ,
3923: object_version_number = l_obj_ver_num + 1
3924: WHERE request_header_id = l_sdr_req_header_id;
3925: END IF;

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

6302:
6303: IF p_new_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','ACTIVE')
6304: AND l_offer_rec.CUSTOM_SETUP_ID = 118 THEN
6305:
6306: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','ACTIVE')
6307: where offer_id= l_offer_rec.qp_list_header_id;
6308:
6309: END IF;
6310:

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

6322: IF l_offer_rec.CUSTOM_SETUP_ID = 118 THEN
6323: IF p_new_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','DENIED_TA')
6324: OR p_new_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','REJECTED') THEN
6325:
6326: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','OFFER_REJECTED')
6327: where offer_id= l_offer_rec.qp_list_header_id;
6328:
6329: END IF;
6330:

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

9629: IF p_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','DENIED_TA')
9630: OR p_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','REJECTED') THEN --
9631:
9632:
9633: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','OFFER_REJECTED')
9634: where offer_id=p_modifier_list_rec.qp_list_header_id;
9635:
9636: ELSIF p_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','ACTIVE') THEN
9637:

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

9634: where offer_id=p_modifier_list_rec.qp_list_header_id;
9635:
9636: ELSIF p_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','ACTIVE') THEN
9637:
9638: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','ACTIVE')
9639: where offer_id= p_modifier_list_rec.qp_list_header_id;
9640:
9641: END IF;
9642: END IF;

Line 10542: FROM ozf_sd_request_headers_all_b

10538:
10539:
10540: CURSOR c_get_supplier_site_id(l_sdr_header_id NUMBER) IS
10541: SELECT supplier_site_id
10542: FROM ozf_sd_request_headers_all_b
10543: WHERE request_header_id = l_sdr_header_id;
10544:
10545:
10546:

Line 10610: FROM ozf_sd_request_headers_all_b

10606: request_number,
10607: asignee_resource_id,
10608: request_basis,
10609: org_id
10610: FROM ozf_sd_request_headers_all_b
10611: WHERE request_header_id = l_sdr_header_id;
10612:
10613:
10614: l_modifier_list_rec Modifier_LIST_Rec_Type;

Line 10800: FROM ozf_sd_request_headers_all_b

10796: CURSOR cur_get_header_info IS
10797: SELECT sales_order_currency,
10798: request_currency_code,
10799: supplier_site_id
10800: FROM ozf_sd_request_headers_all_b
10801: WHERE request_header_id = p_sdr_header_id;
10802:
10803: CURSOR cur_get_qty_inc_flag(p_supplier_site_id NUMBER) IS
10804: SELECT allow_qty_increase

Line 11056: FROM ozf_sd_request_headers_all_b

11052: WHERE list_header_id = p_qp_list_header_id;
11053:
11054: CURSOR cur_get_internal_order_number IS
11055: SELECT internal_order_number,org_id
11056: FROM ozf_sd_request_headers_all_b
11057: WHERE request_header_id = p_sdr_header_id;
11058:
11059: CURSOR cur_get_order_header_id (p_internal_order_number NUMBER,p_org_id NUMBER)IS
11060: SELECT header_id

Line 11367: FROM ozf_sd_request_headers_all_b

11363: AND system_status_code=l_new_status;
11364:
11365: CURSOR c_sdr_info(l_sdr_hdr_id NUMBER) IS
11366: SELECT accrual_type,cust_account_id,supplier_site_id
11367: FROM ozf_sd_request_headers_all_b
11368: WHERE request_header_id=l_sdr_hdr_id;
11369:
11370: CURSOR c_supp_trd_prfl_info(l_supplier_site_id NUMBER) IS
11371: SELECT cust_account_id, site_use_id

Line 11416: FROM OZF_SD_REQUEST_HEADERS_ALL_B

11412: AND arc_user_or_role_type = 'USER';
11413:
11414: CURSOR c_get_sdr_status(p_sdr_header_id NUMBER) IS
11415: SELECT user_status_id
11416: FROM OZF_SD_REQUEST_HEADERS_ALL_B
11417: WHERE request_header_id=p_sdr_header_id;
11418:
11419: CURSOR cur_is_theme_appr_req(p_custom_setup_id NUMBER) IS
11420: SELECT attr_available_flag

Line 11828: update ozf_sd_request_headers_all_b

11824: /*IF l_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','ACTIVE') THEN
11825:
11826: debug_message('p_sdr_header_id1111 = '|| p_sdr_header_id);
11827:
11828: update ozf_sd_request_headers_all_b
11829: set user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','ACTIVE')
11830: where request_header_id = p_sdr_header_id;
11831:
11832: END IF;*/