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_DEPLOYMENT_GRP dependencies on CSI_DATASTRUCTURES_PUB

Line 29: px_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,

25: p_proceeds_of_sale IN number,
26: p_cost_of_removal IN number,
27: p_operational_flag IN varchar2 default 'N',
28: p_financial_flag IN varchar2 default 'N',
29: px_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
30: x_return_status OUT nocopy varchar2)
31: IS
32:
33: CURSOR inst_asset_cur IS

Line 57: l_source_instance_rec csi_datastructures_pub.instance_rec;

53: l_last_vld_organization_id number;
54: l_object_version_number number;
55:
56:
57: l_source_instance_rec csi_datastructures_pub.instance_rec;
58: l_new_instance_rec csi_datastructures_pub.instance_rec;
59: l_source_instance_qty number;
60: l_new_instance_qty number;
61:

Line 58: l_new_instance_rec csi_datastructures_pub.instance_rec;

54: l_object_version_number number;
55:
56:
57: l_source_instance_rec csi_datastructures_pub.instance_rec;
58: l_new_instance_rec csi_datastructures_pub.instance_rec;
59: l_source_instance_qty number;
60: l_new_instance_qty number;
61:
62: l_u_instance_rec csi_datastructures_pub.instance_rec;

Line 62: l_u_instance_rec csi_datastructures_pub.instance_rec;

58: l_new_instance_rec csi_datastructures_pub.instance_rec;
59: l_source_instance_qty number;
60: l_new_instance_qty number;
61:
62: l_u_instance_rec csi_datastructures_pub.instance_rec;
63: l_u_parties_tbl csi_datastructures_pub.party_tbl;
64: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
65: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
66: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 63: l_u_parties_tbl csi_datastructures_pub.party_tbl;

59: l_source_instance_qty number;
60: l_new_instance_qty number;
61:
62: l_u_instance_rec csi_datastructures_pub.instance_rec;
63: l_u_parties_tbl csi_datastructures_pub.party_tbl;
64: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
65: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
66: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
67: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 64: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

60: l_new_instance_qty number;
61:
62: l_u_instance_rec csi_datastructures_pub.instance_rec;
63: l_u_parties_tbl csi_datastructures_pub.party_tbl;
64: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
65: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
66: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
67: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
68: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 65: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;

61:
62: l_u_instance_rec csi_datastructures_pub.instance_rec;
63: l_u_parties_tbl csi_datastructures_pub.party_tbl;
64: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
65: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
66: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
67: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
68: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
69: l_instance_ids_list csi_datastructures_pub.id_tbl;

Line 66: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

62: l_u_instance_rec csi_datastructures_pub.instance_rec;
63: l_u_parties_tbl csi_datastructures_pub.party_tbl;
64: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
65: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
66: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
67: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
68: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
69: l_instance_ids_list csi_datastructures_pub.id_tbl;
70:

Line 67: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

63: l_u_parties_tbl csi_datastructures_pub.party_tbl;
64: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
65: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
66: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
67: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
68: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
69: l_instance_ids_list csi_datastructures_pub.id_tbl;
70:
71: l_msg_data varchar2(2000);

Line 68: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;

64: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
65: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
66: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
67: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
68: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
69: l_instance_ids_list csi_datastructures_pub.id_tbl;
70:
71: l_msg_data varchar2(2000);
72: l_msg_count number;

Line 69: l_instance_ids_list csi_datastructures_pub.id_tbl;

65: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
66: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
67: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
68: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
69: l_instance_ids_list csi_datastructures_pub.id_tbl;
70:
71: l_msg_data varchar2(2000);
72: l_msg_count number;
73: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 286: l_inst_rec csi_datastructures_pub.instance_header_rec ;

282: x_return_status OUT nocopy varchar2)
283: IS
284:
285: -- giid variables
286: l_inst_rec csi_datastructures_pub.instance_header_rec ;
287: l_pty_tbl csi_datastructures_pub.party_header_tbl ;
288: l_pty_acct_tbl csi_datastructures_pub.party_account_header_tbl ;
289: l_org_tbl csi_datastructures_pub.org_units_header_tbl ;
290: l_price_tbl csi_datastructures_pub.pricing_attribs_tbl ;

