eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_UC_TREE_PVT dependencies on CSI_II_RELATIONSHIPS

Line 50: FROM csi_ii_relationships

46: AND R.relationship_id = p_uc_parent_rec.relationship_id
47: AND nvl(trunc(U.active_end_date), trunc(SYSDATE)+1) > trunc(SYSDATE)
48: UNION
49: SELECT 'x'
50: FROM csi_ii_relationships
51: WHERE subject_id = p_uc_parent_rec.instance_id
52: AND position_reference = to_char(p_uc_parent_rec.relationship_id)
53: AND nvl(trunc(active_end_date), trunc(SYSDATE)+1) > trunc(SYSDATE);
54: CURSOR check_relationship IS

Line 72: FROM csi_ii_relationships

68: AND A.csi_item_instance_id = c_instance_id;
69: -- get immediate children for installed node
70: CURSOR get_child_nodes_i(c_instance_id number, c_relationship_id number) IS
71: SELECT 'X' node_type, subject_id instance_id, NULL relationship_id
72: FROM csi_ii_relationships
73: WHERE object_id = c_instance_id
74: AND position_reference IS NULL
75: UNION
76: SELECT 'I' node_type, subject_id instance_id, to_number(position_reference) relationship_id

Line 77: FROM csi_ii_relationships

73: WHERE object_id = c_instance_id
74: AND position_reference IS NULL
75: UNION
76: SELECT 'I' node_type, subject_id instance_id, to_number(position_reference) relationship_id
77: FROM csi_ii_relationships
78: WHERE object_id = c_instance_id
79: AND position_reference IS NOT NULL
80: AND nvl(trunc(active_end_date), trunc(SYSDATE)+1) > trunc(SYSDATE)
81: UNION

Line 86: FROM csi_ii_relationships

82: SELECT 'E' node_type, NULL instance_id, relationship_id
83: FROM ahl_mc_relationships
84: WHERE parent_relationship_id = c_relationship_id
85: AND relationship_id NOT IN (SELECT position_reference
86: FROM csi_ii_relationships
87: WHERE object_id = c_instance_id
88: AND position_reference IS NOT NULL
89: AND nvl(trunc(active_end_date), trunc(SYSDATE)+1) > trunc(SYSDATE));
90: l_get_child_nodes_i get_child_nodes_i%ROWTYPE;

Line 99: FROM csi_ii_relationships

95: WHERE parent_relationship_id = c_relationship_id;
96: -- get immediate children for extra node
97: CURSOR get_child_nodes_x(c_instance_id number) IS
98: SELECT 'X' node_type, subject_id instance_id, to_number(position_reference) relationship_id
99: FROM csi_ii_relationships
100: WHERE object_id = c_instance_id
101: AND nvl(trunc(active_end_date), trunc(SYSDATE)+1) > trunc(SYSDATE);
102: BEGIN
103: -- Initialize API return status to success

Line 242: FROM csi_ii_relationships

238: END IF;
239: ELSIF x_uc_child_tbl(j).node_type = 'X' THEN
240: x_uc_child_tbl(j).has_subconfig_flag := 'N';
241: SELECT count(subject_id) INTO l_children_no
242: FROM csi_ii_relationships
243: WHERE object_id = x_uc_child_tbl(j).instance_id;
244: IF l_children_no > 0 THEN
245: x_uc_child_tbl(j).leaf_node_flag := 'Y';
246: ELSE

Line 369: --Given an instance_id, get all of its immediate children from csi_ii_relationships

365: WHERE A.unit_config_header_id = c_uc_header_id
366: AND A.master_config_id = B.mc_header_id
367: AND B.parent_relationship_id IS NULL;
368:
369: --Given an instance_id, get all of its immediate children from csi_ii_relationships
370: -- rbhavsar::FP Bug# 6268202, performance tuning
371: -- Object_id is not used in the code, so removing it.
372: -- Also, no need for ORDER BY for extra nodes.
373: CURSOR get_csi_children(c_instance_id NUMBER) IS

