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 2940: p_get_csi_iea_values_flag => fnd_api.g_false,

2936: p_get_ext_attrib_vals_flag => fnd_api.g_true,
2937: x_txn_ext_attrib_vals_tbl => o_ext_attrib_tbl,
2938: p_get_csi_attribs_flag => fnd_api.g_false,
2939: x_csi_ext_attribs_tbl => o_csi_ea_tbl,
2940: p_get_csi_iea_values_flag => fnd_api.g_false,
2941: x_csi_iea_values_tbl => o_csi_eav_tbl,
2942: p_get_txn_systems_flag => fnd_api.g_false,
2943: x_txn_systems_tbl => o_txn_systems_tbl,
2944: x_return_status => l_return_status,

Line 2941: x_csi_iea_values_tbl => o_csi_eav_tbl,

2937: x_txn_ext_attrib_vals_tbl => o_ext_attrib_tbl,
2938: p_get_csi_attribs_flag => fnd_api.g_false,
2939: x_csi_ext_attribs_tbl => o_csi_ea_tbl,
2940: p_get_csi_iea_values_flag => fnd_api.g_false,
2941: x_csi_iea_values_tbl => o_csi_eav_tbl,
2942: p_get_txn_systems_flag => fnd_api.g_false,
2943: x_txn_systems_tbl => o_txn_systems_tbl,
2944: x_return_status => l_return_status,
2945: x_msg_count => l_msg_count,

Line 3616: p_get_csi_iea_values_flag => fnd_api.g_false,

3612: p_get_ext_attrib_vals_flag => fnd_api.g_true,
3613: x_txn_ext_attrib_vals_tbl => l_ext_attrib_tbl,
3614: p_get_csi_attribs_flag => fnd_api.g_false,
3615: x_csi_ext_attribs_tbl => l_csi_ea_tbl,
3616: p_get_csi_iea_values_flag => fnd_api.g_false,
3617: x_csi_iea_values_tbl => l_csi_eav_tbl,
3618: p_get_txn_systems_flag => fnd_api.g_false,
3619: x_txn_systems_tbl => l_txn_systems_tbl,
3620: x_return_status => l_return_status,

Line 3617: x_csi_iea_values_tbl => l_csi_eav_tbl,

3613: x_txn_ext_attrib_vals_tbl => l_ext_attrib_tbl,
3614: p_get_csi_attribs_flag => fnd_api.g_false,
3615: x_csi_ext_attribs_tbl => l_csi_ea_tbl,
3616: p_get_csi_iea_values_flag => fnd_api.g_false,
3617: x_csi_iea_values_tbl => l_csi_eav_tbl,
3618: p_get_txn_systems_flag => fnd_api.g_false,
3619: x_txn_systems_tbl => l_txn_systems_tbl,
3620: x_return_status => l_return_status,
3621: x_msg_count => l_msg_count,

Line 3732: p_get_csi_iea_values_flag => fnd_api.g_false,

3728: p_get_ext_attrib_vals_flag => fnd_api.g_true,
3729: x_txn_ext_attrib_vals_tbl => l_ext_attrib_tbl,
3730: p_get_csi_attribs_flag => fnd_api.g_false,
3731: x_csi_ext_attribs_tbl => l_csi_ea_tbl,
3732: p_get_csi_iea_values_flag => fnd_api.g_false,
3733: x_csi_iea_values_tbl => l_csi_eav_tbl,
3734: p_get_txn_systems_flag => fnd_api.g_false,
3735: x_txn_systems_tbl => l_txn_systems_tbl,
3736: x_return_status => x_return_status,

Line 3733: x_csi_iea_values_tbl => l_csi_eav_tbl,

3729: x_txn_ext_attrib_vals_tbl => l_ext_attrib_tbl,
3730: p_get_csi_attribs_flag => fnd_api.g_false,
3731: x_csi_ext_attribs_tbl => l_csi_ea_tbl,
3732: p_get_csi_iea_values_flag => fnd_api.g_false,
3733: x_csi_iea_values_tbl => l_csi_eav_tbl,
3734: p_get_txn_systems_flag => fnd_api.g_false,
3735: x_txn_systems_tbl => l_txn_systems_tbl,
3736: x_return_status => x_return_status,
3737: x_msg_count => x_msg_count,

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

4068: x_cre_ext_attrib_val_tbl(l_cre_ext).attribute15 := p_txn_ext_attrib_vals_tbl(j).attribute15 ;
4069: x_cre_ext_attrib_val_tbl(l_cre_ext).object_version_number := FND_API.G_MISS_NUM;
4070:
4071: l_cre_ext := l_cre_ext + 1;
4072: ELSIF (p_txn_ext_attrib_vals_tbl(j).attrib_source_table = 'CSI_IEA_VALUES') THEN
4073:
4074: l_obj_ver_num := csi_utl_pkg.get_ext_obj_ver_num(
4075: p_txn_ext_attrib_vals_tbl(j).attribute_source_id);
4076:

