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.12020000.2 2013/01/25 09:36:49 ndamala 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.12020000.2 2013/01/25 09:36:49 ndamala 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 675: CN_RT_QUOTA_ASGNS_PKG.begin_record

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

Line 993: CN_RT_QUOTA_ASGNS_PKG.begin_record

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

Line 1085: END CN_RT_QUOTA_ASGNS_PVT ;

1081: p_encoded => FND_API.G_FALSE
1082: );
1083: END Delete_rt_quota_Asgns;
1084:
1085: END CN_RT_QUOTA_ASGNS_PVT ;