APPS.CN_TRX_FACTORS_PVT dependencies on CN_TRX_FACTORS

Line 1: PACKAGE BODY CN_TRX_FACTORS_PVT as

1: PACKAGE BODY CN_TRX_FACTORS_PVT as
2: /* $Header: cnxvtrxb.pls 120.1 2005/09/09 00:06:55 rarajara noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_TRX_FACTORS_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnxvtrxb.pls';

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

1: PACKAGE BODY CN_TRX_FACTORS_PVT as
2: /* $Header: cnxvtrxb.pls 120.1 2005/09/09 00:06:55 rarajara noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_TRX_FACTORS_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnxvtrxb.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 188: FROM cn_trx_factors

184: -- Check Record Already exists.
185: --+
186: SELECT COUNT(*)
187: INTO l_tmp
188: FROM cn_trx_factors
189: WHERE revenue_class_id = p_rev_class_id
190: AND quota_id = p_quota_id
191: AND quota_rule_id = p_quota_rule_id
192: AND trx_type = p_trx_factor_rec.trx_type ;

Line 349: UPDATE cn_trx_factors

345: RAISE FND_API.G_EXC_ERROR ;
346: ELSIF ( x_return_status = FND_API.G_RET_STS_SUCCESS )
347: AND ( x_loading_status = 'TRX_FACTORS_EXISTS' ) THEN
348: x_loading_status := 'CN_UPDATED' ;
349: UPDATE cn_trx_factors
350: SET event_factor = p_trx_factor_rec_tbl(i).event_factor
351: WHERE quota_id = l_quota_id
352: AND quota_rule_id = l_quota_rule_id
353: AND trx_type = Ltrim(Rtrim(p_trx_factor_rec_tbl(i).trx_type)) ;

Line 423: END CN_TRX_FACTORS_PVT ;

419: );
420: END Update_Trx_Factors;
421:
422:
423: END CN_TRX_FACTORS_PVT ;