APPS.CSI_INTERFACE_PKG dependencies on CSI_II_RELATIONSHIPS

Line 3968: FROM csi_ii_relationships

3964: active_end_date
3965: INTO l_r_tbl(l_ii_ind).csi_inst_relationship_id,
3966: l_r_tbl(l_ii_ind).object_version_number,
3967: l_rel_end_date
3968: FROM csi_ii_relationships
3969: WHERE subject_id = l_sub_instance_id
3970: AND object_id = l_obj_instance_id;
3971: EXCEPTION
3972: WHEN no_data_found THEN

Line 4244: FROM csi_ii_relationships

4240: -- the same item instance is the subject, get the active_end_date
4241: -- for the last one
4242: SELECT active_end_date
4243: INTO l_rlt_active_end_date
4244: FROM csi_ii_relationships
4245: WHERE relationship_id=
4246: (SELECT max(relationship_id)
4247: FROM csi_ii_relationships
4248: WHERE subject_id = px_txn_line_dtl_tbl(l_td_ind).instance_id

Line 4247: FROM csi_ii_relationships

4243: INTO l_rlt_active_end_date
4244: FROM csi_ii_relationships
4245: WHERE relationship_id=
4246: (SELECT max(relationship_id)
4247: FROM csi_ii_relationships
4248: WHERE subject_id = px_txn_line_dtl_tbl(l_td_ind).instance_id
4249: AND relationship_type_code = l_rel_type_code); -- srramakr added
4250: -- End fix for bug 6964595, FP of bug 6916021
4251: EXCEPTION

Line 4363: p_pkg_name => 'csi_ii_relationships_pub',

4359:
4360: record_time('Start');
4361:
4362: csi_t_gen_utility_pvt.dump_api_info(
4363: p_pkg_name => 'csi_ii_relationships_pub',
4364: p_api_name => 'update_relationship');
4365:
4366: csi_ii_relationships_pub.update_relationship(
4367: p_api_version => 1.0,

Line 4366: csi_ii_relationships_pub.update_relationship(

4362: csi_t_gen_utility_pvt.dump_api_info(
4363: p_pkg_name => 'csi_ii_relationships_pub',
4364: p_api_name => 'update_relationship');
4365:
4366: csi_ii_relationships_pub.update_relationship(
4367: p_api_version => 1.0,
4368: p_commit => fnd_api.g_false,
4369: p_init_msg_list => fnd_api.g_true,
4370: p_validation_level => fnd_api.g_valid_level_full,

Line 4787: p_pkg_name => 'csi_ii_relationships_pub',

4783: IF l_c_ii_rltns_tbl.COUNT > 0 THEN
4784:
4785: record_time('Start');
4786: csi_t_gen_utility_pvt.dump_api_info(
4787: p_pkg_name => 'csi_ii_relationships_pub',
4788: p_api_name => 'create_relationship');
4789:
4790: -- create relationship
4791: csi_ii_relationships_pub.create_relationship(

Line 4791: csi_ii_relationships_pub.create_relationship(

4787: p_pkg_name => 'csi_ii_relationships_pub',
4788: p_api_name => 'create_relationship');
4789:
4790: -- create relationship
4791: csi_ii_relationships_pub.create_relationship(
4792: p_api_version => 1.0,
4793: p_commit => fnd_api.g_false,
4794: p_init_msg_list => fnd_api.g_true,
4795: p_validation_level => fnd_api.g_valid_level_full,

Line 4992: FROM csi_ii_relationships

4988:
4989: BEGIN
4990: SELECT 'Y'
4991: INTO l_found_child
4992: FROM csi_ii_relationships
4993: WHERE object_id = p_instance_id
4994: AND relationship_type_code = 'COMPONENT-OF';
4995:
4996: debug(' This instance already has a child with COMPONENT-OF relation.');