APPS.OZF_TRADE_PROFILE_PVT dependencies on OZF_CUST_TRD_PRFLS_ALL

Line 39: FROM ozf_cust_trd_prfls_all

35: IS
36:
37: CURSOR c_trade IS
38: SELECT *
39: FROM ozf_cust_trd_prfls_all
40: WHERE trade_profile_id = p_trade_profile_rec.trade_profile_id;
41: l_trade_profile_rec c_trade%rowtype;
42:
43: BEGIN

Line 446: SELECT ozf_cust_trd_prfls_all_s.NEXTVAL

442: l_x_trade_profile_rec trade_profile_rec_type;
443: l_null VARCHAR2(10) := 'NULL';
444:
445: CURSOR c_id IS
446: SELECT ozf_cust_trd_prfls_all_s.NEXTVAL
447: FROM dual;
448:
449: CURSOR c_id_exists (l_id IN NUMBER) IS
450: SELECT count(trade_profile_id)

Line 451: FROM ozf_cust_trd_prfls_all

447: FROM dual;
448:
449: CURSOR c_id_exists (l_id IN NUMBER) IS
450: SELECT count(trade_profile_id)
451: FROM ozf_cust_trd_prfls_all
452: WHERE TRADE_PROFILE_ID = l_id;
453:
454: CURSOR c_customer_id (p_id IN NUMBER) IS
455: SELECT cust_account_id

Line 741: FROM ozf_cust_trd_prfls_all

737: l_org_id NUMBER;
738:
739: CURSOR c_trade IS
740: SELECT *
741: FROM ozf_cust_trd_prfls_all
742: WHERE trade_profile_id = p_trade_profile_rec.trade_profile_id;
743:
744: CURSOR c_get_trade_profile(v_trade_profile_id in NUMBER) IS
745: SELECT *

Line 746: FROM ozf_cust_trd_prfls_all

742: WHERE trade_profile_id = p_trade_profile_rec.trade_profile_id;
743:
744: CURSOR c_get_trade_profile(v_trade_profile_id in NUMBER) IS
745: SELECT *
746: FROM ozf_cust_trd_prfls_all
747: WHERE trade_profile_id = v_trade_profile_id;
748:
749: CURSOR c_cust_acct_site_id (a_id IN NUMBER) IS
750: SELECT cust_acct_site_id

Line 763: FROM ozf_cust_trd_prfls_all -- R12 Enhancements

759: l_x_trade_profile_rec trade_profile_rec_type;
760:
761: /*CURSOR check_acct_profile (p_id in number) IS
762: SELECT cust_account_id
763: FROM ozf_cust_trd_prfls_all -- R12 Enhancements
764: WHERE trade_profile_id = p_id;*/
765:
766: CURSOR check_site_profile (p_id in number) IS
767: SELECT site_use_id

Line 768: FROM ozf_cust_trd_prfls_all --For R12.1 Enhancements

764: WHERE trade_profile_id = p_id;*/
765:
766: CURSOR check_site_profile (p_id in number) IS
767: SELECT site_use_id
768: FROM ozf_cust_trd_prfls_all --For R12.1 Enhancements
769: WHERE trade_profile_id = p_id;
770:
771:
772: BEGIN

Line 1149: FROM ozf_cust_trd_prfls_all

1145: l_TRADE_PROFILE_ID NUMBER;
1146:
1147: CURSOR c_Trade_Profile IS
1148: SELECT TRADE_PROFILE_ID
1149: FROM ozf_cust_trd_prfls_all
1150: WHERE TRADE_PROFILE_ID = p_TRADE_PROFILE_ID
1151: AND object_version_number = p_object_version
1152: FOR UPDATE NOWAIT;
1153: BEGIN