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_PRICELIST_PVT dependencies on OZF_UTILITY_PVT

Line 219: l_resource_id NUMBER := OZF_UTILITY_PVT.get_resource_id(FND_GLOBAL.user_id);

215: SELECT user_status_id,custom_setup_id,owner_id
216: FROM OZF_price_list_attributes
217: WHERE qp_list_header_id = l_id;
218:
219: l_resource_id NUMBER := OZF_UTILITY_PVT.get_resource_id(FND_GLOBAL.user_id);
220:
221: l_new_status_code VARCHAR2(30);
222: l_existing_status_code VARCHAR2(30);
223: l_old_status_id NUMBER;

Line 349: OZF_Utility_PVT.check_new_status_change(p_object_type => 'PRIC'

345:
346: -- check if approval is required
347: IF p_price_list_rec.user_status_id IS NOT NULL AND p_price_list_rec.user_status_id <> FND_API.G_MISS_NUM THEN
348: -- bug 3780070 exception when updating price list created from QP (QP price lists have no status code in OZF)
349: OZF_Utility_PVT.check_new_status_change(p_object_type => 'PRIC'
350: ,p_object_id => p_price_list_rec.list_header_id
351: ,p_old_status_id => l_old_status_id
352: ,p_new_status_id => p_price_list_rec.user_status_id
353: ,p_custom_setup_id => l_custom_setup_id

Line 695: l_ozf_price_list_attr_rec.user_status_id := ozf_utility_pvt.get_default_user_status('OZF_PRICELIST_STATUS','PENDING');

691: -- check if approval is required
692: IF p_price_list_rec.user_status_id IS NOT NULL AND p_price_list_rec.user_status_id <> FND_API.G_MISS_NUM THEN
693: -- bug 3780070 exception when updating price list created from QP i.e. no status for QP price lists
694: IF l_approval_type IS NOT NULL THEN -- approval is required
695: l_ozf_price_list_attr_rec.user_status_id := ozf_utility_pvt.get_default_user_status('OZF_PRICELIST_STATUS','PENDING');
696: l_ozf_price_list_attr_rec.status_code := 'PENDING';
697: END IF;
698: END IF; -- end bug 3780070 exception when updating price list created from QP
699:

Line 736: OZF_Utility_PVT.error_message('OZF_PRIC_UPDT_OWNER_PERM');

732: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
733: RAISE FND_API.g_exc_unexpected_error;
734: END IF;
735: ELSE
736: OZF_Utility_PVT.error_message('OZF_PRIC_UPDT_OWNER_PERM');
737: x_return_status := FND_API.g_ret_sts_error;
738: END IF;
739:
740:

Line 763: ,p_reject_stat_id => ozf_utility_pvt.get_default_user_status('OZF_PRICELIST_STATUS','REJECTED')

759: ,p_approval_type => 'PRICELIST'
760: ,p_object_version_number => p_price_list_rec.object_version_number
761: ,p_orig_stat_id => l_old_status_id
762: ,p_new_stat_id => p_price_list_rec.user_status_id
763: ,p_reject_stat_id => ozf_utility_pvt.get_default_user_status('OZF_PRICELIST_STATUS','REJECTED')
764: ,p_requester_userid => OZF_Utility_PVT.get_resource_id(FND_GLOBAL.user_id)
765: ,p_workflowprocess => 'AMSGAPP'
766: ,p_item_type => 'AMSGAPP');
767: END IF;

Line 764: ,p_requester_userid => OZF_Utility_PVT.get_resource_id(FND_GLOBAL.user_id)

760: ,p_object_version_number => p_price_list_rec.object_version_number
761: ,p_orig_stat_id => l_old_status_id
762: ,p_new_stat_id => p_price_list_rec.user_status_id
763: ,p_reject_stat_id => ozf_utility_pvt.get_default_user_status('OZF_PRICELIST_STATUS','REJECTED')
764: ,p_requester_userid => OZF_Utility_PVT.get_resource_id(FND_GLOBAL.user_id)
765: ,p_workflowprocess => 'AMSGAPP'
766: ,p_item_type => 'AMSGAPP');
767: END IF;
768: