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.30.12010000.2 2008/10/17 19:20:21 fli ship $ */
3:
4: l_debug varchar2(1) := NVL(fnd_profile.value('cse_debug_option'),'N');
5:

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

2629: , x_return_status OUT NOCOPY VARCHAR2
2630: , x_error_msg OUT NOCOPY VARCHAR2 )
2631: IS
2632: l_distribution_id NUMBER ;
2633: l_api_name VARCHAR2(100):= 'CSE_ASSET_CREATION_PKG.find_distribution';
2634: CURSOR dist_cur IS
2635: SELECT distribution_id
2636: ,book_type_code
2637: ,location_id

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

2715: x_new_dist NUMBER;
2716: x_new_from_dist_id NUMBER;
2717: x_new_to_dist_id NUMBER;
2718: e_error EXCEPTION ;
2719: l_api_name VARCHAR2(100):= 'CSE_ASSET_CREATION_PKG.create_fa_distribution';
2720:
2721: BEGIN
2722: debug('Begin - create distribution');
2723: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

Line 2735: cse_asset_creation_pkg.find_distribution(

2731: l_asset_query_rec.distribution_id := NULL;
2732:
2733: IF l_asset_query_rec.distribution_id IS NULL
2734: THEN
2735: cse_asset_creation_pkg.find_distribution(
2736: l_asset_query_rec
2737: , p_mass_add_rec
2738: , x_new_dist
2739: , x_return_status

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

2837: l_mtl_cost NUMBER ;
2838: l_non_mtl_cost NUMBER ;
2839: l_mtl_ratio NUMBER ;
2840:
2841: l_api_name VARCHAR2(100) := 'CSE_ASSET_CREATION_PKG.find_asset';
2842:
2843: CURSOR dist_history_cur IS
2844: SELECT distribution_id
2845: ,location_id

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

3195: l_init_ext_ret_rec fa_mass_ext_retirements%ROWTYPE ;
3196: l_ext_ret_rec fa_mass_ext_retirements%ROWTYPE ;
3197: l_sysdate DATE := SYSDATE ;
3198:
3199: l_api_name VARCHAR2(100) := 'CSE_ASSET_CREATION_PKG.adjust_asset';
3200: l_total_fa_units NUMBER ;
3201:
3202: CURSOR fa_asset_units (c_asset_id IN NUMBER) IS
3203: SELECT fad.current_units

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

3232:
3233: BEGIN
3234:
3235: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
3236: debug('inside api cse_asset_creation_pkg.adjust_asset');
3237: debug(' asset_id : '||p_asset_query_rec.asset_id);
3238: debug(' units_to_be_adjusted : '||p_mass_add_rec.payables_units);
3239:
3240: l_mass_add_rec := p_mass_add_rec ;

Line 3515: END cse_asset_creation_pkg;

3511: x_return_status := fnd_api.g_ret_sts_error;
3512: x_err_inst_rec := l_inst_rec;
3513: END create_asset;
3514:
3515: END cse_asset_creation_pkg;