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

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

Line 584: OZF_cust_trd_prfls_PKG.Insert_Row(

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

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

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

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

Line 1072: OZF_cust_trd_prfls_PKG.Delete_Row(

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

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

Line 1254: FROM ozf_cust_trd_prfls

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

Line 1262: FROM ozf_cust_trd_prfls

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

Line 1270: FROM ozf_cust_trd_prfls

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