DBA Data[Home] [Help]

APPS.CSE_ASSET_CREATION_PKG dependencies on CSI_DATASTRUCTURES_PUB

Line 165: l_error_rec csi_datastructures_pub.transaction_error_rec;

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

Line 251: l_txn_rec csi_datastructures_pub.transaction_rec;

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

Line 1086: x_inst_asset_rec OUT nocopy csi_datastructures_pub.instance_asset_rec,

1082:
1083: PROCEDURE get_instance_asset(
1084: p_instance_id IN number,
1085: p_asset_id IN number,
1086: x_inst_asset_rec OUT nocopy csi_datastructures_pub.instance_asset_rec,
1087: x_return_status OUT nocopy varchar2,
1088: x_error_message OUT nocopy varchar2)
1089: IS
1090: l_inst_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;

Line 1090: l_inst_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;

1086: x_inst_asset_rec OUT nocopy csi_datastructures_pub.instance_asset_rec,
1087: x_return_status OUT nocopy varchar2,
1088: x_error_message OUT nocopy varchar2)
1089: IS
1090: l_inst_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
1091: l_inst_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
1092:
1093: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1094: l_msg_count number;

Line 1091: l_inst_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;

1087: x_return_status OUT nocopy varchar2,
1088: x_error_message OUT nocopy varchar2)
1089: IS
1090: l_inst_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
1091: l_inst_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
1092:
1093: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1094: l_msg_count number;
1095: l_msg_data varchar2(2000);

Line 1350: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,

1346: p_action IN varchar2,
1347: p_inst_rec IN instance_rec,
1348: p_mass_addition_id IN number,
1349: p_asset_id IN number,
1350: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
1351: x_inst_asset_rec OUT nocopy csi_datastructures_pub.instance_asset_rec,
1352: x_return_status OUT nocopy varchar2)
1353: IS
1354: l_asset_id number;

Line 1351: x_inst_asset_rec OUT nocopy csi_datastructures_pub.instance_asset_rec,

1347: p_inst_rec IN instance_rec,
1348: p_mass_addition_id IN number,
1349: p_asset_id IN number,
1350: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
1351: x_inst_asset_rec OUT nocopy csi_datastructures_pub.instance_asset_rec,
1352: x_return_status OUT nocopy varchar2)
1353: IS
1354: l_asset_id number;
1355: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec;

Line 1355: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec;

1351: x_inst_asset_rec OUT nocopy csi_datastructures_pub.instance_asset_rec,
1352: x_return_status OUT nocopy varchar2)
1353: IS
1354: l_asset_id number;
1355: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec;
1356: l_lookup_tbl csi_asset_pvt.lookup_tbl;
1357: l_asset_count_rec csi_asset_pvt.asset_count_rec;
1358: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1359: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

Line 1998: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec;

1994:
1995: l_asset_quantity number;
1996: l_obj_ver_num number;
1997:
1998: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec;
1999: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2000: l_error_message varchar2(2000);
2001:
2002: l_msg_count number;

Line 2154: l_csi_txn_rec csi_datastructures_pub.transaction_rec;

2150: p_organization_id IN NUMBER)
2151: IS
2152:
2153: l_pending_status varchar2(30) := 'PENDING';
2154: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
2155: l_ts_tbl txn_status_tbl;
2156: l_ts_ind binary_integer := 0;
2157:
2158: CURSOR csi_pending_txn_cur IS

Line 2223: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;

2219: l_item_description varchar2(240);
2220: l_fa_group_by varchar2(30);
2221: l_mass_addition_id number;
2222: l_fa_action varchar2(30);
2223: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
2224: l_asset_exists varchar2(1) := 'N'; --Added For bug9141680
2225: l_inventory_asset_flag varchar2(1) := 'Y'; --Added For bug 9488846
2226: l_exp_subinv_flag varchar2(1) := 'N'; --Added For bug 9488846
2227: l_create_asset_for_exp varchar2(1) := 'Y'; --Added For bug 9488846

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

2279: BEGIN
2280:
2281: cse_util_pkg.set_debug;
2282:
2283: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
2284: csi_gen_utility_pvt.populate_install_param_rec;
2285: END IF;
2286:
2287: l_asset_creation_txn_subtype :=nvl(FND_PROFILE.VALUE('CSE_TXN_SUBTYPE_ASSET_CREATION'), 0);--Added for ER#16265912

Line 2293: --l_fa_group_by := csi_datastructures_pub.g_install_param_rec.fa_creation_group_by;

2289: debug('l_asset_creation_txn_subtype : '||l_asset_creation_txn_subtype);
2290:
2291: -- Bug 10034398
2292: -- Moving this inside the loop
2293: --l_fa_group_by := csi_datastructures_pub.g_install_param_rec.fa_creation_group_by;
2294:
2295: l_csi_txn_rec.transaction_type_id := 123; -- instance_asset_tieback
2296: l_csi_txn_rec.source_transaction_date := sysdate;
2297: l_csi_txn_rec.source_group_ref_id := fnd_global.conc_request_id;

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

2367:
2368: -- Bug 10034398
2369: -- Fetching group by option before start of loop
2370:
2371: l_fa_group_by := csi_datastructures_pub.g_install_param_rec.fa_creation_group_by;
2372:
2373: l_inst_tbl.delete;
2374: inst_ind := 0;
2375: