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 61: FROM csi_ii_relationships

57: AND R.relationship_id = p_uc_parent_rec.relationship_id
58: AND nvl(trunc(U.active_end_date), trunc(SYSDATE)+1) > trunc(SYSDATE)
59: UNION
60: SELECT 'x'
61: FROM csi_ii_relationships
62: WHERE subject_id = p_uc_parent_rec.instance_id
63: AND position_reference = to_char(p_uc_parent_rec.relationship_id)
64: AND nvl(trunc(active_end_date), trunc(SYSDATE)+1) > trunc(SYSDATE);
65: CURSOR check_relationship IS

Line 83: FROM csi_ii_relationships

79: AND A.csi_item_instance_id = c_instance_id;
80: -- get immediate children for installed node
81: CURSOR get_child_nodes_i(c_instance_id number, c_relationship_id number) IS
82: SELECT 'X' node_type, subject_id instance_id, NULL relationship_id
83: FROM csi_ii_relationships
84: WHERE object_id = c_instance_id
85: AND position_reference IS NULL
86: UNION
87: SELECT 'I' node_type, subject_id instance_id, to_number(position_reference) relationship_id

Line 88: FROM csi_ii_relationships

84: WHERE object_id = c_instance_id
85: AND position_reference IS NULL
86: UNION
87: SELECT 'I' node_type, subject_id instance_id, to_number(position_reference) relationship_id
88: FROM csi_ii_relationships
89: WHERE object_id = c_instance_id
90: AND position_reference IS NOT NULL
91: AND nvl(trunc(active_end_date), trunc(SYSDATE)+1) > trunc(SYSDATE)
92: UNION

Line 97: FROM csi_ii_relationships

93: SELECT 'E' node_type, NULL instance_id, relationship_id
94: FROM ahl_mc_relationships
95: WHERE parent_relationship_id = c_relationship_id
96: AND relationship_id NOT IN (SELECT position_reference
97: FROM csi_ii_relationships
98: WHERE object_id = c_instance_id
99: AND position_reference IS NOT NULL
100: AND nvl(trunc(active_end_date), trunc(SYSDATE)+1) > trunc(SYSDATE));
101: l_get_child_nodes_i get_child_nodes_i%ROWTYPE;

Line 110: FROM csi_ii_relationships

106: WHERE parent_relationship_id = c_relationship_id;
107: -- get immediate children for extra node
108: CURSOR get_child_nodes_x(c_instance_id number) IS
109: SELECT 'X' node_type, subject_id instance_id, to_number(position_reference) relationship_id
110: FROM csi_ii_relationships
111: WHERE object_id = c_instance_id
112: AND nvl(trunc(active_end_date), trunc(SYSDATE)+1) > trunc(SYSDATE);
113: BEGIN
114: -- Initialize API return status to success

Line 253: FROM csi_ii_relationships

249: END IF;
250: ELSIF x_uc_child_tbl(j).node_type = 'X' THEN
251: x_uc_child_tbl(j).has_subconfig_flag := 'N';
252: SELECT count(subject_id) INTO l_children_no
253: FROM csi_ii_relationships
254: WHERE object_id = x_uc_child_tbl(j).instance_id;
255: IF l_children_no > 0 THEN
256: x_uc_child_tbl(j).leaf_node_flag := 'Y';
257: ELSE

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

379: WHERE A.unit_config_header_id = c_uc_header_id
380: AND A.master_config_id = B.mc_header_id
381: AND B.parent_relationship_id IS NULL;
382:
383: --Given an instance_id, get all of its immediate children from csi_ii_relationships
384: -- rbhavsar::FP Bug# 6268202, performance tuning
385: -- Object_id is not used in the code, so removing it.
386: -- Also, no need for ORDER BY for extra nodes.
387: CURSOR get_csi_children(c_instance_id NUMBER) IS

Line 392: FROM csi_ii_relationships R,

388: SELECT R.subject_id instance_id,
389: to_number(R.position_reference) relationship_id,
390: M.concatenated_segments||'-'||NVL(C.serial_number, C.instance_number) part_info,
391: 'N'
392: FROM csi_ii_relationships R,
393: csi_item_instances C,
394: mtl_system_items_kfv M
395: WHERE R.object_id = c_instance_id
396: AND R.subject_id = C.instance_id

Line 407: FROM csi_ii_relationships

403: -- rbhavsar::FP Bug# 6268202, performance tuning
404: -- cursor to check if the instance is leaf node or not
405: CURSOR chk_csi_leaf_node_csr(c_instance_id NUMBER) IS
406: SELECT 'X'
407: FROM csi_ii_relationships
408: WHERE object_id = c_instance_id
409: AND relationship_type_code = 'COMPONENT-OF'
410: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
411: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);

Line 546: FROM CSI_II_RELATIONSHIPS A

542: SUBJECT_ID INSTANCE_ID,
543: TO_NUMBER(POSITION_REFERENCE) RELATIONSHIP_ID,
544: DECODE(POSITION_REFERENCE, NULL, 'X', 'I') NODE_TYPE,
545: LEVEL OWN_LEVEL
546: FROM CSI_II_RELATIONSHIPS A
547: WHERE (
548: EXISTS (SELECT 'x'
549: FROM CSI_II_RELATIONSHIPS B
550: WHERE B.OBJECT_ID = A.SUBJECT_ID

Line 549: FROM CSI_II_RELATIONSHIPS B

545: LEVEL OWN_LEVEL
546: FROM CSI_II_RELATIONSHIPS A
547: WHERE (
548: EXISTS (SELECT 'x'
549: FROM CSI_II_RELATIONSHIPS B
550: WHERE B.OBJECT_ID = A.SUBJECT_ID
551: AND B.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
552: AND TRUNC(NVL(B.ACTIVE_START_DATE,SYSDATE)) <= TRUNC(SYSDATE)
553: AND TRUNC(NVL(B.ACTIVE_END_DATE, SYSDATE+1)) > TRUNC(SYSDATE)

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

738: NOT ahl_util_uc_pkg.extra_node(l_non_leaf_node.instance_id, l_root_instance_id)) THEN
739:
740: --If the UC instance happens to be the top node of a sub UC, then when getting the
741: --MC descendants, the sub UC top node's relationship_id(got from uc headers table)
742: --instead of the relationship_id(got from position_reference in csi_ii_relationships)
743: --should be used. For UC root instance, the following cursor is also applicable.
744: OPEN check_sub_uc(l_non_leaf_node.instance_id);
745: FETCH check_sub_uc INTO l_uc_header_id, l_mc_header_id, l_relationship_id;
746:

Line 1160: FROM csi_ii_relationships

1156: l_new_relationship_id NUMBER;
1157: --In order to check whether the instance belongs to a sub unit or an extra node branch
1158: CURSOR check_subuc_extra(c_instance_id NUMBER, c_top_instance_id NUMBER) IS
1159: SELECT object_id, subject_id, position_reference
1160: FROM csi_ii_relationships
1161: WHERE subject_id IN (SELECT csi_item_instance_id
1162: FROM ahl_unit_config_headers
1163: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
1164: OR position_reference IS NULL

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

1220: WHERE item_group_id = c_item_group_id;
1221: l_get_associated_item get_associated_items%ROWTYPE;
1222: */
1223:
1224: --Given an instance_id, get all of its immediate children from csi_ii_relationships
1225: CURSOR get_csi_children(c_instance_id NUMBER) IS
1226: SELECT C.relationship_id csi_ii_relationship_id,
1227: C.object_version_number csi_ii_relationship_ovn,
1228: C.object_id parent_instance_id,

Line 1238: FROM csi_ii_relationships C,

1234: I.inv_master_organization_id inventory_org_id,
1235: I.inventory_revision,
1236: I.quantity,
1237: I.unit_of_measure
1238: FROM csi_ii_relationships C,
1239: ahl_mc_relationships M,
1240: csi_item_instances I
1241: WHERE to_number(C.position_reference) = M.relationship_id (+)
1242: AND C.subject_id = I.instance_id

Line 1294: FROM csi_ii_relationships A

1290: UNION ALL
1291: SELECT object_id parent_instance_id,
1292: subject_id instance_id,
1293: to_number(position_reference) relationship_id
1294: FROM csi_ii_relationships A
1295: --remove all of the leaf node after finishing the hierarchical query
1296: WHERE EXISTS (SELECT 'x'
1297: FROM csi_ii_relationships B
1298: WHERE B.object_id = A.subject_id

Line 1297: FROM csi_ii_relationships B

1293: to_number(position_reference) relationship_id
1294: FROM csi_ii_relationships A
1295: --remove all of the leaf node after finishing the hierarchical query
1296: WHERE EXISTS (SELECT 'x'
1297: FROM csi_ii_relationships B
1298: WHERE B.object_id = A.subject_id
1299: AND relationship_type_code = 'COMPONENT-OF'
1300: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
1301: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))

Line 1320: FROM csi_ii_relationships

1316: CURSOR get_position_reference(c_object_id NUMBER, c_subject_id NUMBER) IS
1317: SELECT relationship_id csi_ii_relationship_id,
1318: object_version_number csi_ii_relationship_ovn,
1319: to_number(position_reference) relationship_id
1320: FROM csi_ii_relationships
1321: WHERE object_id = c_object_id
1322: AND subject_id = c_subject_id
1323: AND relationship_type_code = 'COMPONENT-OF'
1324: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)

Line 1332: FROM csi_ii_relationships

1328: CURSOR get_position_reference(c_object_id NUMBER, c_subject_id NUMBER) IS
1329: SELECT relationship_id csi_ii_relationship_id,
1330: object_version_number csi_ii_relationship_ovn,
1331: to_number(position_reference) relationship_id
1332: FROM csi_ii_relationships
1333: WHERE subject_id = c_subject_id
1334: START WITH object_id = c_object_id
1335: AND relationship_type_code = 'COMPONENT-OF'
1336: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)

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

1441: CLOSE check_mc_header;
1442: END IF;
1443: END IF;
1444:
1445: --The following lines are used to update the position_reference column in csi_ii_relationships
1446: --First, get transaction_type_id .
1447: AHL_UTIL_UC_PKG.getcsi_transaction_id('UC_UPDATE',l_transaction_type_id, l_return_value);
1448: IF NOT l_return_value THEN
1449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1533: CSI_II_RELATIONSHIPS_PUB.update_relationship(

1529: l_csi_relationship_rec.relationship_type_code := 'COMPONENT-OF';
1530: l_csi_relationship_rec.object_id := l_parent_instance_id;
1531: l_csi_relationship_rec.subject_id := l_uc_header_attr.instance_id;
1532: l_csi_relationship_tbl(1) := l_csi_relationship_rec;
1533: CSI_II_RELATIONSHIPS_PUB.update_relationship(
1534: p_api_version => 1.0,
1535: p_relationship_tbl => l_csi_relationship_tbl,
1536: p_txn_rec => l_csi_transaction_rec,
1537: x_return_status => l_return_status,

Line 1630: FROM csi_ii_relationships

1626: IF l_uc_header_attr.instance_id = l_get_non_leaf_node.instance_id THEN
1627: l_new_relationship_id := l_get_non_leaf_node.relationship_id;
1628: ELSE
1629: SELECT to_number(position_reference) into l_new_relationship_id
1630: FROM csi_ii_relationships
1631: WHERE subject_id = l_get_non_leaf_node.instance_id
1632: AND relationship_type_code='COMPONENT-OF'
1633: AND trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate)
1634: AND trunc(nvl(active_end_date, sysdate+1)) > trunc(sysdate);

Line 1713: CSI_II_RELATIONSHIPS_PUB.update_relationship(

1709: l_csi_relationship_rec.relationship_type_code := 'COMPONENT-OF';
1710: l_csi_relationship_rec.object_id := l_get_csi_child.parent_instance_id;
1711: l_csi_relationship_rec.subject_id := l_get_csi_child.instance_id;
1712: l_csi_relationship_tbl(1) := l_csi_relationship_rec;
1713: CSI_II_RELATIONSHIPS_PUB.update_relationship(
1714: p_api_version => 1.0,
1715: p_relationship_tbl => l_csi_relationship_tbl,
1716: p_txn_rec => l_csi_transaction_rec,
1717: x_return_status => l_return_status,

Line 1935: FROM csi_ii_relationships

1931: l_new_relationship_id NUMBER;
1932: --In order to check whether the instance belongs to a sub unit or an extra node branch
1933: CURSOR check_subuc_extra(c_instance_id NUMBER, c_top_instance_id NUMBER) IS
1934: SELECT object_id, subject_id, position_reference
1935: FROM csi_ii_relationships
1936: WHERE subject_id IN (SELECT csi_item_instance_id
1937: FROM ahl_unit_config_headers
1938: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
1939: OR position_reference IS NULL

Line 1961: FROM csi_ii_relationships R,

1957: C.inv_master_organization_id inventory_org_id,
1958: C.inventory_revision,
1959: C.quantity,
1960: C.unit_of_measure
1961: FROM csi_ii_relationships R,
1962: csi_item_instances C
1963: WHERE R.object_id = p_instance_id
1964: AND R.object_id = C.instance_id
1965: AND R.relationship_type_code = 'COMPONENT-OF'

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

1990: FROM ahl_item_associations_b
1991: WHERE item_group_id = c_item_group_id;
1992: l_get_associated_item get_associated_items%ROWTYPE;
1993: */
1994: --Given an instance_id, get all of its immediate children from csi_ii_relationships
1995: CURSOR get_csi_children(c_instance_id NUMBER) IS
1996: SELECT C.relationship_id csi_ii_relationship_id,
1997: C.object_version_number csi_ii_relationship_ovn,
1998: C.object_id parent_instance_id,

Line 2008: FROM csi_ii_relationships C,

2004: I.inv_master_organization_id inventory_org_id,
2005: I.inventory_revision,
2006: I.quantity,
2007: I.unit_of_measure
2008: FROM csi_ii_relationships C,
2009: ahl_mc_relationships M,
2010: csi_item_instances I
2011: WHERE to_number(C.position_reference) = M.relationship_id (+)
2012: AND C.subject_id = I.instance_id

Line 2054: FROM csi_ii_relationships A

2050: CURSOR get_non_leaf_nodes(c_instance_id NUMBER) IS
2051: SELECT object_id parent_instance_id,
2052: subject_id instance_id,
2053: to_number(position_reference) relationship_id
2054: FROM csi_ii_relationships A
2055: --remove all of the leaf node after finishing the hierarchical query
2056: WHERE EXISTS (SELECT 'X'
2057: FROM csi_ii_relationships B
2058: WHERE B.object_id = A.subject_id

Line 2057: FROM csi_ii_relationships B

2053: to_number(position_reference) relationship_id
2054: FROM csi_ii_relationships A
2055: --remove all of the leaf node after finishing the hierarchical query
2056: WHERE EXISTS (SELECT 'X'
2057: FROM csi_ii_relationships B
2058: WHERE B.object_id = A.subject_id
2059: AND relationship_type_code = 'COMPONENT-OF'
2060: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
2061: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))

Line 2163: FROM csi_ii_relationships

2159: IF p_instance_id = l_get_non_leaf_node.instance_id THEN
2160: l_new_relationship_id := p_relationship_id;
2161: ELSE
2162: SELECT to_number(position_reference) into l_new_relationship_id
2163: FROM csi_ii_relationships
2164: WHERE subject_id = l_get_non_leaf_node.instance_id
2165: AND relationship_type_code='COMPONENT-OF'
2166: AND trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate)
2167: AND trunc(nvl(active_end_date, sysdate+1)) > trunc(sysdate);

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

2236: END IF;
2237: END IF; --whether position_key or position_ref_code matches
2238: END IF; --whether the MC chilren node has already been matched
2239: END LOOP; --of all the MC children
2240: --The following lines are used to update the position_reference column in csi_ii_relationships
2241: --First, get transaction_type_id .
2242: AHL_UTIL_UC_PKG.getcsi_transaction_id('UC_UPDATE',l_transaction_type_id, l_return_value);
2243: IF NOT l_return_value THEN
2244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2257: CSI_II_RELATIONSHIPS_PUB.update_relationship(

2253: l_csi_relationship_rec.relationship_type_code := 'COMPONENT-OF';
2254: l_csi_relationship_rec.object_id := l_get_csi_child.parent_instance_id;
2255: l_csi_relationship_rec.subject_id := l_get_csi_child.instance_id;
2256: l_csi_relationship_tbl(1) := l_csi_relationship_rec;
2257: CSI_II_RELATIONSHIPS_PUB.update_relationship(
2258: p_api_version => 1.0,
2259: p_relationship_tbl => l_csi_relationship_tbl,
2260: p_txn_rec => l_csi_transaction_rec,
2261: x_return_status => l_return_status,

Line 2339: FROM csi_ii_relationships

2335:
2336: -- Get all the children of the current instance that are extra nodes
2337: CURSOR get_extra_children_csr IS
2338: SELECT subject_id
2339: FROM csi_ii_relationships
2340: WHERE object_id = p_instance_id
2341: AND relationship_type_code = 'COMPONENT-OF'
2342: AND position_reference IS NULL
2343: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)

Line 2353: FROM csi_ii_relationships

2349:
2350: -- Get all the children of the current instance that are NOT extra nodes
2351: CURSOR get_premapped_instances_csr IS
2352: SELECT subject_id, position_reference
2353: FROM csi_ii_relationships
2354: WHERE object_id = p_instance_id
2355: AND relationship_type_code = 'COMPONENT-OF'
2356: AND position_reference IS NOT NULL
2357: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)

Line 2381: FROM csi_ii_relationships relationship_id

2377: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
2378: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)
2379: MINUS
2380: SELECT to_number(position_reference) relationship_id
2381: FROM csi_ii_relationships relationship_id
2382: WHERE object_id = p_instance_id
2383: AND relationship_type_code = 'COMPONENT-OF'
2384: AND position_reference IS NOT NULL
2385: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)

Line 2393: FROM csi_ii_relationships C

2389: SELECT C.relationship_id,
2390: C.object_version_number,
2391: C.object_id,
2392: C.subject_id
2393: FROM csi_ii_relationships C
2394: WHERE C.subject_id = c_instance_id
2395: AND C.relationship_type_code = 'COMPONENT-OF'
2396: AND trunc(nvl(C.active_start_date,SYSDATE)) <= trunc(SYSDATE)
2397: AND trunc(nvl(C.active_end_date, SYSDATE+1)) > trunc(SYSDATE);

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

2416: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin',
2417: 'At the start of the procedure, p_instance_id = ' || p_instance_id || ', p_relationship_id = ' || p_relationship_id);
2418: END IF;
2419:
2420: -- Get the transaction_type_id for use later by the CSI_II_RELATIONSHIPS_PUB.update_relationship API
2421: AHL_UTIL_UC_PKG.getcsi_transaction_id('UC_UPDATE', l_transaction_type_id, l_return_value);
2422: IF NOT l_return_value THEN
2423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2424: END IF;

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

2450: l_csi_relationship_rec.subject_id := l_ii_rel_dtls.subject_id;
2451: l_csi_relationship_tbl(1) := l_csi_relationship_rec;
2452: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2453: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY,
2454: 'About to call CSI_II_RELATIONSHIPS_PUB.update_relationship to update CSI II relationship with id ' ||
2455: l_ii_rel_dtls.relationship_id || ' between ' ||
2456: l_ii_rel_dtls.object_id || ' (object) and ' ||
2457: l_ii_rel_dtls.subject_id || '(subject) with NULL position_reference ');
2458: END IF;

Line 2459: CSI_II_RELATIONSHIPS_PUB.update_relationship(

2455: l_ii_rel_dtls.relationship_id || ' between ' ||
2456: l_ii_rel_dtls.object_id || ' (object) and ' ||
2457: l_ii_rel_dtls.subject_id || '(subject) with NULL position_reference ');
2458: END IF;
2459: CSI_II_RELATIONSHIPS_PUB.update_relationship(
2460: p_api_version => 1.0,
2461: p_relationship_tbl => l_csi_relationship_tbl,
2462: p_txn_rec => l_csi_transaction_rec,
2463: x_return_status => l_return_status,

Line 2549: FROM csi_ii_relationships C

2545: SELECT C.relationship_id,
2546: C.object_version_number,
2547: C.object_id,
2548: C.subject_id
2549: FROM csi_ii_relationships C
2550: WHERE C.subject_id = c_instance_id
2551: AND C.relationship_type_code = 'COMPONENT-OF'
2552: AND trunc(nvl(C.active_start_date,SYSDATE)) <= trunc(SYSDATE)
2553: AND trunc(nvl(C.active_end_date, SYSDATE+1)) > trunc(SYSDATE);

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

2576: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin',
2577: '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);
2578: END IF;
2579:
2580: -- Get the transaction_type_id for use later by the CSI_II_RELATIONSHIPS_PUB.update_relationship API
2581: AHL_UTIL_UC_PKG.getcsi_transaction_id('UC_UPDATE', l_transaction_type_id, l_return_value);
2582: IF NOT l_return_value THEN
2583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2584: END IF;

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

2665: l_csi_relationship_rec.subject_id := l_ii_rel_dtls.subject_id;
2666: l_csi_relationship_tbl(1) := l_csi_relationship_rec;
2667: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2668: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY,
2669: 'About to call CSI_II_RELATIONSHIPS_PUB.update_relationship to update CSI II relationship with id ' ||
2670: l_ii_rel_dtls.relationship_id || ' between ' ||
2671: l_ii_rel_dtls.object_id || ' (object) and ' ||
2672: l_ii_rel_dtls.subject_id || '(subject) with position_reference ' ||
2673: to_char(l_current_position));

Line 2675: CSI_II_RELATIONSHIPS_PUB.update_relationship(

2671: l_ii_rel_dtls.object_id || ' (object) and ' ||
2672: l_ii_rel_dtls.subject_id || '(subject) with position_reference ' ||
2673: to_char(l_current_position));
2674: END IF;
2675: CSI_II_RELATIONSHIPS_PUB.update_relationship(
2676: p_api_version => 1.0,
2677: p_relationship_tbl => l_csi_relationship_tbl,
2678: p_txn_rec => l_csi_transaction_rec,
2679: x_return_status => l_return_status,