Line 287: l_pty_tbl csi_datastructures_pub.party_header_tbl ;

283: IS
284:
285: -- giid variables
286: l_inst_rec csi_datastructures_pub.instance_header_rec ;
287: l_pty_tbl csi_datastructures_pub.party_header_tbl ;
288: l_pty_acct_tbl csi_datastructures_pub.party_account_header_tbl ;
289: l_org_tbl csi_datastructures_pub.org_units_header_tbl ;
290: l_price_tbl csi_datastructures_pub.pricing_attribs_tbl ;
291: l_ea_tbl csi_datastructures_pub.extend_attrib_tbl ;

Line 288: l_pty_acct_tbl csi_datastructures_pub.party_account_header_tbl ;

284:
285: -- giid variables
286: l_inst_rec csi_datastructures_pub.instance_header_rec ;
287: l_pty_tbl csi_datastructures_pub.party_header_tbl ;
288: l_pty_acct_tbl csi_datastructures_pub.party_account_header_tbl ;
289: l_org_tbl csi_datastructures_pub.org_units_header_tbl ;
290: l_price_tbl csi_datastructures_pub.pricing_attribs_tbl ;
291: l_ea_tbl csi_datastructures_pub.extend_attrib_tbl ;
292: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl ;

Line 289: l_org_tbl csi_datastructures_pub.org_units_header_tbl ;

285: -- giid variables
286: l_inst_rec csi_datastructures_pub.instance_header_rec ;
287: l_pty_tbl csi_datastructures_pub.party_header_tbl ;
288: l_pty_acct_tbl csi_datastructures_pub.party_account_header_tbl ;
289: l_org_tbl csi_datastructures_pub.org_units_header_tbl ;
290: l_price_tbl csi_datastructures_pub.pricing_attribs_tbl ;
291: l_ea_tbl csi_datastructures_pub.extend_attrib_tbl ;
292: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
293: l_ia_tbl csi_datastructures_pub.instance_asset_header_tbl;

Line 290: l_price_tbl csi_datastructures_pub.pricing_attribs_tbl ;

286: l_inst_rec csi_datastructures_pub.instance_header_rec ;
287: l_pty_tbl csi_datastructures_pub.party_header_tbl ;
288: l_pty_acct_tbl csi_datastructures_pub.party_account_header_tbl ;
289: l_org_tbl csi_datastructures_pub.org_units_header_tbl ;
290: l_price_tbl csi_datastructures_pub.pricing_attribs_tbl ;
291: l_ea_tbl csi_datastructures_pub.extend_attrib_tbl ;
292: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
293: l_ia_tbl csi_datastructures_pub.instance_asset_header_tbl;
294: l_time_stamp date := null;

Line 291: l_ea_tbl csi_datastructures_pub.extend_attrib_tbl ;

287: l_pty_tbl csi_datastructures_pub.party_header_tbl ;
288: l_pty_acct_tbl csi_datastructures_pub.party_account_header_tbl ;
289: l_org_tbl csi_datastructures_pub.org_units_header_tbl ;
290: l_price_tbl csi_datastructures_pub.pricing_attribs_tbl ;
291: l_ea_tbl csi_datastructures_pub.extend_attrib_tbl ;
292: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
293: l_ia_tbl csi_datastructures_pub.instance_asset_header_tbl;
294: l_time_stamp date := null;
295:

Line 292: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl ;

288: l_pty_acct_tbl csi_datastructures_pub.party_account_header_tbl ;
289: l_org_tbl csi_datastructures_pub.org_units_header_tbl ;
290: l_price_tbl csi_datastructures_pub.pricing_attribs_tbl ;
291: l_ea_tbl csi_datastructures_pub.extend_attrib_tbl ;
292: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
293: l_ia_tbl csi_datastructures_pub.instance_asset_header_tbl;
294: l_time_stamp date := null;
295:
296: -- out variables build

Line 293: l_ia_tbl csi_datastructures_pub.instance_asset_header_tbl;

