APPS.CN_RT_QUOTA_ASGNS_PVT dependencies on CN_RT_QUOTA_ASGNS

Line 1: PACKAGE BODY CN_RT_QUOTA_ASGNS_PVT as

1: PACKAGE BODY CN_RT_QUOTA_ASGNS_PVT as
2: /* $Header: cnxvrqab.pls 120.2 2007/08/10 20:35:41 rnagired ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_RT_QUOTA_ASGNS_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnxvrqab.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_RT_QUOTA_ASGNS_PVT';

1: PACKAGE BODY CN_RT_QUOTA_ASGNS_PVT as
2: /* $Header: cnxvrqab.pls 120.2 2007/08/10 20:35:41 rnagired ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_RT_QUOTA_ASGNS_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnxvrqab.pls';
6: G_LAST_UPDATE_DATE DATE := sysdate;
7: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
8: G_CREATION_DATE DATE := sysdate;

Line 42: -- FROM cn_rt_quota_asgns

38: -- Cursor
39: -- CURSOR rt_quota_asgns_seq_curs(l_quota_id NUMBER) IS
40: -- SELECT end_date,
41: -- quota_id
42: -- FROM cn_rt_quota_asgns
43: -- WHERE quota_id = l_quota_id
44: -- ORDER BY start_date DESC ;
45:
46: l_tmp NUMBER;

Line 161: FROM cn_rt_Quota_asgns

157: -- Check Duplicate or invalid Sequence Date only
158:
159: SELECT COUNT(*)
160: INTO l_tmp
161: FROM cn_rt_Quota_asgns
162: WHERE quota_id = p_quota_id
163: AND calc_formula_id = l_calc_formula_id
164: AND rt_quota_asgn_id <> Nvl(x_rt_quota_asgn_id,0)
165: AND Trunc(start_date) = Trunc(p_rt_quota_Asgns_rec.start_date)

Line 392: CN_RT_QUOTA_ASGNS_PKG.begin_record

388:
389: -- Insert the Rt_quota assigns record.
390:
391:
392: CN_RT_QUOTA_ASGNS_PKG.begin_record
393: (x_org_id => p_org_id,
394: x_Operation => 'INSERT'
395: ,x_Rowid => G_ROWID
396: ,x_rt_quota_asgn_id => l_rt_quota_asgn_id

Line 674: CN_RT_QUOTA_ASGNS_PKG.begin_record

670: ELSIF ( x_return_status = FND_API.G_RET_STS_SUCCESS )
671: AND ( x_loading_status = 'CN_UPDATED' )
672: THEN
673: -- Update Rt Quota Assigns
674: CN_RT_QUOTA_ASGNS_PKG.begin_record
675: (x_org_id => p_org_id,
676: x_Operation => 'UPDATE'
677: ,x_Rowid => G_ROWID
678: ,x_rt_quota_asgn_id => l_rt_quota_asgn_id

Line 991: CN_RT_QUOTA_ASGNS_PKG.begin_record

987: ELSIF ( x_return_status = FND_API.G_RET_STS_SUCCESS )
988: AND ( x_loading_status = 'CN_DELETED' )
989: THEN
990: -- Delete RT quota Assigns
991: CN_RT_QUOTA_ASGNS_PKG.begin_record
992: (x_org_id => p_org_id,
993: x_Operation => 'DELETE'
994: ,x_Rowid => G_ROWID
995: ,x_rt_quota_asgn_id => l_rt_quota_asgn_id

Line 1083: END CN_RT_QUOTA_ASGNS_PVT ;

1079: p_encoded => FND_API.G_FALSE
1080: );
1081: END Delete_rt_quota_Asgns;
1082:
1083: END CN_RT_QUOTA_ASGNS_PVT ;