APPS.OZF_SUPP_TRADE_PROFILE_PVT dependencies on OZF_SUPP_TRD_PRFLS

Line 41: FROM ozf_supp_trd_prfls_all

37: IS
38:
39: CURSOR c_supp_trade IS
40: SELECT *
41: FROM ozf_supp_trd_prfls_all
42: WHERE supp_trade_profile_id = p_supp_trade_profile_rec.supp_trade_profile_id;
43: l_supp_trade_profile_rec c_supp_trade%rowtype;
44:
45: BEGIN

Line 748: SELECT ozf_supp_trd_prfls_all_s.NEXTVAL

744: l_x_supp_trade_profile_rec supp_trade_profile_rec_type;
745: l_null VARCHAR2(10) := 'NULL';
746:
747: CURSOR c_id IS
748: SELECT ozf_supp_trd_prfls_all_s.NEXTVAL
749: FROM dual;
750:
751: CURSOR c_id_exists (l_id IN NUMBER) IS
752: SELECT count(supp_trade_profile_id)

Line 753: FROM ozf_supp_trd_prfls_all

749: FROM dual;
750:
751: CURSOR c_id_exists (l_id IN NUMBER) IS
752: SELECT count(supp_trade_profile_id)
753: FROM ozf_supp_trd_prfls_all
754: WHERE SUPP_TRADE_PROFILE_ID = l_id;
755:
756: CURSOR c_customer_id (p_id IN NUMBER) IS
757: SELECT cust_account_id

Line 855: -- Invoke table handler(OZF_supp_trd_prfls_PKG.Insert_Row)

851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
852: END IF;
853:
854: -- Debug Message
855: -- Invoke table handler(OZF_supp_trd_prfls_PKG.Insert_Row)
856: BEGIN
857: OZF_supp_trd_prfls_PKG.Insert_Row(
858: px_supp_trade_profile_id => l_supp_trade_profile_id,
859: px_object_version_number => l_object_version_number,

Line 857: OZF_supp_trd_prfls_PKG.Insert_Row(

853:
854: -- Debug Message
855: -- Invoke table handler(OZF_supp_trd_prfls_PKG.Insert_Row)
856: BEGIN
857: OZF_supp_trd_prfls_PKG.Insert_Row(
858: px_supp_trade_profile_id => l_supp_trade_profile_id,
859: px_object_version_number => l_object_version_number,
860: p_last_update_date => SYSDATE,
861: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 1057: FROM ozf_supp_trd_prfls_all

1053: l_supp_id NUMBER;
1054:
1055: CURSOR c_supp_trade IS
1056: SELECT *
1057: FROM ozf_supp_trd_prfls_all
1058: WHERE supp_trade_profile_id = p_supp_trade_profile_rec.supp_trade_profile_id;
1059:
1060: CURSOR c_get_supp_trade_profile(v_supp_trade_profile_id in NUMBER) IS
1061: SELECT *

Line 1062: FROM ozf_supp_trd_prfls_all

1058: WHERE supp_trade_profile_id = p_supp_trade_profile_rec.supp_trade_profile_id;
1059:
1060: CURSOR c_get_supp_trade_profile(v_supp_trade_profile_id in NUMBER) IS
1061: SELECT *
1062: FROM ozf_supp_trd_prfls_all
1063: WHERE supp_trade_profile_id = v_supp_trade_profile_id;
1064:
1065:
1066: l_ref_supp_trade_profile_rec c_supp_trade%ROWTYPE;

Line 1075: FROM ozf_supp_trd_prfls_all -- R12 Enhancements

1071:
1072:
1073: CURSOR check_supp_profile (p_id in number) IS
1074: SELECT supplier_id , supplier_site_id
1075: FROM ozf_supp_trd_prfls_all -- R12 Enhancements
1076: WHERE supp_trade_profile_id = p_id;
1077:
1078:
1079: BEGIN

Line 1222: OZF_supp_trd_prfls_PKG.Update_Row(

1218: END IF;
1219: END IF;
1220:
1221: -- Debug Message
1222: OZF_supp_trd_prfls_PKG.Update_Row(
1223: p_supp_trade_profile_id => l_supp_trade_profile_rec.supp_trade_profile_id,
1224: p_object_version_number => l_supp_trade_profile_rec.object_version_number,
1225: p_last_update_date => SYSDATE,
1226: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 1426: -- Invoke table handler(OZF_supp_trd_prfls_PKG.Delete_Row)

1422: -- Debug Message
1423: IF g_debug THEN
1424: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1425: END IF;
1426: -- Invoke table handler(OZF_supp_trd_prfls_PKG.Delete_Row)
1427: OZF_supp_trd_prfls_PKG.Delete_Row(
1428: p_SUPP_TRADE_PROFILE_ID => p_SUPP_TRADE_PROFILE_ID);
1429: -- End of API body
1430: -- Standard check for p_commit

Line 1427: OZF_supp_trd_prfls_PKG.Delete_Row(

1423: IF g_debug THEN
1424: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1425: END IF;
1426: -- Invoke table handler(OZF_supp_trd_prfls_PKG.Delete_Row)
1427: OZF_supp_trd_prfls_PKG.Delete_Row(
1428: p_SUPP_TRADE_PROFILE_ID => p_SUPP_TRADE_PROFILE_ID);
1429: -- End of API body
1430: -- Standard check for p_commit
1431: IF FND_API.to_Boolean( p_commit )

Line 1503: FROM ozf_supp_trd_prfls_all

1499: l_SUPP_TRADE_PROFILE_ID NUMBER;
1500:
1501: CURSOR c_Supp_Trade_Profile IS
1502: SELECT SUPP_TRADE_PROFILE_ID
1503: FROM ozf_supp_trd_prfls_all
1504: WHERE SUPP_TRADE_PROFILE_ID = p_SUPP_TRADE_PROFILE_ID
1505: AND object_version_number = p_object_version
1506: FOR UPDATE NOWAIT;
1507: BEGIN

Line 1607: FROM ozf_supp_trd_prfls

1603: -- one supplier trade profile per supplier and supplier site and org id combination
1604:
1605: CURSOR c_dupl_profile_exists(l_id in NUMBER,l_supp_site_id in NUMBER) IS
1606: SELECT supp_trade_profile_id
1607: FROM ozf_supp_trd_prfls
1608: WHERE SUPPLIER_SITE_ID = l_supp_site_id
1609: AND SUPPLIER_ID = l_id;
1610:
1611: