DBA Data[Home] [Help]

APPS.AHL_UC_TREE_PVT dependencies on CSI_II_RELATIONSHIPS_PUB

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