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.CSI_UTL_PKG dependencies on CSI_IEA_VALUES

Line 170: FROM csi_iea_values

166: SELECT object_version_number,
167: attribute_value_id
168: INTO x_obj_version_number,
169: x_attribute_value_id
170: FROM csi_iea_values
171: WHERE instance_id = p_instance_id
172: AND attribute_id = p_attribute_id
173: AND ((active_end_date is null ) OR
174: (active_end_date > sysdate));

Line 349: FROM csi_iea_values

345: api_log('get_ext_obj_ver_num');
346:
347: SELECT object_version_number
348: INTO l_obj_ver_num
349: FROM csi_iea_values
350: WHERE attribute_value_id = p_attrib_value_id
351: AND ((active_end_date is null ) OR
352: (active_end_date > sysdate));
353: RETURN l_obj_ver_num;

Line 2898: p_get_csi_iea_values_flag => fnd_api.g_false,

2894: p_get_ext_attrib_vals_flag => fnd_api.g_true,
2895: x_txn_ext_attrib_vals_tbl => o_ext_attrib_tbl,
2896: p_get_csi_attribs_flag => fnd_api.g_false,
2897: x_csi_ext_attribs_tbl => o_csi_ea_tbl,
2898: p_get_csi_iea_values_flag => fnd_api.g_false,
2899: x_csi_iea_values_tbl => o_csi_eav_tbl,
2900: p_get_txn_systems_flag => fnd_api.g_false,
2901: x_txn_systems_tbl => o_txn_systems_tbl,
2902: x_return_status => l_return_status,

Line 2899: x_csi_iea_values_tbl => o_csi_eav_tbl,

2895: x_txn_ext_attrib_vals_tbl => o_ext_attrib_tbl,
2896: p_get_csi_attribs_flag => fnd_api.g_false,
2897: x_csi_ext_attribs_tbl => o_csi_ea_tbl,
2898: p_get_csi_iea_values_flag => fnd_api.g_false,
2899: x_csi_iea_values_tbl => o_csi_eav_tbl,
2900: p_get_txn_systems_flag => fnd_api.g_false,
2901: x_txn_systems_tbl => o_txn_systems_tbl,
2902: x_return_status => l_return_status,
2903: x_msg_count => l_msg_count,

Line 3574: p_get_csi_iea_values_flag => fnd_api.g_false,

3570: p_get_ext_attrib_vals_flag => fnd_api.g_true,
3571: x_txn_ext_attrib_vals_tbl => l_ext_attrib_tbl,
3572: p_get_csi_attribs_flag => fnd_api.g_false,
3573: x_csi_ext_attribs_tbl => l_csi_ea_tbl,
3574: p_get_csi_iea_values_flag => fnd_api.g_false,
3575: x_csi_iea_values_tbl => l_csi_eav_tbl,
3576: p_get_txn_systems_flag => fnd_api.g_false,
3577: x_txn_systems_tbl => l_txn_systems_tbl,
3578: x_return_status => l_return_status,

Line 3575: x_csi_iea_values_tbl => l_csi_eav_tbl,

3571: x_txn_ext_attrib_vals_tbl => l_ext_attrib_tbl,
3572: p_get_csi_attribs_flag => fnd_api.g_false,
3573: x_csi_ext_attribs_tbl => l_csi_ea_tbl,
3574: p_get_csi_iea_values_flag => fnd_api.g_false,
3575: x_csi_iea_values_tbl => l_csi_eav_tbl,
3576: p_get_txn_systems_flag => fnd_api.g_false,
3577: x_txn_systems_tbl => l_txn_systems_tbl,
3578: x_return_status => l_return_status,
3579: x_msg_count => l_msg_count,

Line 3690: p_get_csi_iea_values_flag => fnd_api.g_false,

3686: p_get_ext_attrib_vals_flag => fnd_api.g_true,
3687: x_txn_ext_attrib_vals_tbl => l_ext_attrib_tbl,
3688: p_get_csi_attribs_flag => fnd_api.g_false,
3689: x_csi_ext_attribs_tbl => l_csi_ea_tbl,
3690: p_get_csi_iea_values_flag => fnd_api.g_false,
3691: x_csi_iea_values_tbl => l_csi_eav_tbl,
3692: p_get_txn_systems_flag => fnd_api.g_false,
3693: x_txn_systems_tbl => l_txn_systems_tbl,
3694: x_return_status => x_return_status,

Line 3691: x_csi_iea_values_tbl => l_csi_eav_tbl,

3687: x_txn_ext_attrib_vals_tbl => l_ext_attrib_tbl,
3688: p_get_csi_attribs_flag => fnd_api.g_false,
3689: x_csi_ext_attribs_tbl => l_csi_ea_tbl,
3690: p_get_csi_iea_values_flag => fnd_api.g_false,
3691: x_csi_iea_values_tbl => l_csi_eav_tbl,
3692: p_get_txn_systems_flag => fnd_api.g_false,
3693: x_txn_systems_tbl => l_txn_systems_tbl,
3694: x_return_status => x_return_status,
3695: x_msg_count => x_msg_count,

Line 4030: ELSIF (p_txn_ext_attrib_vals_tbl(j).attrib_source_table = 'CSI_IEA_VALUES') THEN

