APPS.CSE_FA_INTEGRATION_GRP dependencies on CSI_ASSET_PVT

Line 78: l_lookup_tbl csi_asset_pvt.lookup_tbl;

74: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
75: px_inst_asset_rec IN OUT nocopy csi_datastructures_pub.instance_asset_rec,
76: x_return_status OUT nocopy varchar2)
77: IS
78: l_lookup_tbl csi_asset_pvt.lookup_tbl;
79: l_asset_count_rec csi_asset_pvt.asset_count_rec;
80: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
81: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
82:

Line 79: l_asset_count_rec csi_asset_pvt.asset_count_rec;

75: px_inst_asset_rec IN OUT nocopy csi_datastructures_pub.instance_asset_rec,
76: x_return_status OUT nocopy varchar2)
77: IS
78: l_lookup_tbl csi_asset_pvt.lookup_tbl;
79: l_asset_count_rec csi_asset_pvt.asset_count_rec;
80: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
81: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
82:
83: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 80: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

76: x_return_status OUT nocopy varchar2)
77: IS
78: l_lookup_tbl csi_asset_pvt.lookup_tbl;
79: l_asset_count_rec csi_asset_pvt.asset_count_rec;
80: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
81: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
82:
83: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
84: l_msg_count number;

Line 81: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

77: IS
78: l_lookup_tbl csi_asset_pvt.lookup_tbl;
79: l_asset_count_rec csi_asset_pvt.asset_count_rec;
80: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
81: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
82:
83: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
84: l_msg_count number;
85: l_msg_data varchar2(2000);

Line 92: csi_asset_pvt.create_instance_asset(

88: x_return_status := fnd_api.g_ret_sts_success;
89:
90: px_inst_asset_rec.fa_sync_flag := 'Y';
91:
92: csi_asset_pvt.create_instance_asset(
93: p_api_version => 1.0 ,
94: p_commit => fnd_api.g_false,
95: p_init_msg_list => fnd_api.g_true,
96: p_validation_level => fnd_api.g_valid_level_full,

Line 123: l_lookup_tbl csi_asset_pvt.lookup_tbl;

119: px_inst_asset_rec IN OUT nocopy csi_datastructures_pub.instance_asset_rec,
120: x_return_status OUT nocopy varchar2)
121: IS
122:
123: l_lookup_tbl csi_asset_pvt.lookup_tbl;
124: l_asset_count_rec csi_asset_pvt.asset_count_rec;
125: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
126: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
127:

Line 124: l_asset_count_rec csi_asset_pvt.asset_count_rec;

120: x_return_status OUT nocopy varchar2)
121: IS
122:
123: l_lookup_tbl csi_asset_pvt.lookup_tbl;
124: l_asset_count_rec csi_asset_pvt.asset_count_rec;
125: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
126: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
127:
128: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 125: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

121: IS
122:
123: l_lookup_tbl csi_asset_pvt.lookup_tbl;
124: l_asset_count_rec csi_asset_pvt.asset_count_rec;
125: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
126: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
127:
128: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
129: l_msg_count number;

Line 126: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

122:
123: l_lookup_tbl csi_asset_pvt.lookup_tbl;
124: l_asset_count_rec csi_asset_pvt.asset_count_rec;
125: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
126: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
127:
128: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
129: l_msg_count number;
130: l_msg_data varchar2(2000);

Line 138: csi_asset_pvt.update_instance_asset (

134:
135: px_inst_asset_rec.fa_sync_flag := 'Y';
136: px_inst_asset_rec.check_for_instance_expiry := fnd_api.g_false;
137:
138: csi_asset_pvt.update_instance_asset (
139: p_api_version => 1.0,
140: p_commit => fnd_api.g_false,
141: p_init_msg_list => fnd_api.g_true,
142: p_validation_level => fnd_api.g_valid_level_full,

Line 289: csi_asset_pvt.get_instance_assets(

285: IF l_instance_id is not null THEN
286:
287: l_inst_asset_query_rec.instance_id := l_instance_id;
288:
289: csi_asset_pvt.get_instance_assets(
290: p_api_version => 1.0,
291: p_commit => fnd_api.g_false,
292: p_init_msg_list => fnd_api.g_true,
293: p_validation_level => fnd_api.g_valid_level_full,