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_TRADE_PROFILE_PVT dependencies on OZF_CUST_TRD_PRFLS

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 584: -- Invoke table handler(OZF_cust_trd_prfls_PKG.Insert_Row)

580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
581: END IF;
582:
583: -- Debug Message
584: -- Invoke table handler(OZF_cust_trd_prfls_PKG.Insert_Row)
585: BEGIN
586: OZF_cust_trd_prfls_PKG.Insert_Row(
587: px_trade_profile_id => l_trade_profile_id,
588: px_object_version_number => l_object_version_number,

Line 586: OZF_cust_trd_prfls_PKG.Insert_Row(

582:
583: -- Debug Message
584: -- Invoke table handler(OZF_cust_trd_prfls_PKG.Insert_Row)
585: BEGIN
586: OZF_cust_trd_prfls_PKG.Insert_Row(
587: px_trade_profile_id => l_trade_profile_id,
588: px_object_version_number => l_object_version_number,
589: p_last_update_date => SYSDATE,
590: p_last_updated_by => FND_GLOBAL.USER_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 912: OZF_cust_trd_prfls_PKG.Update_Row(

908: OZF_UTILITY_PVT.debug_message('cust_account_id'||l_trade_profile_rec.cust_account_id);
909: END IF;
910:
911: -- Debug Message
912: OZF_cust_trd_prfls_PKG.Update_Row(
913: p_trade_profile_id => l_trade_profile_rec.trade_profile_id,
914: p_object_version_number => l_trade_profile_rec.object_version_number,
915: p_last_update_date => SYSDATE,
916: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 1073: -- Invoke table handler(OZF_cust_trd_prfls_PKG.Delete_Row)

1069: -- Debug Message
1070: IF g_debug THEN
1071: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1072: END IF;
1073: -- Invoke table handler(OZF_cust_trd_prfls_PKG.Delete_Row)
1074: OZF_cust_trd_prfls_PKG.Delete_Row(
1075: p_TRADE_PROFILE_ID => p_TRADE_PROFILE_ID);
1076: -- End of API body
1077: -- Standard check for p_commit

Line 1074: OZF_cust_trd_prfls_PKG.Delete_Row(

1070: IF g_debug THEN
1071: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1072: END IF;
1073: -- Invoke table handler(OZF_cust_trd_prfls_PKG.Delete_Row)
1074: OZF_cust_trd_prfls_PKG.Delete_Row(
1075: p_TRADE_PROFILE_ID => p_TRADE_PROFILE_ID);
1076: -- End of API body
1077: -- Standard check for p_commit
1078: IF FND_API.to_Boolean( p_commit )

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

Line 1256: FROM ozf_cust_trd_prfls

1252: --For R12.1 Enhancements
1253: -- one trade profile per cust account
1254: /*CURSOR c_cust_id_exists (l_id IN NUMBER) IS
1255: SELECT count(cust_account_id)
1256: FROM ozf_cust_trd_prfls
1257: WHERE CUST_ACCOUNT_ID = l_id;*/
1258:
1259:
1260:

Line 1264: FROM ozf_cust_trd_prfls

1260:
1261: -- one trade profile per party (without cust account)
1262: CURSOR c_party_id_exists(l_id in NUMBER) IS
1263: SELECT count(party_id)
1264: FROM ozf_cust_trd_prfls
1265: WHERE CUST_ACCOUNT_ID is NULL
1266: AND PARTY_ID = l_id;
1267:
1268: --For R12.1 Enhancements

Line 1272: FROM ozf_cust_trd_prfls

1268: --For R12.1 Enhancements
1269: -- one trade profile per cust bill_to site
1270: CURSOR c_cust_site_use_exists (l_id IN NUMBER) IS
1271: SELECT count(site_use_id)
1272: FROM ozf_cust_trd_prfls
1273: WHERE site_use_id = l_id;
1274:
1275: BEGIN
1276: x_return_status := FND_API.g_ret_sts_success;