APPS.CSI_INTERFACE_PKG dependencies on CSI_II_RELATIONSHIPS

Line 4060: FROM csi_ii_relationships

4056: active_end_date
4057: INTO l_r_tbl(l_ii_ind).csi_inst_relationship_id,
4058: l_r_tbl(l_ii_ind).object_version_number,
4059: l_rel_end_date
4060: FROM csi_ii_relationships
4061: WHERE subject_id = l_sub_instance_id
4062: AND object_id = l_obj_instance_id;
4063: EXCEPTION
4064: WHEN no_data_found THEN

Line 4350: FROM csi_ii_relationships

4346: -- the same item instance is the subject, get the active_end_date
4347: -- for the last one
4348: SELECT active_end_date
4349: INTO l_rlt_active_end_date
4350: FROM csi_ii_relationships
4351: WHERE relationship_id=
4352: (SELECT max(relationship_id)
4353: FROM csi_ii_relationships
4354: WHERE subject_id = px_txn_line_dtl_tbl(l_td_ind).instance_id

Line 4353: FROM csi_ii_relationships

4349: INTO l_rlt_active_end_date
4350: FROM csi_ii_relationships
4351: WHERE relationship_id=
4352: (SELECT max(relationship_id)
4353: FROM csi_ii_relationships
4354: WHERE subject_id = px_txn_line_dtl_tbl(l_td_ind).instance_id
4355: AND relationship_type_code = l_rel_type_code); -- srramakr added
4356: -- End fix for bug 6964595, FP of bug 6916021
4357: EXCEPTION

Line 4469: p_pkg_name => 'csi_ii_relationships_pub',

4465:
4466: record_time('Start');
4467:
4468: csi_t_gen_utility_pvt.dump_api_info(
4469: p_pkg_name => 'csi_ii_relationships_pub',
4470: p_api_name => 'update_relationship');
4471:
4472: csi_ii_relationships_pub.update_relationship(
4473: p_api_version => 1.0,

Line 4472: csi_ii_relationships_pub.update_relationship(

4468: csi_t_gen_utility_pvt.dump_api_info(
4469: p_pkg_name => 'csi_ii_relationships_pub',
4470: p_api_name => 'update_relationship');
4471:
4472: csi_ii_relationships_pub.update_relationship(
4473: p_api_version => 1.0,
4474: p_commit => fnd_api.g_false,
4475: p_init_msg_list => fnd_api.g_true,
4476: p_validation_level => fnd_api.g_valid_level_full,

Line 4894: p_pkg_name => 'csi_ii_relationships_pub',

4890: IF l_c_ii_rltns_tbl.COUNT > 0 THEN
4891:
4892: record_time('Start');
4893: csi_t_gen_utility_pvt.dump_api_info(
4894: p_pkg_name => 'csi_ii_relationships_pub',
4895: p_api_name => 'create_relationship');
4896:
4897: -- create relationship
4898: csi_ii_relationships_pub.create_relationship(

Line 4898: csi_ii_relationships_pub.create_relationship(

4894: p_pkg_name => 'csi_ii_relationships_pub',
4895: p_api_name => 'create_relationship');
4896:
4897: -- create relationship
4898: csi_ii_relationships_pub.create_relationship(
4899: p_api_version => 1.0,
4900: p_commit => fnd_api.g_false,
4901: p_init_msg_list => fnd_api.g_true,
4902: p_validation_level => fnd_api.g_valid_level_full,

Line 5099: FROM csi_ii_relationships

5095:
5096: BEGIN
5097: SELECT 'Y'
5098: INTO l_found_child
5099: FROM csi_ii_relationships
5100: WHERE object_id = p_instance_id
5101: AND relationship_type_code = 'COMPONENT-OF';
5102:
5103: debug(' This instance already has a child with COMPONENT-OF relation.');