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_DATASTRUCTURES_PUB

Line 25: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

21: p_instance_id IN NUMBER,
22: p_asset_quantity IN NUMBER,
23: p_Default_inst_status IN VARCHAR2,
24: p_active_end_date IN DATE,
25: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
26: ) IS
27: l_def_Instance_status_id NUMBER;
28: l_h_Instance_status_id NUMBER;
29: l_h_instance_usage_code VARCHAR2(30);

Line 44: l_u_instance_rec csi_datastructures_pub.instance_rec;

40: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
41: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
42: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
43:
44: l_u_instance_rec csi_datastructures_pub.instance_rec;
45: l_u_parties_tbl csi_datastructures_pub.party_tbl;
46: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
47: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
48: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 45: l_u_parties_tbl csi_datastructures_pub.party_tbl;

41: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
42: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
43:
44: l_u_instance_rec csi_datastructures_pub.instance_rec;
45: l_u_parties_tbl csi_datastructures_pub.party_tbl;
46: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
47: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
48: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
49: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 46: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

42: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
43:
44: l_u_instance_rec csi_datastructures_pub.instance_rec;
45: l_u_parties_tbl csi_datastructures_pub.party_tbl;
46: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
47: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
48: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
49: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
50: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 47: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;

43:
44: l_u_instance_rec csi_datastructures_pub.instance_rec;
45: l_u_parties_tbl csi_datastructures_pub.party_tbl;
46: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
47: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
48: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
49: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
50: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
51: l_instance_ids_list csi_datastructures_pub.id_tbl;

Line 48: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

44: l_u_instance_rec csi_datastructures_pub.instance_rec;
45: l_u_parties_tbl csi_datastructures_pub.party_tbl;
46: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
47: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
48: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
49: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
50: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
51: l_instance_ids_list csi_datastructures_pub.id_tbl;
52: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;

Line 49: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

45: l_u_parties_tbl csi_datastructures_pub.party_tbl;
46: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
47: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
48: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
49: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
50: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
51: l_instance_ids_list csi_datastructures_pub.id_tbl;
52: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
53: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;

Line 50: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;

46: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
47: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
48: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
49: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
50: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
51: l_instance_ids_list csi_datastructures_pub.id_tbl;
52: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
53: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
54: l_u_csi_txn_rec csi_datastructures_pub.transaction_rec;

Line 51: l_instance_ids_list csi_datastructures_pub.id_tbl;

47: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
48: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
49: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
50: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
51: l_instance_ids_list csi_datastructures_pub.id_tbl;
52: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
53: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
54: l_u_csi_txn_rec csi_datastructures_pub.transaction_rec;
55: l_Error_Message VARCHAR2(2000);

Line 54: l_u_csi_txn_rec csi_datastructures_pub.transaction_rec;

50: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
51: l_instance_ids_list csi_datastructures_pub.id_tbl;
52: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
53: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
54: l_u_csi_txn_rec csi_datastructures_pub.transaction_rec;
55: l_Error_Message VARCHAR2(2000);
56:
57:
58: BEGIN

Line 186: px_inst_asset_rec IN OUT nocopy csi_datastructures_pub.instance_asset_rec,

182: debug('in others - '||sqlerrm);
183: END Update_IB_Instance;
184:
185: PROCEDURE create_inst_asset(
186: px_inst_asset_rec IN OUT nocopy csi_datastructures_pub.instance_asset_rec,
187: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
188: x_return_status OUT nocopy varchar2)
189: IS
190: l_lookup_tbl csi_asset_pvt.lookup_tbl;

Line 187: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,

183: END Update_IB_Instance;
184:
185: PROCEDURE create_inst_asset(
186: px_inst_asset_rec IN OUT nocopy csi_datastructures_pub.instance_asset_rec,
187: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
188: x_return_status OUT nocopy varchar2)
189: IS
190: l_lookup_tbl csi_asset_pvt.lookup_tbl;
191: l_asset_count_rec csi_asset_pvt.asset_count_rec;

Line 228: px_inst_asset_rec IN OUT nocopy csi_datastructures_pub.instance_asset_rec,

224: x_return_status := fnd_api.g_ret_sts_error;
225: END create_inst_asset;
226:
227: PROCEDURE update_inst_asset(
228: px_inst_asset_rec IN OUT nocopy csi_datastructures_pub.instance_asset_rec,
229: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
230: x_return_status OUT nocopy varchar2)
231: IS
232:

Line 229: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,

225: END create_inst_asset;
226:
227: PROCEDURE update_inst_asset(
228: px_inst_asset_rec IN OUT nocopy csi_datastructures_pub.instance_asset_rec,
229: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
230: x_return_status OUT nocopy varchar2)
231: IS
232:
233: l_lookup_tbl csi_asset_pvt.lookup_tbl;

Line 282: p_inst_asset_tbl IN csi_datastructures_pub.instance_asset_header_tbl)

278: END update_inst_asset;
279:
280:
281: FUNCTION total_inst_asset_qty(
282: p_inst_asset_tbl IN csi_datastructures_pub.instance_asset_header_tbl)
283: RETURN number
284: IS
285: l_total_qty number := 0;
286: BEGIN

Line 298: p_inst_asset_rec IN csi_datastructures_pub.instance_asset_header_rec,

294: END total_inst_asset_qty;
295:
296:
297: PROCEDURE reinstate_inst_asset(
298: p_inst_asset_rec IN csi_datastructures_pub.instance_asset_header_rec,
299: p_units IN number,
300: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
301: x_return_status OUT nocopy varchar2)
302: IS

