APPS.CSI_PROCESS_TXN_PVT dependencies on CSI_II_RELATIONSHIPS

Line 3447: FROM csi_ii_relationships

3443: SELECT 'Y'
3444: INTO l_config_return
3445: FROM sys.dual
3446: WHERE exists (SELECT relationship_id
3447: FROM csi_ii_relationships
3448: WHERE object_id = l_u_instance_rec.instance_id
3449: AND relationship_type_code = 'COMPONENT-OF');
3450: EXCEPTION
3451: WHEN no_data_found THEN

Line 4340: csi_ii_relationships_pub.create_relationship (

4336: END IF;
4337:
4338: IF l_comp_iir_tbl.COUNT > 0 THEN
4339:
4340: csi_ii_relationships_pub.create_relationship (
4341: p_api_version => 1.0,
4342: p_commit => fnd_api.g_false,
4343: p_init_msg_list => fnd_api.g_true,
4344: p_validation_level => fnd_api.g_valid_level_full,

Line 4433: SELECT 'X' from csi_ii_relationships cir

4429: FROM csi_item_instances cii
4430: WHERE cii.instance_id = p_instance_id
4431: AND cii.active_end_date is not null
4432: AND EXISTS (
4433: SELECT 'X' from csi_ii_relationships cir
4434: WHERE cir.subject_id = p_instance_id
4435: AND cir.relationship_type_code = 'COMPONENT-OF'
4436: AND sysdate BETWEEN nvl(cir.active_start_date, sysdate-1)
4437: AND nvl(cir.active_end_date, sysdate+1) );

Line 4574: p_pkg_name => 'csi_ii_relationships_pub',

4570: l_relationship_query_rec.subject_id := p_instance_id;
4571: l_relationship_query_rec.relationship_type_code := 'COMPONENT-OF';
4572:
4573: csi_t_gen_utility_pvt.dump_api_info(
4574: p_pkg_name => 'csi_ii_relationships_pub',
4575: p_api_name => 'get_relationships');
4576:
4577: csi_ii_relationships_pub.get_relationships(
4578: p_api_version => 1.0,

Line 4577: csi_ii_relationships_pub.get_relationships(

4573: csi_t_gen_utility_pvt.dump_api_info(
4574: p_pkg_name => 'csi_ii_relationships_pub',
4575: p_api_name => 'get_relationships');
4576:
4577: csi_ii_relationships_pub.get_relationships(
4578: p_api_version => 1.0,
4579: p_commit => fnd_api.g_false,
4580: p_init_msg_list => fnd_api.g_true,
4581: p_validation_level => fnd_api.g_valid_level_full,

Line 4607: p_pkg_name => 'csi_ii_relationships_pub',

4603: l_exp_relationship_rec.object_version_number :=
4604: l_relationship_tbl(l_ind).object_version_number;
4605:
4606: csi_t_gen_utility_pvt.dump_api_info(
4607: p_pkg_name => 'csi_ii_relationships_pub',
4608: p_api_name => 'expire_relationship');
4609:
4610: debug(' relationship id :'||l_exp_relationship_rec.relationship_id);
4611:

Line 4612: csi_ii_relationships_pub.expire_relationship(

4608: p_api_name => 'expire_relationship');
4609:
4610: debug(' relationship id :'||l_exp_relationship_rec.relationship_id);
4611:
4612: csi_ii_relationships_pub.expire_relationship(
4613: p_api_version => 1.0,
4614: p_commit => fnd_api.g_false,
4615: p_init_msg_list => fnd_api.g_true,
4616: p_validation_level => fnd_api.g_valid_level_full,