[Home] [Help]
1319: x_index := 1;
1320: BEGIN
1321: SELECT 'x'
1322: INTO l_dummy
1323: FROM csi_ii_relationships_h
1324: WHERE transaction_id = p_transaction_id
1325: AND rownum=1;
1326:
1327: csi_ii_relationships_pvt.get_inst_relationship_hist
1323: FROM csi_ii_relationships_h
1324: WHERE transaction_id = p_transaction_id
1325: AND rownum=1;
1326:
1327: csi_ii_relationships_pvt.get_inst_relationship_hist
1328: ( p_api_version => 1.0
1329: ,p_commit => fnd_api.g_false
1330: ,p_init_msg_list => fnd_api.g_false
1331: ,p_validation_level => fnd_api.g_valid_level_full
1718: l_relationship_query_rec.relationship_type_code:= p_relationship_type_code;
1719: delete from csi_configuration_temp_tbl;
1720: if p_relationship_type_code <> 'CONNECTED-TO' then
1721: LOOP
1722: csi_ii_relationships_pub.get_relationships
1723: (
1724: l_api_version,
1725: l_commit,
1726: l_init_msg_list,
1759: end if;
1760: -- Now construct childs of actual input
1761: l_relationship_query_rec1.object_id:=p_subject_id ;
1762: l_relationship_query_rec1.relationship_type_code:= p_relationship_type_code;
1763: csi_ii_relationships_pub.get_relationships
1764: (
1765: l_api_version,
1766: l_commit,
1767: l_init_msg_list,
1828:
1829: l_relationship_query_rec.relationship_type_code:='COMPONENT-OF';
1830:
1831:
1832: csi_ii_relationships_pub.get_relationships
1833: (
1834: l_api_version,
1835: l_commit,
1836: l_init_msg_list,
2069: BEGIN
2070: SELECT
2071: relationship_id, object_version_number INTO l_relationship_id, l_object_version_number
2072: FROM
2073: csi_ii_relationships
2074: WHERE
2075: subject_id = p_subject_id
2076: and (active_end_date IS NULL OR active_end_date > sysdate);
2077:
2077:
2078: l_relationship_rec.relationship_id := l_relationship_id;
2079: l_relationship_rec.object_version_number := l_object_version_number;
2080:
2081: CSI_II_RELATIONSHIPS_PUB.expire_relationship
2082: (
2083: p_api_version => p_api_version,
2084: p_commit => p_commit,
2085: p_init_msg_list => p_init_msg_list,