APPS.CSI_PROCESS_TXN_PVT dependencies on CSI_II_RELATIONSHIPS

Line 3136: FROM csi_ii_relationships

3132: SELECT 'Y'
3133: INTO l_config_return
3134: FROM sys.dual
3135: WHERE exists (SELECT relationship_id
3136: FROM csi_ii_relationships
3137: WHERE object_id = l_u_instance_rec.instance_id
3138: AND relationship_type_code = 'COMPONENT-OF');
3139: EXCEPTION
3140: WHEN no_data_found THEN

Line 3976: csi_ii_relationships_pub.create_relationship (

3972: END IF;
3973:
3974: IF l_comp_iir_tbl.COUNT > 0 THEN
3975:
3976: csi_ii_relationships_pub.create_relationship (
3977: p_api_version => 1.0,
3978: p_commit => fnd_api.g_false,
3979: p_init_msg_list => fnd_api.g_true,
3980: p_validation_level => fnd_api.g_valid_level_full,

Line 4069: SELECT 'X' from csi_ii_relationships cir

4065: FROM csi_item_instances cii
4066: WHERE cii.instance_id = p_instance_id
4067: AND cii.active_end_date is not null
4068: AND EXISTS (
4069: SELECT 'X' from csi_ii_relationships cir
4070: WHERE cir.subject_id = p_instance_id
4071: AND cir.relationship_type_code = 'COMPONENT-OF'
4072: AND sysdate BETWEEN nvl(cir.active_start_date, sysdate-1)
4073: AND nvl(cir.active_end_date, sysdate+1) );

Line 4210: p_pkg_name => 'csi_ii_relationships_pub',

4206: l_relationship_query_rec.subject_id := p_instance_id;
4207: l_relationship_query_rec.relationship_type_code := 'COMPONENT-OF';
4208:
4209: csi_t_gen_utility_pvt.dump_api_info(
4210: p_pkg_name => 'csi_ii_relationships_pub',
4211: p_api_name => 'get_relationships');
4212:
4213: csi_ii_relationships_pub.get_relationships(
4214: p_api_version => 1.0,

Line 4213: csi_ii_relationships_pub.get_relationships(

4209: csi_t_gen_utility_pvt.dump_api_info(
4210: p_pkg_name => 'csi_ii_relationships_pub',
4211: p_api_name => 'get_relationships');
4212:
4213: csi_ii_relationships_pub.get_relationships(
4214: p_api_version => 1.0,
4215: p_commit => fnd_api.g_false,
4216: p_init_msg_list => fnd_api.g_true,
4217: p_validation_level => fnd_api.g_valid_level_full,

Line 4243: p_pkg_name => 'csi_ii_relationships_pub',

4239: l_exp_relationship_rec.object_version_number :=
4240: l_relationship_tbl(l_ind).object_version_number;
4241:
4242: csi_t_gen_utility_pvt.dump_api_info(
4243: p_pkg_name => 'csi_ii_relationships_pub',
4244: p_api_name => 'expire_relationship');
4245:
4246: debug(' relationship id :'||l_exp_relationship_rec.relationship_id);
4247:

Line 4248: csi_ii_relationships_pub.expire_relationship(

4244: p_api_name => 'expire_relationship');
4245:
4246: debug(' relationship id :'||l_exp_relationship_rec.relationship_id);
4247:
4248: csi_ii_relationships_pub.expire_relationship(
4249: p_api_version => 1.0,
4250: p_commit => fnd_api.g_false,
4251: p_init_msg_list => fnd_api.g_true,
4252: p_validation_level => fnd_api.g_valid_level_full,