eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSE_FA_TXN_PKG dependencies on CSI_ASSET_PVT

Line 25: l_lookup_tbl csi_asset_pvt.lookup_tbl;

21: px_inst_asset_rec IN OUT nocopy csi_datastructures_pub.instance_asset_rec,
22: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
23: x_return_status OUT nocopy varchar2)
24: IS
25: l_lookup_tbl csi_asset_pvt.lookup_tbl;
26: l_asset_count_rec csi_asset_pvt.asset_count_rec;
27: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
28: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
29:

Line 26: l_asset_count_rec csi_asset_pvt.asset_count_rec;

22: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
23: x_return_status OUT nocopy varchar2)
24: IS
25: l_lookup_tbl csi_asset_pvt.lookup_tbl;
26: l_asset_count_rec csi_asset_pvt.asset_count_rec;
27: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
28: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
29:
30: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 27: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

23: x_return_status OUT nocopy varchar2)
24: IS
25: l_lookup_tbl csi_asset_pvt.lookup_tbl;
26: l_asset_count_rec csi_asset_pvt.asset_count_rec;
27: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
28: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
29:
30: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
31: l_msg_count number;

Line 28: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

24: IS
25: l_lookup_tbl csi_asset_pvt.lookup_tbl;
26: l_asset_count_rec csi_asset_pvt.asset_count_rec;
27: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
28: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
29:
30: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
31: l_msg_count number;
32: l_msg_data varchar2(2000);

Line 38: csi_asset_pvt.create_instance_asset(

34: x_return_status := fnd_api.g_ret_sts_success;
35:
36: px_inst_asset_rec.fa_sync_flag := 'Y';
37:
38: csi_asset_pvt.create_instance_asset(
39: p_api_version => 1.0 ,
40: p_commit => fnd_api.g_false,
41: p_init_msg_list => fnd_api.g_true,
42: p_validation_level => fnd_api.g_valid_level_full,

Line 68: l_lookup_tbl csi_asset_pvt.lookup_tbl;

64: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
65: x_return_status OUT nocopy varchar2)
66: IS
67:
68: l_lookup_tbl csi_asset_pvt.lookup_tbl;
69: l_asset_count_rec csi_asset_pvt.asset_count_rec;
70: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
71: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
72:

Line 69: l_asset_count_rec csi_asset_pvt.asset_count_rec;

65: x_return_status OUT nocopy varchar2)
66: IS
67:
68: l_lookup_tbl csi_asset_pvt.lookup_tbl;
69: l_asset_count_rec csi_asset_pvt.asset_count_rec;
70: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
71: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
72:
73: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 70: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

66: IS
67:
68: l_lookup_tbl csi_asset_pvt.lookup_tbl;
69: l_asset_count_rec csi_asset_pvt.asset_count_rec;
70: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
71: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
72:
73: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
74: l_msg_count number;

Line 71: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

67:
68: l_lookup_tbl csi_asset_pvt.lookup_tbl;
69: l_asset_count_rec csi_asset_pvt.asset_count_rec;
70: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
71: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
72:
73: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
74: l_msg_count number;
75: l_msg_data varchar2(2000);

Line 89: csi_asset_pvt.update_instance_asset (

85: INTO px_inst_asset_rec.object_version_number
86: FROM csi_i_assets
87: WHERE instance_asset_id = px_inst_asset_rec.instance_asset_id;
88:
89: csi_asset_pvt.update_instance_asset (
90: p_api_version => 1.0,
91: p_commit => fnd_api.g_false,
92: p_init_msg_list => fnd_api.g_true,
93: p_validation_level => fnd_api.g_valid_level_full,

Line 159: csi_asset_pvt.get_instance_assets(

155: l_inst_asset_qry_rec.fa_book_type_code := p_inst_asset_rec.fa_book_type_code;
156: l_inst_asset_qry_rec.fa_location_id := p_inst_asset_rec.fa_location_id;
157: l_inst_asset_qry_rec.update_status := 'IN_SERVICE';
158:
159: csi_asset_pvt.get_instance_assets(
160: p_api_version => 1.0,
161: p_commit => fnd_api.g_false,
162: p_init_msg_list => fnd_api.g_true,
163: p_validation_level => fnd_api.g_valid_level_full,

Line 258: l_lookup_tbl csi_asset_pvt.lookup_tbl;

254: x_return_status OUT nocopy varchar2)
255: IS
256: l_old_asset_qty number;
257: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec;
258: l_lookup_tbl csi_asset_pvt.lookup_tbl;
259: l_asset_count_rec csi_asset_pvt.asset_count_rec;
260: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
261: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
262:

Line 259: l_asset_count_rec csi_asset_pvt.asset_count_rec;

255: IS
256: l_old_asset_qty number;
257: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec;
258: l_lookup_tbl csi_asset_pvt.lookup_tbl;
259: l_asset_count_rec csi_asset_pvt.asset_count_rec;
260: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
261: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
262:
263: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 260: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

256: l_old_asset_qty number;
257: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec;
258: l_lookup_tbl csi_asset_pvt.lookup_tbl;
259: l_asset_count_rec csi_asset_pvt.asset_count_rec;
260: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
261: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
262:
263: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
264: l_msg_count number;

Line 261: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

257: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec;
258: l_lookup_tbl csi_asset_pvt.lookup_tbl;
259: l_asset_count_rec csi_asset_pvt.asset_count_rec;
260: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
261: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
262:
263: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
264: l_msg_count number;
265: l_msg_data varchar2(2000);

Line 342: csi_asset_pvt.get_instance_assets(

338: l_inst_asset_qry_rec.fa_asset_id := p_asset_id;
339: l_inst_asset_qry_rec.fa_book_type_code := p_book_type_code;
340: l_inst_asset_qry_rec.update_status := 'IN_SERVICE';
341:
342: csi_asset_pvt.get_instance_assets(
343: p_api_version => 1.0,
344: p_commit => fnd_api.g_false,
345: p_init_msg_list => fnd_api.g_true,
346: p_validation_level => fnd_api.g_valid_level_full,

Line 481: csi_asset_pvt.get_instance_assets(

477: l_inst_asset_qry_rec.fa_book_type_code := p_book_type_code;
478: l_inst_asset_qry_rec.update_status := 'RETIRED';
479: l_inst_asset_qry_rec.fa_location_id := dist_rec.location_id;
480:
481: csi_asset_pvt.get_instance_assets(
482: p_api_version => 1.0,
483: p_commit => fnd_api.g_false,
484: p_init_msg_list => fnd_api.g_true,
485: p_validation_level => fnd_api.g_valid_level_full,