APPS.CSE_ASSET_CREATION_PKG dependencies on CSE_ASSET_CREATION_PKG

Line 1: PACKAGE BODY cse_asset_creation_pkg AS

1: PACKAGE BODY cse_asset_creation_pkg AS
2: /* $Header: CSEIFACB.pls 120.41.12020000.9 2013/02/01 10:49:52 mvaradam ship $ */
3:
4: l_debug varchar2(1) := NVL(fnd_profile.value('cse_debug_option'),'N');
5: l_asset_for_exp_item_flag VARCHAR2(1) := NVL(fnd_profile.value('CSE_ASSETS_FOR_EXPENSE_ITEMS'),'Y'); --Added For bug 9488846

Line 2969: l_api_name VARCHAR2(100):= 'CSE_ASSET_CREATION_PKG.find_distribution';

2965: , x_return_status OUT NOCOPY VARCHAR2
2966: , x_error_msg OUT NOCOPY VARCHAR2 )
2967: IS
2968: l_distribution_id NUMBER ;
2969: l_api_name VARCHAR2(100):= 'CSE_ASSET_CREATION_PKG.find_distribution';
2970: CURSOR dist_cur IS
2971: SELECT distribution_id
2972: ,book_type_code
2973: ,location_id

Line 3055: l_api_name VARCHAR2(100):= 'CSE_ASSET_CREATION_PKG.create_fa_distribution';

3051: x_new_dist NUMBER;
3052: x_new_from_dist_id NUMBER;
3053: x_new_to_dist_id NUMBER;
3054: e_error EXCEPTION ;
3055: l_api_name VARCHAR2(100):= 'CSE_ASSET_CREATION_PKG.create_fa_distribution';
3056:
3057: BEGIN
3058: debug('Begin - create distribution');
3059: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

Line 3071: cse_asset_creation_pkg.find_distribution(

3067: l_asset_query_rec.distribution_id := NULL;
3068:
3069: IF l_asset_query_rec.distribution_id IS NULL
3070: THEN
3071: cse_asset_creation_pkg.find_distribution(
3072: l_asset_query_rec
3073: , p_mass_add_rec
3074: , x_new_dist
3075: , x_return_status

Line 3177: l_api_name VARCHAR2(100) := 'CSE_ASSET_CREATION_PKG.find_asset';

3173: l_mtl_cost NUMBER ;
3174: l_non_mtl_cost NUMBER ;
3175: l_mtl_ratio NUMBER ;
3176:
3177: l_api_name VARCHAR2(100) := 'CSE_ASSET_CREATION_PKG.find_asset';
3178:
3179: CURSOR dist_history_cur IS
3180: SELECT distribution_id
3181: ,location_id

Line 3535: l_api_name VARCHAR2(100) := 'CSE_ASSET_CREATION_PKG.adjust_asset';

3531: l_init_ext_ret_rec fa_mass_ext_retirements%ROWTYPE ;
3532: l_ext_ret_rec fa_mass_ext_retirements%ROWTYPE ;
3533: l_sysdate DATE := SYSDATE ;
3534:
3535: l_api_name VARCHAR2(100) := 'CSE_ASSET_CREATION_PKG.adjust_asset';
3536: l_total_fa_units NUMBER ;
3537:
3538: CURSOR fa_asset_units (c_asset_id IN NUMBER) IS
3539: SELECT fad.current_units

Line 3572: debug('inside api cse_asset_creation_pkg.adjust_asset');

3568:
3569: BEGIN
3570:
3571: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
3572: debug('inside api cse_asset_creation_pkg.adjust_asset');
3573: debug(' asset_id : '||p_asset_query_rec.asset_id);
3574: debug(' units_to_be_adjusted : '||p_mass_add_rec.payables_units);
3575:
3576: l_mass_add_rec := p_mass_add_rec ;

Line 3851: END cse_asset_creation_pkg;

3847: x_return_status := fnd_api.g_ret_sts_error;
3848: x_err_inst_rec := l_inst_rec;
3849: END create_asset;
3850:
3851: END cse_asset_creation_pkg;