289: l_org_tbl csi_datastructures_pub.org_units_header_tbl ;
290: l_price_tbl csi_datastructures_pub.pricing_attribs_tbl ;
291: l_ea_tbl csi_datastructures_pub.extend_attrib_tbl ;
292: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
293: l_ia_tbl csi_datastructures_pub.instance_asset_header_tbl;
294: l_time_stamp date := null;
295:
296: -- out variables build
297: l_t_pty_tbl csi_process_txn_grp.txn_i_parties_tbl ;

Line 507: l_txn_rec csi_datastructures_pub.transaction_rec;

503: l_commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;
504: l_init_msg_list VARCHAR2(1) DEFAULT FND_API.G_TRUE;
505: l_validation_level NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL;
506: l_active_instance_only VARCHAR2(1) DEFAULT FND_API.G_TRUE;
507: l_txn_rec csi_datastructures_pub.transaction_rec;
508: l_asset_location_rec csi_datastructures_pub.instance_asset_location_rec;
509: l_asset_location_tbl csi_datastructures_pub.instance_asset_location_tbl;
510: l_nl_pa_interface_tbl CSE_IPA_TRANS_PKG.nl_pa_interface_tbl_type;
511: l_burden_cost_sum NUMBER;

Line 508: l_asset_location_rec csi_datastructures_pub.instance_asset_location_rec;

504: l_init_msg_list VARCHAR2(1) DEFAULT FND_API.G_TRUE;
505: l_validation_level NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL;
506: l_active_instance_only VARCHAR2(1) DEFAULT FND_API.G_TRUE;
507: l_txn_rec csi_datastructures_pub.transaction_rec;
508: l_asset_location_rec csi_datastructures_pub.instance_asset_location_rec;
509: l_asset_location_tbl csi_datastructures_pub.instance_asset_location_tbl;
510: l_nl_pa_interface_tbl CSE_IPA_TRANS_PKG.nl_pa_interface_tbl_type;
511: l_burden_cost_sum NUMBER;
512: l_qty_sum NUMBER;

Line 509: l_asset_location_tbl csi_datastructures_pub.instance_asset_location_tbl;

505: l_validation_level NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL;
506: l_active_instance_only VARCHAR2(1) DEFAULT FND_API.G_TRUE;
507: l_txn_rec csi_datastructures_pub.transaction_rec;
508: l_asset_location_rec csi_datastructures_pub.instance_asset_location_rec;
509: l_asset_location_tbl csi_datastructures_pub.instance_asset_location_tbl;
510: l_nl_pa_interface_tbl CSE_IPA_TRANS_PKG.nl_pa_interface_tbl_type;
511: l_burden_cost_sum NUMBER;
512: l_qty_sum NUMBER;
513: l_sum_of_qty NUMBER;

Line 1130: l_txn_error_rec csi_datastructures_pub.transaction_error_rec ;

1126: p_txn_tbl IN OUT NOCOPY transaction_tbl,
1127: x_return_status OUT NOCOPY VARCHAR2,
1128: x_error_msg OUT NOCOPY VARCHAR2 )
1129: IS
1130: l_txn_error_rec csi_datastructures_pub.transaction_error_rec ;
1131: l_txn_rec csi_datastructures_pub.transaction_rec ;
1132: l_t_inst_tbl csi_process_txn_grp.txn_instances_tbl ;
1133: l_t_party_tbl csi_process_txn_grp.txn_i_parties_tbl ;
1134: l_t_pty_acct_tbl csi_process_txn_grp.txn_ip_accounts_tbl ;

Line 1131: l_txn_rec csi_datastructures_pub.transaction_rec ;

1127: x_return_status OUT NOCOPY VARCHAR2,
1128: x_error_msg OUT NOCOPY VARCHAR2 )
1129: IS
1130: l_txn_error_rec csi_datastructures_pub.transaction_error_rec ;
1131: l_txn_rec csi_datastructures_pub.transaction_rec ;
1132: l_t_inst_tbl csi_process_txn_grp.txn_instances_tbl ;
1133: l_t_party_tbl csi_process_txn_grp.txn_i_parties_tbl ;
1134: l_t_pty_acct_tbl csi_process_txn_grp.txn_ip_accounts_tbl ;
1135: l_t_ou_tbl csi_process_txn_grp.txn_org_units_tbl ;