APPS.CSE_ASSET_CREATION_PKG dependencies on CSE_DATASTRUCTURES_PUB

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

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

Line 557: l_asset_attrib_rec cse_datastructures_pub.asset_attrib_rec;

553: x_return_status OUT nocopy varchar2,
554: x_error_message OUT nocopy varchar2)
555: IS
556:
557: l_asset_attrib_rec cse_datastructures_pub.asset_attrib_rec;
558:
559: l_asset_description varchar2(80);
560: l_inst_tbl instance_tbl;
561: l_asset_cost number;

Line 2626: p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec

2622: END create_depreciable_assets;
2623:
2624:
2625: PROCEDURE find_distribution(
2626: p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec
2627: , p_mass_add_rec IN fa_mass_additions%ROWTYPE
2628: , x_new_dist OUT NOCOPY NUMBER
2629: , x_return_status OUT NOCOPY VARCHAR2
2630: , x_error_msg OUT NOCOPY VARCHAR2 )

Line 2709: p_asset_query_rec IN cse_datastructures_pub.asset_query_rec

2705: x_error_msg := fnd_message.get;
2706: END find_distribution ;
2707:
2708: PROCEDURE create_fa_distribution(
2709: p_asset_query_rec IN cse_datastructures_pub.asset_query_rec
2710: , p_mass_add_rec IN fa_mass_additions%ROWTYPE
2711: , x_return_status OUT NOCOPY VARCHAR2
2712: , x_error_msg OUT NOCOPY VARCHAR2 )
2713: IS

Line 2714: l_asset_query_rec cse_datastructures_pub.asset_query_rec ;

2710: , p_mass_add_rec IN fa_mass_additions%ROWTYPE
2711: , x_return_status OUT NOCOPY VARCHAR2
2712: , x_error_msg OUT NOCOPY VARCHAR2 )
2713: IS
2714: l_asset_query_rec cse_datastructures_pub.asset_query_rec ;
2715: x_new_dist NUMBER;
2716: x_new_from_dist_id NUMBER;
2717: x_new_to_dist_id NUMBER;
2718: e_error EXCEPTION ;

Line 2804: p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,

2800: x_error_msg := fnd_message.get;
2801: END create_fa_distribution;
2802:
2803: PROCEDURE find_asset(
2804: p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,
2805: p_distribution_tbl OUT NOCOPY cse_datastructures_pub.distribution_tbl,
2806: x_return_status OUT NOCOPY VARCHAR2,
2807: x_error_msg OUT NOCOPY VARCHAR2 )
2808: IS

Line 2805: p_distribution_tbl OUT NOCOPY cse_datastructures_pub.distribution_tbl,

2801: END create_fa_distribution;
2802:
2803: PROCEDURE find_asset(
2804: p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,
2805: p_distribution_tbl OUT NOCOPY cse_datastructures_pub.distribution_tbl,
2806: x_return_status OUT NOCOPY VARCHAR2,
2807: x_error_msg OUT NOCOPY VARCHAR2 )
2808: IS
2809: l_sql_stmt VARCHAR2(6000);

Line 3029: IF p_asset_query_rec.search_method = cse_datastructures_pub.G_LIFO_SEARCH

3025: debug('l_deprn_expense_ccid :'|| l_deprn_expense_ccid);
3026: debug('l_inventory_item_id :'|| l_inventory_item_id);
3027:
3028:
3029: IF p_asset_query_rec.search_method = cse_datastructures_pub.G_LIFO_SEARCH
3030: THEN
3031: OPEN fa_add_lifo_cur ;
3032: FETCH fa_add_lifo_cur INTO p_asset_query_rec.asset_id
3033: ,p_asset_query_rec.asset_number

Line 3180: p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,

3176: debug(x_error_msg);
3177: END find_asset;
3178:
3179: PROCEDURE adjust_asset(
3180: p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,
3181: p_mass_add_rec IN OUT NOCOPY fa_mass_additions%ROWTYPE,
3182: p_mtl_percent IN NUMBER,
3183: x_return_status OUT NOCOPY VARCHAR2,
3184: x_error_msg OUT NOCOPY VARCHAR2 )