Line 300: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,

296:
297: PROCEDURE reinstate_inst_asset(
298: p_inst_asset_rec IN csi_datastructures_pub.instance_asset_header_rec,
299: p_units IN number,
300: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
301: x_return_status OUT nocopy varchar2)
302: IS
303:
304: l_inst_asset_qry_rec csi_datastructures_pub.instance_asset_query_rec;

Line 304: l_inst_asset_qry_rec csi_datastructures_pub.instance_asset_query_rec;

300: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
301: x_return_status OUT nocopy varchar2)
302: IS
303:
304: l_inst_asset_qry_rec csi_datastructures_pub.instance_asset_query_rec;
305: l_inst_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
306: l_time_stamp date := null;
307:
308: l_total_inst_asset_qty number := 0;

Line 305: l_inst_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;

301: x_return_status OUT nocopy varchar2)
302: IS
303:
304: l_inst_asset_qry_rec csi_datastructures_pub.instance_asset_query_rec;
305: l_inst_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
306: l_time_stamp date := null;
307:
308: l_total_inst_asset_qty number := 0;
309: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec;

Line 309: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec;

305: l_inst_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
306: l_time_stamp date := null;
307:
308: l_total_inst_asset_qty number := 0;
309: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec;
310:
311: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
312: l_msg_count number;
313: l_msg_data varchar2(2000);

Line 413: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,

409: END reinstate_inst_asset;
410:
411: PROCEDURE retire_inst_asset(
412: p_inst_asset_id IN number,
413: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
414: x_return_status OUT nocopy varchar2)
415: IS
416:
417: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec;

Line 417: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec;

413: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
414: x_return_status OUT nocopy varchar2)
415: IS
416:
417: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec;
418: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
419:
420: BEGIN
421: x_return_status := fnd_api.g_ret_sts_success;

Line 443: p_inst_asset_rec IN csi_datastructures_pub.instance_asset_header_rec,

439: x_return_status := fnd_api.g_ret_sts_error;
440: END retire_inst_asset;
441:
442: PROCEDURE split_inst_asset(
443: p_inst_asset_rec IN csi_datastructures_pub.instance_asset_header_rec,
444: p_quantity IN number,
445: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
446: x_new_inst_asset_id OUT nocopy number,
447: x_return_status OUT nocopy varchar2)

Line 445: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,

441:
442: PROCEDURE split_inst_asset(
443: p_inst_asset_rec IN csi_datastructures_pub.instance_asset_header_rec,
444: p_quantity IN number,
445: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
446: x_new_inst_asset_id OUT nocopy number,
447: x_return_status OUT nocopy varchar2)
448: IS
449: l_old_asset_qty number;

Line 450: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec;

446: x_new_inst_asset_id OUT nocopy number,
447: x_return_status OUT nocopy varchar2)
448: IS
449: l_old_asset_qty number;
450: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec;
451: l_lookup_tbl csi_asset_pvt.lookup_tbl;
452: l_asset_count_rec csi_asset_pvt.asset_count_rec;
453: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
454: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

Line 508: px_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

504: p_asset_id IN NUMBER,
505: p_units IN NUMBER,
506: p_trans_date IN DATE,
507: p_trans_by IN NUMBER,
508: px_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
509: x_return_status OUT NOCOPY VARCHAR2,
510: x_error_message OUT NOCOPY VARCHAR2)
511: IS
512:

Line 513: l_inst_asset_qry_rec csi_datastructures_pub.instance_asset_query_rec;

509: x_return_status OUT NOCOPY VARCHAR2,
510: x_error_message OUT NOCOPY VARCHAR2)
511: IS
512:
513: l_inst_asset_qry_rec csi_datastructures_pub.instance_asset_query_rec;
514: l_inst_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
515: l_time_stamp date := null;
516:
517: l_new_inst_asset_id number;

Line 514: l_inst_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;

510: x_error_message OUT NOCOPY VARCHAR2)
511: IS
512:
513: l_inst_asset_qry_rec csi_datastructures_pub.instance_asset_query_rec;
514: l_inst_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
515: l_time_stamp date := null;
516:
517: l_new_inst_asset_id number;
518: l_total_inst_asset_qty number := 0;

Line 644: l_inst_asset_qry_rec csi_datastructures_pub.instance_asset_query_rec;

640: x_return_status OUT NOCOPY VARCHAR2,
641: x_error_message OUT NOCOPY VARCHAR2)
642: IS
643:
644: l_inst_asset_qry_rec csi_datastructures_pub.instance_asset_query_rec;
645: l_inst_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
646: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
647: l_time_stamp date := null;
648: l_new_inst_asset_id number;

Line 645: l_inst_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;

641: x_error_message OUT NOCOPY VARCHAR2)
642: IS
643:
644: l_inst_asset_qry_rec csi_datastructures_pub.instance_asset_query_rec;
645: l_inst_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
646: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
647: l_time_stamp date := null;
648: l_new_inst_asset_id number;
649:

Line 646: l_csi_txn_rec csi_datastructures_pub.transaction_rec;

642: IS
643:
644: l_inst_asset_qry_rec csi_datastructures_pub.instance_asset_query_rec;
645: l_inst_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
646: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
647: l_time_stamp date := null;
648: l_new_inst_asset_id number;
649:
650: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;