APPS.OZF_SUPP_TRADE_PROFILE_PVT dependencies on OZF_SUPP_TRD_PRFLS

Line 46: FROM ozf_supp_trd_prfls_all

42: IS
43:
44: CURSOR c_supp_trade IS
45: SELECT *
46: FROM ozf_supp_trd_prfls_all
47: WHERE supp_trade_profile_id = p_supp_trade_profile_rec.supp_trade_profile_id;
48: l_supp_trade_profile_rec c_supp_trade%rowtype;
49:
50: BEGIN

Line 855: SELECT ozf_supp_trd_prfls_all_s.NEXTVAL

851: l_x_supp_trade_profile_rec supp_trade_profile_rec_type;
852: l_null VARCHAR2(10) := 'NULL';
853:
854: CURSOR c_id IS
855: SELECT ozf_supp_trd_prfls_all_s.NEXTVAL
856: FROM dual;
857:
858: CURSOR c_id_exists (l_id IN NUMBER) IS
859: SELECT count(supp_trade_profile_id)

Line 860: FROM ozf_supp_trd_prfls_all

856: FROM dual;
857:
858: CURSOR c_id_exists (l_id IN NUMBER) IS
859: SELECT count(supp_trade_profile_id)
860: FROM ozf_supp_trd_prfls_all
861: WHERE SUPP_TRADE_PROFILE_ID = l_id;
862:
863: CURSOR c_customer_id (p_id IN NUMBER) IS
864: SELECT cust_account_id

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

958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
959: END IF;
960:
961: -- Debug Message
962: -- Invoke table handler(OZF_supp_trd_prfls_PKG.Insert_Row)
963: BEGIN
964: OZF_supp_trd_prfls_PKG.Insert_Row(
965: px_supp_trade_profile_id => l_supp_trade_profile_id,
966: px_object_version_number => l_object_version_number,

Line 964: OZF_supp_trd_prfls_PKG.Insert_Row(

960:
961: -- Debug Message
962: -- Invoke table handler(OZF_supp_trd_prfls_PKG.Insert_Row)
963: BEGIN
964: OZF_supp_trd_prfls_PKG.Insert_Row(
965: px_supp_trade_profile_id => l_supp_trade_profile_id,
966: px_object_version_number => l_object_version_number,
967: p_last_update_date => SYSDATE,
968: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 1176: FROM ozf_supp_trd_prfls_all

1172: l_supp_id NUMBER;
1173:
1174: CURSOR c_supp_trade IS
1175: SELECT *
1176: FROM ozf_supp_trd_prfls_all
1177: WHERE supp_trade_profile_id = p_supp_trade_profile_rec.supp_trade_profile_id;
1178:
1179: CURSOR c_get_supp_trade_profile(v_supp_trade_profile_id in NUMBER) IS
1180: SELECT *

Line 1181: FROM ozf_supp_trd_prfls_all

1177: WHERE supp_trade_profile_id = p_supp_trade_profile_rec.supp_trade_profile_id;
1178:
1179: CURSOR c_get_supp_trade_profile(v_supp_trade_profile_id in NUMBER) IS
1180: SELECT *
1181: FROM ozf_supp_trd_prfls_all
1182: WHERE supp_trade_profile_id = v_supp_trade_profile_id;
1183:
1184:
1185: l_ref_supp_trade_profile_rec c_supp_trade%ROWTYPE;

Line 1194: FROM ozf_supp_trd_prfls_all -- R12 Enhancements

1190:
1191:
1192: CURSOR check_supp_profile (p_id in number) IS
1193: SELECT supplier_id , supplier_site_id
1194: FROM ozf_supp_trd_prfls_all -- R12 Enhancements
1195: WHERE supp_trade_profile_id = p_id;
1196:
1197:
1198: BEGIN

Line 1341: OZF_supp_trd_prfls_PKG.Update_Row(

1337: END IF;
1338: END IF;
1339:
1340: -- Debug Message
1341: OZF_supp_trd_prfls_PKG.Update_Row(
1342: p_supp_trade_profile_id => l_supp_trade_profile_rec.supp_trade_profile_id,
1343: p_object_version_number => l_supp_trade_profile_rec.object_version_number,
1344: p_last_update_date => SYSDATE,
1345: p_last_updated_by => FND_GLOBAL.USER_ID,

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

1553: -- Debug Message
1554: IF g_debug THEN
1555: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1556: END IF;
1557: -- Invoke table handler(OZF_supp_trd_prfls_PKG.Delete_Row)
1558: OZF_supp_trd_prfls_PKG.Delete_Row(
1559: p_SUPP_TRADE_PROFILE_ID => p_SUPP_TRADE_PROFILE_ID);
1560: -- End of API body
1561: -- Standard check for p_commit

Line 1558: OZF_supp_trd_prfls_PKG.Delete_Row(

1554: IF g_debug THEN
1555: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1556: END IF;
1557: -- Invoke table handler(OZF_supp_trd_prfls_PKG.Delete_Row)
1558: OZF_supp_trd_prfls_PKG.Delete_Row(
1559: p_SUPP_TRADE_PROFILE_ID => p_SUPP_TRADE_PROFILE_ID);
1560: -- End of API body
1561: -- Standard check for p_commit
1562: IF FND_API.to_Boolean( p_commit )

Line 1634: FROM ozf_supp_trd_prfls_all

1630: l_SUPP_TRADE_PROFILE_ID NUMBER;
1631:
1632: CURSOR c_Supp_Trade_Profile IS
1633: SELECT SUPP_TRADE_PROFILE_ID
1634: FROM ozf_supp_trd_prfls_all
1635: WHERE SUPP_TRADE_PROFILE_ID = p_SUPP_TRADE_PROFILE_ID
1636: AND object_version_number = p_object_version
1637: FOR UPDATE NOWAIT;
1638: BEGIN

Line 1738: FROM ozf_supp_trd_prfls

1734: -- one supplier trade profile per supplier and supplier site and org id combination
1735:
1736: CURSOR c_dupl_profile_exists(l_id in NUMBER,l_supp_site_id in NUMBER) IS
1737: SELECT supp_trade_profile_id
1738: FROM ozf_supp_trd_prfls
1739: WHERE SUPPLIER_SITE_ID = l_supp_site_id
1740: AND SUPPLIER_ID = l_id;
1741:
1742: