1: PACKAGE BODY CN_REVENUE_CLASS_PVT AS
2: --$Header: cnvrclsb.pls 120.2 2005/08/07 23:04:47 vensrini noship $
3:
4: --Global Variables
5:
2: --$Header: cnvrclsb.pls 120.2 2005/08/07 23:04:47 vensrini noship $
3:
4: --Global Variables
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_REVENUE_CLASS_PVT';
7: G_LAST_UPDATE_DATE DATE := Sysdate;
8: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
9: G_CREATION_DATE DATE := Sysdate;
10: G_CREATED_BY NUMBER := fnd_global.user_id;
47: x_msg_count OUT NOCOPY NUMBER,
48: x_msg_data OUT NOCOPY VARCHAR2,
49: x_loading_status OUT NOCOPY VARCHAR2,
50: x_revenue_class_id OUT NOCOPY NUMBER,
51: p_revenue_class_rec IN CN_REVENUE_CLASS_PVT.revenue_class_rec_type,
52: p_org_id IN NUMBER
53: )
54: IS
55:
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_count OUT NOCOPY NUMBER,
224: x_msg_data OUT NOCOPY VARCHAR2,
225: x_loading_status OUT NOCOPY VARCHAR2,
226: pold_revenue_class_rec IN OUT NOCOPY CN_REVENUE_CLASS_PVT.revenue_class_rec_type,
227: p_revenue_class_rec IN OUT NOCOPY CN_REVENUE_CLASS_PVT.revenue_class_rec_type
228: ) IS
229:
230: CURSOR l_ovn_csr IS
223: x_msg_count OUT NOCOPY NUMBER,
224: x_msg_data OUT NOCOPY VARCHAR2,
225: x_loading_status OUT NOCOPY VARCHAR2,
226: pold_revenue_class_rec IN OUT NOCOPY CN_REVENUE_CLASS_PVT.revenue_class_rec_type,
227: p_revenue_class_rec IN OUT NOCOPY CN_REVENUE_CLASS_PVT.revenue_class_rec_type
228: ) IS
229:
230: CURSOR l_ovn_csr IS
231: SELECT nvl(object_version_number,1)
618:
619: END;
620:
621:
622: END CN_REVENUE_CLASS_PVT;