APPS.OZF_TRADE_PROFILE_PVT dependencies on OZF_CUST_TRD_PRFLS_ALL

Line 37: FROM ozf_cust_trd_prfls_all

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

Line 444: SELECT ozf_cust_trd_prfls_all_s.NEXTVAL

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

Line 449: FROM ozf_cust_trd_prfls_all

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

Line 739: FROM ozf_cust_trd_prfls_all

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

Line 744: FROM ozf_cust_trd_prfls_all

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

Line 761: FROM ozf_cust_trd_prfls_all -- R12 Enhancements

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

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

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

Line 1147: FROM ozf_cust_trd_prfls_all

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