Line 378: FROM csi_ii_relationships R,

374: SELECT R.subject_id instance_id,
375: to_number(R.position_reference) relationship_id,
376: M.concatenated_segments||'-'||NVL(C.serial_number, C.instance_number) part_info,
377: 'N'
378: FROM csi_ii_relationships R,
379: csi_item_instances C,
380: mtl_system_items_kfv M
381: WHERE R.object_id = c_instance_id
382: AND R.subject_id = C.instance_id

Line 393: FROM csi_ii_relationships

389: -- rbhavsar::FP Bug# 6268202, performance tuning
390: -- cursor to check if the instance is leaf node or not
391: CURSOR chk_csi_leaf_node_csr(c_instance_id NUMBER) IS
392: SELECT 'X'
393: FROM csi_ii_relationships
394: WHERE object_id = c_instance_id
395: AND relationship_type_code = 'COMPONENT-OF'
396: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
397: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);

Line 532: FROM CSI_II_RELATIONSHIPS A

528: SUBJECT_ID INSTANCE_ID,
529: TO_NUMBER(POSITION_REFERENCE) RELATIONSHIP_ID,
530: DECODE(POSITION_REFERENCE, NULL, 'X', 'I') NODE_TYPE,
531: LEVEL OWN_LEVEL
532: FROM CSI_II_RELATIONSHIPS A
533: WHERE (
534: EXISTS (SELECT 'x'
535: FROM CSI_II_RELATIONSHIPS B
536: WHERE B.OBJECT_ID = A.SUBJECT_ID

Line 535: FROM CSI_II_RELATIONSHIPS B

531: LEVEL OWN_LEVEL
532: FROM CSI_II_RELATIONSHIPS A
533: WHERE (
534: EXISTS (SELECT 'x'
535: FROM CSI_II_RELATIONSHIPS B
536: WHERE B.OBJECT_ID = A.SUBJECT_ID
537: AND B.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
538: AND TRUNC(NVL(B.ACTIVE_START_DATE,SYSDATE)) <= TRUNC(SYSDATE)
539: AND TRUNC(NVL(B.ACTIVE_END_DATE, SYSDATE+1)) > TRUNC(SYSDATE)

Line 708: --instead of the relationship_id(got from position_reference in csi_ii_relationships)

704: NOT ahl_util_uc_pkg.extra_node(l_non_leaf_node.instance_id, l_root_instance_id)) THEN
705:
706: --If the UC instance happens to be the top node of a sub UC, then when getting the
707: --MC descendants, the sub UC top node's relationship_id(got from uc headers table)
708: --instead of the relationship_id(got from position_reference in csi_ii_relationships)
709: --should be used. For UC root instance, the following cursor is also applicable.
710: OPEN check_sub_uc(l_non_leaf_node.instance_id);
711: FETCH check_sub_uc INTO l_uc_header_id, l_mc_header_id, l_relationship_id;
712:

Line 1118: FROM csi_ii_relationships

1114: l_new_relationship_id NUMBER;
1115: --In order to check whether the instance belongs to a sub unit or an extra node branch
1116: CURSOR check_subuc_extra(c_instance_id NUMBER, c_top_instance_id NUMBER) IS
1117: SELECT object_id, subject_id, position_reference
1118: FROM csi_ii_relationships
1119: WHERE subject_id IN (SELECT csi_item_instance_id
1120: FROM ahl_unit_config_headers
1121: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
1122: OR position_reference IS NULL

Line 1182: --Given an instance_id, get all of its immediate children from csi_ii_relationships

1178: WHERE item_group_id = c_item_group_id;
1179: l_get_associated_item get_associated_items%ROWTYPE;
1180: */
1181:
1182: --Given an instance_id, get all of its immediate children from csi_ii_relationships
1183: CURSOR get_csi_children(c_instance_id NUMBER) IS
1184: SELECT C.relationship_id csi_ii_relationship_id,
1185: C.object_version_number csi_ii_relationship_ovn,
1186: C.object_id parent_instance_id,

Line 1196: FROM csi_ii_relationships C,

1192: I.inv_master_organization_id inventory_org_id,
1193: I.inventory_revision,
1194: I.quantity,
1195: I.unit_of_measure
1196: FROM csi_ii_relationships C,
1197: ahl_mc_relationships M,
1198: csi_item_instances I
1199: WHERE to_number(C.position_reference) = M.relationship_id (+)
1200: AND C.subject_id = I.instance_id

Line 1252: FROM csi_ii_relationships A

1248: UNION ALL
1249: SELECT object_id parent_instance_id,
1250: subject_id instance_id,
1251: to_number(position_reference) relationship_id
1252: FROM csi_ii_relationships A
1253: --remove all of the leaf node after finishing the hierarchical query
1254: WHERE EXISTS (SELECT 'x'
1255: FROM csi_ii_relationships B
1256: WHERE B.object_id = A.subject_id

Line 1255: FROM csi_ii_relationships B

1251: to_number(position_reference) relationship_id
1252: FROM csi_ii_relationships A
1253: --remove all of the leaf node after finishing the hierarchical query
1254: WHERE EXISTS (SELECT 'x'
1255: FROM csi_ii_relationships B
1256: WHERE B.object_id = A.subject_id
1257: AND relationship_type_code = 'COMPONENT-OF'
1258: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
1259: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))

Line 1273: FROM csi_ii_relationships

1269: CURSOR get_position_reference(c_object_id NUMBER, c_subject_id NUMBER) IS
1270: SELECT relationship_id csi_ii_relationship_id,
1271: object_version_number csi_ii_relationship_ovn,
1272: to_number(position_reference) relationship_id
1273: FROM csi_ii_relationships
1274: WHERE object_id = c_object_id
1275: AND subject_id = c_subject_id
1276: AND relationship_type_code = 'COMPONENT-OF'
1277: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)

Line 1382: --The following lines are used to update the position_reference column in csi_ii_relationships

1378: CLOSE check_mc_header;
1379: END IF;
1380: END IF;
1381:
1382: --The following lines are used to update the position_reference column in csi_ii_relationships
1383: --First, get transaction_type_id .
1384: AHL_UTIL_UC_PKG.getcsi_transaction_id('UC_UPDATE',l_transaction_type_id, l_return_value);
1385: IF NOT l_return_value THEN
1386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1470: CSI_II_RELATIONSHIPS_PUB.update_relationship(

1466: l_csi_relationship_rec.relationship_type_code := 'COMPONENT-OF';
1467: l_csi_relationship_rec.object_id := l_parent_instance_id;
1468: l_csi_relationship_rec.subject_id := l_uc_header_attr.instance_id;
1469: l_csi_relationship_tbl(1) := l_csi_relationship_rec;
1470: CSI_II_RELATIONSHIPS_PUB.update_relationship(
1471: p_api_version => 1.0,
1472: p_relationship_tbl => l_csi_relationship_tbl,
1473: p_txn_rec => l_csi_transaction_rec,
1474: x_return_status => l_return_status,

Line 1567: FROM csi_ii_relationships

1563: IF l_uc_header_attr.instance_id = l_get_non_leaf_node.instance_id THEN
1564: l_new_relationship_id := l_get_non_leaf_node.relationship_id;
1565: ELSE
1566: SELECT to_number(position_reference) into l_new_relationship_id
1567: FROM csi_ii_relationships
1568: WHERE subject_id = l_get_non_leaf_node.instance_id
1569: AND relationship_type_code='COMPONENT-OF'
1570: AND trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate)
1571: AND trunc(nvl(active_end_date, sysdate+1)) > trunc(sysdate);

Line 1650: CSI_II_RELATIONSHIPS_PUB.update_relationship(

1646: l_csi_relationship_rec.relationship_type_code := 'COMPONENT-OF';
1647: l_csi_relationship_rec.object_id := l_get_csi_child.parent_instance_id;
1648: l_csi_relationship_rec.subject_id := l_get_csi_child.instance_id;
1649: l_csi_relationship_tbl(1) := l_csi_relationship_rec;
1650: CSI_II_RELATIONSHIPS_PUB.update_relationship(
1651: p_api_version => 1.0,
1652: p_relationship_tbl => l_csi_relationship_tbl,
1653: p_txn_rec => l_csi_transaction_rec,
1654: x_return_status => l_return_status,

Line 1872: FROM csi_ii_relationships

1868: l_new_relationship_id NUMBER;
1869: --In order to check whether the instance belongs to a sub unit or an extra node branch
1870: CURSOR check_subuc_extra(c_instance_id NUMBER, c_top_instance_id NUMBER) IS
1871: SELECT object_id, subject_id, position_reference
1872: FROM csi_ii_relationships
1873: WHERE subject_id IN (SELECT csi_item_instance_id
1874: FROM ahl_unit_config_headers
1875: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
1876: OR position_reference IS NULL

Line 1898: FROM csi_ii_relationships R,

1894: C.inv_master_organization_id inventory_org_id,
1895: C.inventory_revision,
1896: C.quantity,
1897: C.unit_of_measure
1898: FROM csi_ii_relationships R,
1899: csi_item_instances C
1900: WHERE R.object_id = p_instance_id
1901: AND R.object_id = C.instance_id
1902: AND R.relationship_type_code = 'COMPONENT-OF'

Line 1931: --Given an instance_id, get all of its immediate children from csi_ii_relationships

1927: FROM ahl_item_associations_b
1928: WHERE item_group_id = c_item_group_id;
1929: l_get_associated_item get_associated_items%ROWTYPE;
1930: */
1931: --Given an instance_id, get all of its immediate children from csi_ii_relationships
1932: CURSOR get_csi_children(c_instance_id NUMBER) IS
1933: SELECT C.relationship_id csi_ii_relationship_id,
1934: C.object_version_number csi_ii_relationship_ovn,
1935: C.object_id parent_instance_id,

Line 1945: FROM csi_ii_relationships C,

1941: I.inv_master_organization_id inventory_org_id,
1942: I.inventory_revision,
1943: I.quantity,
1944: I.unit_of_measure
1945: FROM csi_ii_relationships C,
1946: ahl_mc_relationships M,
1947: csi_item_instances I
1948: WHERE to_number(C.position_reference) = M.relationship_id (+)
1949: AND C.subject_id = I.instance_id

Line 1991: FROM csi_ii_relationships A

1987: CURSOR get_non_leaf_nodes(c_instance_id NUMBER) IS
1988: SELECT object_id parent_instance_id,
1989: subject_id instance_id,
1990: to_number(position_reference) relationship_id
1991: FROM csi_ii_relationships A
1992: --remove all of the leaf node after finishing the hierarchical query
1993: WHERE EXISTS (SELECT 'X'
1994: FROM csi_ii_relationships B
1995: WHERE B.object_id = A.subject_id

Line 1994: FROM csi_ii_relationships B

1990: to_number(position_reference) relationship_id
1991: FROM csi_ii_relationships A
1992: --remove all of the leaf node after finishing the hierarchical query
1993: WHERE EXISTS (SELECT 'X'
1994: FROM csi_ii_relationships B
1995: WHERE B.object_id = A.subject_id
1996: AND relationship_type_code = 'COMPONENT-OF'
1997: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
1998: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))

Line 2100: FROM csi_ii_relationships

2096: IF p_instance_id = l_get_non_leaf_node.instance_id THEN
2097: l_new_relationship_id := p_relationship_id;
2098: ELSE
2099: SELECT to_number(position_reference) into l_new_relationship_id
2100: FROM csi_ii_relationships
2101: WHERE subject_id = l_get_non_leaf_node.instance_id
2102: AND relationship_type_code='COMPONENT-OF'
2103: AND trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate)
2104: AND trunc(nvl(active_end_date, sysdate+1)) > trunc(sysdate);

Line 2177: --The following lines are used to update the position_reference column in csi_ii_relationships

2173: END IF;
2174: END IF; --whether position_key or position_ref_code matches
2175: END IF; --whether the MC chilren node has already been matched
2176: END LOOP; --of all the MC children
2177: --The following lines are used to update the position_reference column in csi_ii_relationships
2178: --First, get transaction_type_id .
2179: AHL_UTIL_UC_PKG.getcsi_transaction_id('UC_UPDATE',l_transaction_type_id, l_return_value);
2180: IF NOT l_return_value THEN
2181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2194: CSI_II_RELATIONSHIPS_PUB.update_relationship(

2190: l_csi_relationship_rec.relationship_type_code := 'COMPONENT-OF';
2191: l_csi_relationship_rec.object_id := l_get_csi_child.parent_instance_id;
2192: l_csi_relationship_rec.subject_id := l_get_csi_child.instance_id;
2193: l_csi_relationship_tbl(1) := l_csi_relationship_rec;
2194: CSI_II_RELATIONSHIPS_PUB.update_relationship(
2195: p_api_version => 1.0,
2196: p_relationship_tbl => l_csi_relationship_tbl,
2197: p_txn_rec => l_csi_transaction_rec,
2198: x_return_status => l_return_status,

Line 2276: FROM csi_ii_relationships

2272:
2273: -- Get all the children of the current instance that are extra nodes
2274: CURSOR get_extra_children_csr IS
2275: SELECT subject_id
2276: FROM csi_ii_relationships
2277: WHERE object_id = p_instance_id
2278: AND relationship_type_code = 'COMPONENT-OF'
2279: AND position_reference IS NULL
2280: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)

Line 2290: FROM csi_ii_relationships

2286:
2287: -- Get all the children of the current instance that are NOT extra nodes
2288: CURSOR get_premapped_instances_csr IS
2289: SELECT subject_id, position_reference
2290: FROM csi_ii_relationships
2291: WHERE object_id = p_instance_id
2292: AND relationship_type_code = 'COMPONENT-OF'
2293: AND position_reference IS NOT NULL
2294: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)

Line 2318: FROM csi_ii_relationships relationship_id

2314: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
2315: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)
2316: MINUS
2317: SELECT to_number(position_reference) relationship_id
2318: FROM csi_ii_relationships relationship_id
2319: WHERE object_id = p_instance_id
2320: AND relationship_type_code = 'COMPONENT-OF'
2321: AND position_reference IS NOT NULL
2322: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)

Line 2330: FROM csi_ii_relationships C

2326: SELECT C.relationship_id,
2327: C.object_version_number,
2328: C.object_id,
2329: C.subject_id
2330: FROM csi_ii_relationships C
2331: WHERE C.subject_id = c_instance_id
2332: AND C.relationship_type_code = 'COMPONENT-OF'
2333: AND trunc(nvl(C.active_start_date,SYSDATE)) <= trunc(SYSDATE)
2334: AND trunc(nvl(C.active_end_date, SYSDATE+1)) > trunc(SYSDATE);

Line 2357: -- Get the transaction_type_id for use later by the CSI_II_RELATIONSHIPS_PUB.update_relationship API

2353: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin',
2354: 'At the start of the procedure, p_instance_id = ' || p_instance_id || ', p_relationship_id = ' || p_relationship_id);
2355: END IF;
2356:
2357: -- Get the transaction_type_id for use later by the CSI_II_RELATIONSHIPS_PUB.update_relationship API
2358: AHL_UTIL_UC_PKG.getcsi_transaction_id('UC_UPDATE', l_transaction_type_id, l_return_value);
2359: IF NOT l_return_value THEN
2360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2361: END IF;

Line 2391: 'About to call CSI_II_RELATIONSHIPS_PUB.update_relationship to update CSI II relationship with id ' ||

2387: l_csi_relationship_rec.subject_id := l_ii_rel_dtls.subject_id;
2388: l_csi_relationship_tbl(1) := l_csi_relationship_rec;
2389: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2390: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY,
2391: 'About to call CSI_II_RELATIONSHIPS_PUB.update_relationship to update CSI II relationship with id ' ||
2392: l_ii_rel_dtls.relationship_id || ' between ' ||
2393: l_ii_rel_dtls.object_id || ' (object) and ' ||
2394: l_ii_rel_dtls.subject_id || '(subject) with NULL position_reference ');
2395: END IF;

Line 2396: CSI_II_RELATIONSHIPS_PUB.update_relationship(

2392: l_ii_rel_dtls.relationship_id || ' between ' ||
2393: l_ii_rel_dtls.object_id || ' (object) and ' ||
2394: l_ii_rel_dtls.subject_id || '(subject) with NULL position_reference ');
2395: END IF;
2396: CSI_II_RELATIONSHIPS_PUB.update_relationship(
2397: p_api_version => 1.0,
2398: p_relationship_tbl => l_csi_relationship_tbl,
2399: p_txn_rec => l_csi_transaction_rec,
2400: x_return_status => l_return_status,

Line 2486: FROM csi_ii_relationships C

2482: SELECT C.relationship_id,
2483: C.object_version_number,
2484: C.object_id,
2485: C.subject_id
2486: FROM csi_ii_relationships C
2487: WHERE C.subject_id = c_instance_id
2488: AND C.relationship_type_code = 'COMPONENT-OF'
2489: AND trunc(nvl(C.active_start_date,SYSDATE)) <= trunc(SYSDATE)
2490: AND trunc(nvl(C.active_end_date, SYSDATE+1)) > trunc(SYSDATE);

Line 2517: -- Get the transaction_type_id for use later by the CSI_II_RELATIONSHIPS_PUB.update_relationship API

2513: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin',
2514: 'At the start of the procedure, p_x_extra_instances_tbl.count = ' || p_x_extra_instances_tbl.count || ',p_x_relations_tbl.count = ' ||p_x_relations_tbl.count);
2515: END IF;
2516:
2517: -- Get the transaction_type_id for use later by the CSI_II_RELATIONSHIPS_PUB.update_relationship API
2518: AHL_UTIL_UC_PKG.getcsi_transaction_id('UC_UPDATE', l_transaction_type_id, l_return_value);
2519: IF NOT l_return_value THEN
2520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2521: END IF;

Line 2606: 'About to call CSI_II_RELATIONSHIPS_PUB.update_relationship to update CSI II relationship with id ' ||

2602: l_csi_relationship_rec.subject_id := l_ii_rel_dtls.subject_id;
2603: l_csi_relationship_tbl(1) := l_csi_relationship_rec;
2604: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2605: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY,
2606: 'About to call CSI_II_RELATIONSHIPS_PUB.update_relationship to update CSI II relationship with id ' ||
2607: l_ii_rel_dtls.relationship_id || ' between ' ||
2608: l_ii_rel_dtls.object_id || ' (object) and ' ||
2609: l_ii_rel_dtls.subject_id || '(subject) with position_reference ' ||
2610: to_char(l_current_position));

Line 2612: CSI_II_RELATIONSHIPS_PUB.update_relationship(

2608: l_ii_rel_dtls.object_id || ' (object) and ' ||
2609: l_ii_rel_dtls.subject_id || '(subject) with position_reference ' ||
2610: to_char(l_current_position));
2611: END IF;
2612: CSI_II_RELATIONSHIPS_PUB.update_relationship(
2613: p_api_version => 1.0,
2614: p_relationship_tbl => l_csi_relationship_tbl,
2615: p_txn_rec => l_csi_transaction_rec,
2616: x_return_status => l_return_status,