DBA Data[Home] [Help]

APPS.AHL_UC_TREE_PVT dependencies on CSI_II_RELATIONSHIPS_PUB

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 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 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 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 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,