APPS.CSE_ASSET_CREATION_PKG dependencies on CSE_DATASTRUCTURES_PUB

Line 261: l_txn_rec.transaction_status_code := cse_datastructures_pub.g_complete ;

257: x_return_status := fnd_api.g_ret_sts_success;
258:
259: l_txn_rec.transaction_id := p_csi_txn_id;
260: l_txn_rec.source_group_ref_id := fnd_global.conc_request_id;
261: l_txn_rec.transaction_status_code := cse_datastructures_pub.g_complete ;
262:
263: SELECT object_version_number
264: INTO l_txn_rec.object_version_number
265: FROM csi_transactions

Line 573: l_asset_attrib_rec cse_datastructures_pub.asset_attrib_rec;

569: x_return_status OUT nocopy varchar2,
570: x_error_message OUT nocopy varchar2)
571: IS
572:
573: l_asset_attrib_rec cse_datastructures_pub.asset_attrib_rec;
574:
575: l_asset_description varchar2(80);
576: l_inst_tbl instance_tbl;
577: l_asset_cost number;

Line 2962: p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec

2958: END create_depreciable_assets;
2959:
2960:
2961: PROCEDURE find_distribution(
2962: p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec
2963: , p_mass_add_rec IN fa_mass_additions%ROWTYPE
2964: , x_new_dist OUT NOCOPY NUMBER
2965: , x_return_status OUT NOCOPY VARCHAR2
2966: , x_error_msg OUT NOCOPY VARCHAR2 )

Line 3045: p_asset_query_rec IN cse_datastructures_pub.asset_query_rec

3041: x_error_msg := fnd_message.get;
3042: END find_distribution ;
3043:
3044: PROCEDURE create_fa_distribution(
3045: p_asset_query_rec IN cse_datastructures_pub.asset_query_rec
3046: , p_mass_add_rec IN fa_mass_additions%ROWTYPE
3047: , x_return_status OUT NOCOPY VARCHAR2
3048: , x_error_msg OUT NOCOPY VARCHAR2 )
3049: IS

Line 3050: l_asset_query_rec cse_datastructures_pub.asset_query_rec ;

3046: , p_mass_add_rec IN fa_mass_additions%ROWTYPE
3047: , x_return_status OUT NOCOPY VARCHAR2
3048: , x_error_msg OUT NOCOPY VARCHAR2 )
3049: IS
3050: l_asset_query_rec cse_datastructures_pub.asset_query_rec ;
3051: x_new_dist NUMBER;
3052: x_new_from_dist_id NUMBER;
3053: x_new_to_dist_id NUMBER;
3054: e_error EXCEPTION ;

Line 3140: p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,

3136: x_error_msg := fnd_message.get;
3137: END create_fa_distribution;
3138:
3139: PROCEDURE find_asset(
3140: p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,
3141: p_distribution_tbl OUT NOCOPY cse_datastructures_pub.distribution_tbl,
3142: x_return_status OUT NOCOPY VARCHAR2,
3143: x_error_msg OUT NOCOPY VARCHAR2 )
3144: IS

Line 3141: p_distribution_tbl OUT NOCOPY cse_datastructures_pub.distribution_tbl,

3137: END create_fa_distribution;
3138:
3139: PROCEDURE find_asset(
3140: p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,
3141: p_distribution_tbl OUT NOCOPY cse_datastructures_pub.distribution_tbl,
3142: x_return_status OUT NOCOPY VARCHAR2,
3143: x_error_msg OUT NOCOPY VARCHAR2 )
3144: IS
3145: l_sql_stmt VARCHAR2(6000);

Line 3365: IF p_asset_query_rec.search_method = cse_datastructures_pub.G_LIFO_SEARCH

3361: debug('l_deprn_expense_ccid :'|| l_deprn_expense_ccid);
3362: debug('l_inventory_item_id :'|| l_inventory_item_id);
3363:
3364:
3365: IF p_asset_query_rec.search_method = cse_datastructures_pub.G_LIFO_SEARCH
3366: THEN
3367: OPEN fa_add_lifo_cur ;
3368: FETCH fa_add_lifo_cur INTO p_asset_query_rec.asset_id
3369: ,p_asset_query_rec.asset_number

Line 3516: p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,

3512: debug(x_error_msg);
3513: END find_asset;
3514:
3515: PROCEDURE adjust_asset(
3516: p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,
3517: p_mass_add_rec IN OUT NOCOPY fa_mass_additions%ROWTYPE,
3518: p_mtl_percent IN NUMBER,
3519: x_return_status OUT NOCOPY VARCHAR2,
3520: x_error_msg OUT NOCOPY VARCHAR2 )