4026: x_cre_ext_attrib_val_tbl(l_cre_ext).attribute15 := p_txn_ext_attrib_vals_tbl(j).attribute15 ;
4027: x_cre_ext_attrib_val_tbl(l_cre_ext).object_version_number := FND_API.G_MISS_NUM;
4028:
4029: l_cre_ext := l_cre_ext + 1;
4030: ELSIF (p_txn_ext_attrib_vals_tbl(j).attrib_source_table = 'CSI_IEA_VALUES') THEN
4031:
4032: l_obj_ver_num := csi_utl_pkg.get_ext_obj_ver_num(
4033: p_txn_ext_attrib_vals_tbl(j).attribute_source_id);
4034:

Line 4368: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;

4364: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
4365: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
4366: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
4367: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
4368: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
4369: x_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
4370: x_msg_count NUMBER ;
4371: x_msg_data VARCHAR2(2000);
4372: x_xface_to_IB_flag VARCHAR2(1);

Line 5391: p_get_csi_iea_values_flag => fnd_api.g_false,

5387: p_get_ext_attrib_vals_flag => fnd_api.g_true,
5388: x_txn_ext_attrib_vals_tbl => l_ext_attrib_tbl,
5389: p_get_csi_attribs_flag => fnd_api.g_false,
5390: x_csi_ext_attribs_tbl => l_csi_ea_tbl,
5391: p_get_csi_iea_values_flag => fnd_api.g_false,
5392: x_csi_iea_values_tbl => l_csi_eav_tbl,
5393: p_get_txn_systems_flag => fnd_api.g_false,
5394: x_txn_systems_tbl => l_txn_systems_tbl,
5395: x_return_status => x_return_status,

Line 5392: x_csi_iea_values_tbl => l_csi_eav_tbl,

5388: x_txn_ext_attrib_vals_tbl => l_ext_attrib_tbl,
5389: p_get_csi_attribs_flag => fnd_api.g_false,
5390: x_csi_ext_attribs_tbl => l_csi_ea_tbl,
5391: p_get_csi_iea_values_flag => fnd_api.g_false,
5392: x_csi_iea_values_tbl => l_csi_eav_tbl,
5393: p_get_txn_systems_flag => fnd_api.g_false,
5394: x_txn_systems_tbl => l_txn_systems_tbl,
5395: x_return_status => x_return_status,
5396: x_msg_count => x_msg_count,

Line 6308: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;

6304: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6305: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
6306: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
6307: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6308: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
6309: x_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
6310: x_msg_count NUMBER ;
6311: x_msg_data VARCHAR2(2000);
6312: l_index NUMBER := 0 ;

Line 6395: p_get_csi_iea_values_flag => fnd_api.g_false,

6391: p_get_ext_attrib_vals_flag => fnd_api.g_false,
6392: x_txn_ext_attrib_vals_tbl => x_txn_ext_attrib_vals_tbl,
6393: p_get_csi_attribs_flag => fnd_api.g_false,
6394: x_csi_ext_attribs_tbl => x_csi_ext_attribs_tbl,
6395: p_get_csi_iea_values_flag => fnd_api.g_false,
6396: x_csi_iea_values_tbl => x_csi_iea_values_tbl ,
6397: p_get_txn_systems_flag => fnd_api.g_false ,
6398: x_txn_systems_tbl => x_txn_systems_tbl ,
6399: x_return_status => x_return_status,

Line 6396: x_csi_iea_values_tbl => x_csi_iea_values_tbl ,

6392: x_txn_ext_attrib_vals_tbl => x_txn_ext_attrib_vals_tbl,
6393: p_get_csi_attribs_flag => fnd_api.g_false,
6394: x_csi_ext_attribs_tbl => x_csi_ext_attribs_tbl,
6395: p_get_csi_iea_values_flag => fnd_api.g_false,
6396: x_csi_iea_values_tbl => x_csi_iea_values_tbl ,
6397: p_get_txn_systems_flag => fnd_api.g_false ,
6398: x_txn_systems_tbl => x_txn_systems_tbl ,
6399: x_return_status => x_return_status,
6400: x_msg_count => x_msg_count,

Line 7060: p_get_csi_iea_values_flag => fnd_api.g_false,

7056: p_get_ext_attrib_vals_flag => fnd_api.g_false,
7057: x_txn_ext_attrib_vals_tbl => l_ext_attrib_tbl,
7058: p_get_csi_attribs_flag => fnd_api.g_false,
7059: x_csi_ext_attribs_tbl => l_csi_ea_tbl,
7060: p_get_csi_iea_values_flag => fnd_api.g_false,
7061: x_csi_iea_values_tbl => l_csi_eav_tbl,
7062: p_get_txn_systems_flag => fnd_api.g_false,
7063: x_txn_systems_tbl => l_txn_systems_tbl,
7064: x_return_status => l_return_status,

Line 7061: x_csi_iea_values_tbl => l_csi_eav_tbl,

7057: x_txn_ext_attrib_vals_tbl => l_ext_attrib_tbl,
7058: p_get_csi_attribs_flag => fnd_api.g_false,
7059: x_csi_ext_attribs_tbl => l_csi_ea_tbl,
7060: p_get_csi_iea_values_flag => fnd_api.g_false,
7061: x_csi_iea_values_tbl => l_csi_eav_tbl,
7062: p_get_txn_systems_flag => fnd_api.g_false,
7063: x_txn_systems_tbl => l_txn_systems_tbl,
7064: x_return_status => l_return_status,
7065: x_msg_count => l_msg_count,