Line 4410: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;

4406: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
4407: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
4408: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
4409: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
4410: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
4411: x_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
4412: x_msg_count NUMBER ;
4413: x_msg_data VARCHAR2(2000);
4414: x_xface_to_IB_flag VARCHAR2(1);

Line 5470: p_get_csi_iea_values_flag => fnd_api.g_false,

5466: p_get_ext_attrib_vals_flag => fnd_api.g_true,
5467: x_txn_ext_attrib_vals_tbl => l_ext_attrib_tbl,
5468: p_get_csi_attribs_flag => fnd_api.g_false,
5469: x_csi_ext_attribs_tbl => l_csi_ea_tbl,
5470: p_get_csi_iea_values_flag => fnd_api.g_false,
5471: x_csi_iea_values_tbl => l_csi_eav_tbl,
5472: p_get_txn_systems_flag => fnd_api.g_false,
5473: x_txn_systems_tbl => l_txn_systems_tbl,
5474: x_return_status => x_return_status,

Line 5471: x_csi_iea_values_tbl => l_csi_eav_tbl,

5467: x_txn_ext_attrib_vals_tbl => l_ext_attrib_tbl,
5468: p_get_csi_attribs_flag => fnd_api.g_false,
5469: x_csi_ext_attribs_tbl => l_csi_ea_tbl,
5470: p_get_csi_iea_values_flag => fnd_api.g_false,
5471: x_csi_iea_values_tbl => l_csi_eav_tbl,
5472: p_get_txn_systems_flag => fnd_api.g_false,
5473: x_txn_systems_tbl => l_txn_systems_tbl,
5474: x_return_status => x_return_status,
5475: x_msg_count => x_msg_count,

Line 6387: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;

6383: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6384: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
6385: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
6386: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6387: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
6388: x_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
6389: x_msg_count NUMBER ;
6390: x_msg_data VARCHAR2(2000);
6391: l_index NUMBER := 0 ;

Line 6474: p_get_csi_iea_values_flag => fnd_api.g_false,

6470: p_get_ext_attrib_vals_flag => fnd_api.g_false,
6471: x_txn_ext_attrib_vals_tbl => x_txn_ext_attrib_vals_tbl,
6472: p_get_csi_attribs_flag => fnd_api.g_false,
6473: x_csi_ext_attribs_tbl => x_csi_ext_attribs_tbl,
6474: p_get_csi_iea_values_flag => fnd_api.g_false,
6475: x_csi_iea_values_tbl => x_csi_iea_values_tbl ,
6476: p_get_txn_systems_flag => fnd_api.g_false ,
6477: x_txn_systems_tbl => x_txn_systems_tbl ,
6478: x_return_status => x_return_status,

Line 6475: x_csi_iea_values_tbl => x_csi_iea_values_tbl ,

6471: x_txn_ext_attrib_vals_tbl => x_txn_ext_attrib_vals_tbl,
6472: p_get_csi_attribs_flag => fnd_api.g_false,
6473: x_csi_ext_attribs_tbl => x_csi_ext_attribs_tbl,
6474: p_get_csi_iea_values_flag => fnd_api.g_false,
6475: x_csi_iea_values_tbl => x_csi_iea_values_tbl ,
6476: p_get_txn_systems_flag => fnd_api.g_false ,
6477: x_txn_systems_tbl => x_txn_systems_tbl ,
6478: x_return_status => x_return_status,
6479: x_msg_count => x_msg_count,

Line 7148: p_get_csi_iea_values_flag => fnd_api.g_false,

7144: p_get_ext_attrib_vals_flag => fnd_api.g_false,
7145: x_txn_ext_attrib_vals_tbl => l_ext_attrib_tbl,
7146: p_get_csi_attribs_flag => fnd_api.g_false,
7147: x_csi_ext_attribs_tbl => l_csi_ea_tbl,
7148: p_get_csi_iea_values_flag => fnd_api.g_false,
7149: x_csi_iea_values_tbl => l_csi_eav_tbl,
7150: p_get_txn_systems_flag => fnd_api.g_false,
7151: x_txn_systems_tbl => l_txn_systems_tbl,
7152: x_return_status => l_return_status,

Line 7149: x_csi_iea_values_tbl => l_csi_eav_tbl,

7145: x_txn_ext_attrib_vals_tbl => l_ext_attrib_tbl,
7146: p_get_csi_attribs_flag => fnd_api.g_false,
7147: x_csi_ext_attribs_tbl => l_csi_ea_tbl,
7148: p_get_csi_iea_values_flag => fnd_api.g_false,
7149: x_csi_iea_values_tbl => l_csi_eav_tbl,
7150: p_get_txn_systems_flag => fnd_api.g_false,
7151: x_txn_systems_tbl => l_txn_systems_tbl,
7152: x_return_status => l_return_status,
7153: x_msg_count => l_msg_count,