DBA Data[Home] [Help]

APPS.CSI_JAVA_INTERFACE_PKG dependencies on CSI_II_RELATIONSHIPS

Line 1322: FROM csi_ii_relationships_h

1318: x_index := 1;
1319: BEGIN
1320: SELECT 'x'
1321: INTO l_dummy
1322: FROM csi_ii_relationships_h
1323: WHERE transaction_id = p_transaction_id
1324: AND rownum=1;
1325:
1326: csi_ii_relationships_pvt.get_inst_relationship_hist

Line 1326: csi_ii_relationships_pvt.get_inst_relationship_hist

1322: FROM csi_ii_relationships_h
1323: WHERE transaction_id = p_transaction_id
1324: AND rownum=1;
1325:
1326: csi_ii_relationships_pvt.get_inst_relationship_hist
1327: ( p_api_version => 1.0
1328: ,p_commit => fnd_api.g_false
1329: ,p_init_msg_list => fnd_api.g_false
1330: ,p_validation_level => fnd_api.g_valid_level_full

Line 1721: csi_ii_relationships_pub.get_relationships

1717: l_relationship_query_rec.relationship_type_code:= p_relationship_type_code;
1718: delete from csi_configuration_temp_tbl;
1719: if p_relationship_type_code <> 'CONNECTED-TO' then
1720: LOOP
1721: csi_ii_relationships_pub.get_relationships
1722: (
1723: l_api_version,
1724: l_commit,
1725: l_init_msg_list,

Line 1762: csi_ii_relationships_pub.get_relationships

1758: end if;
1759: -- Now construct childs of actual input
1760: l_relationship_query_rec1.object_id:=p_subject_id ;
1761: l_relationship_query_rec1.relationship_type_code:= p_relationship_type_code;
1762: csi_ii_relationships_pub.get_relationships
1763: (
1764: l_api_version,
1765: l_commit,
1766: l_init_msg_list,

Line 1831: csi_ii_relationships_pub.get_relationships

1827:
1828: l_relationship_query_rec.relationship_type_code:='COMPONENT-OF';
1829:
1830:
1831: csi_ii_relationships_pub.get_relationships
1832: (
1833: l_api_version,
1834: l_commit,
1835: l_init_msg_list,

Line 2072: csi_ii_relationships

2068: BEGIN
2069: SELECT
2070: relationship_id, object_version_number INTO l_relationship_id, l_object_version_number
2071: FROM
2072: csi_ii_relationships
2073: WHERE
2074: subject_id = p_subject_id
2075: and (active_end_date IS NULL OR active_end_date > sysdate);
2076:

Line 2080: CSI_II_RELATIONSHIPS_PUB.expire_relationship

2076:
2077: l_relationship_rec.relationship_id := l_relationship_id;
2078: l_relationship_rec.object_version_number := l_object_version_number;
2079:
2080: CSI_II_RELATIONSHIPS_PUB.expire_relationship
2081: (
2082: p_api_version => p_api_version,
2083: p_commit => p_commit,
2084: p_init_msg_list => p_init_msg_list,