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

Line 163: l_error_rec csi_datastructures_pub.transaction_error_rec;

159: PROCEDURE log_error(
160: p_instance_rec IN instance_rec,
161: p_error_message IN varchar2)
162: IS
163: l_error_rec csi_datastructures_pub.transaction_error_rec;
164: l_error_id number;
165: l_source_type varchar2(20);
166: l_error_message varchar2(2000);
167:

Line 249: l_txn_rec csi_datastructures_pub.transaction_rec;

245: p_csi_txn_id IN number,
246: x_return_status OUT nocopy varchar2,
247: x_error_message OUT nocopy varchar2)
248: IS
249: l_txn_rec csi_datastructures_pub.transaction_rec;
250: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
251: l_msg_count number;
252: l_msg_data varchar2(2000);
253: BEGIN

Line 1045: x_inst_asset_rec OUT nocopy csi_datastructures_pub.instance_asset_rec,

1041:
1042: PROCEDURE get_instance_asset(
1043: p_instance_id IN number,
1044: p_asset_id IN number,
1045: x_inst_asset_rec OUT nocopy csi_datastructures_pub.instance_asset_rec,
1046: x_return_status OUT nocopy varchar2,
1047: x_error_message OUT nocopy varchar2)
1048: IS
1049: l_inst_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;

Line 1049: l_inst_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;

1045: x_inst_asset_rec OUT nocopy csi_datastructures_pub.instance_asset_rec,
1046: x_return_status OUT nocopy varchar2,
1047: x_error_message OUT nocopy varchar2)
1048: IS
1049: l_inst_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
1050: l_inst_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
1051:
1052: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1053: l_msg_count number;

Line 1050: l_inst_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;

1046: x_return_status OUT nocopy varchar2,
1047: x_error_message OUT nocopy varchar2)
1048: IS
1049: l_inst_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
1050: l_inst_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
1051:
1052: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1053: l_msg_count number;
1054: l_msg_data varchar2(2000);

Line 1309: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,

1305: p_action IN varchar2,
1306: p_inst_rec IN instance_rec,
1307: p_mass_addition_id IN number,
1308: p_asset_id IN number,
1309: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
1310: x_inst_asset_rec OUT nocopy csi_datastructures_pub.instance_asset_rec,
1311: x_return_status OUT nocopy varchar2)
1312: IS
1313: l_asset_id number;

Line 1310: x_inst_asset_rec OUT nocopy csi_datastructures_pub.instance_asset_rec,

1306: p_inst_rec IN instance_rec,
1307: p_mass_addition_id IN number,
1308: p_asset_id IN number,
1309: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
1310: x_inst_asset_rec OUT nocopy csi_datastructures_pub.instance_asset_rec,
1311: x_return_status OUT nocopy varchar2)
1312: IS
1313: l_asset_id number;
1314: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec;

Line 1314: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec;

1310: x_inst_asset_rec OUT nocopy csi_datastructures_pub.instance_asset_rec,
1311: x_return_status OUT nocopy varchar2)
1312: IS
1313: l_asset_id number;
1314: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec;
1315: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1316: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1317: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1318: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

Line 1889: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec;

1885:
1886: l_asset_quantity number;
1887: l_obj_ver_num number;
1888:
1889: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec;
1890: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1891: l_error_message varchar2(2000);
1892:
1893: l_msg_count number;

Line 2010: l_csi_txn_rec csi_datastructures_pub.transaction_rec;

2006: p_organization_id IN NUMBER)
2007: IS
2008:
2009: l_pending_status varchar2(30) := 'PENDING';
2010: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
2011: l_ts_tbl txn_status_tbl;
2012: l_ts_ind binary_integer := 0;
2013:
2014: CURSOR csi_pending_txn_cur IS

Line 2077: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;

2073: l_item_description varchar2(240);
2074: l_fa_group_by varchar2(30);
2075: l_mass_addition_id number;
2076: l_fa_action varchar2(30);
2077: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
2078:
2079: CURSOR srl_cur(p_mtl_txn_id IN number) IS
2080: SELECT mut.serial_number serial_number,
2081: to_char(null) lot_number,

Line 2121: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

2117: BEGIN
2118:
2119: cse_util_pkg.set_debug;
2120:
2121: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
2122: csi_gen_utility_pvt.populate_install_param_rec;
2123: END IF;
2124:
2125: l_fa_group_by := csi_datastructures_pub.g_install_param_rec.fa_creation_group_by;

Line 2125: l_fa_group_by := csi_datastructures_pub.g_install_param_rec.fa_creation_group_by;

2121: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
2122: csi_gen_utility_pvt.populate_install_param_rec;
2123: END IF;
2124:
2125: l_fa_group_by := csi_datastructures_pub.g_install_param_rec.fa_creation_group_by;
2126:
2127: l_csi_txn_rec.transaction_type_id := 123; -- instance_asset_tieback
2128: l_csi_txn_rec.source_transaction_date := sysdate;
2129: l_csi_txn_rec.source_group_ref_id := fnd_global.conc_request_id;