[Home] [Help]
61: l_return_status_full VARCHAR2(1);
62: l_debug_level NUMBER;
63: l_cur_hop NUMBER;
64: BEGIN
65: -- standard start of api savepoint
66: --SAVEPOINT get_cylic_relationships_pvt;
67:
68: -- standard call to check for call compatibility.
69: IF NOT fnd_api.compatible_api_call ( l_api_version,
64: BEGIN
65: -- standard start of api savepoint
66: --SAVEPOINT get_cylic_relationships_pvt;
67:
68: -- standard call to check for call compatibility.
69: IF NOT fnd_api.compatible_api_call ( l_api_version,
70: p_api_version,
71: l_api_name,
72: g_pkg_name)
2216: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
2217: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
2218:
2219: BEGIN
2220: -- standard start of api savepoint
2221: -- SAVEPOINT get_relationships_pvt;
2222:
2223: -- standard call to check for call compatibility.
2224: IF NOT fnd_api.compatible_api_call ( l_api_version,
2219: BEGIN
2220: -- standard start of api savepoint
2221: -- SAVEPOINT get_relationships_pvt;
2222:
2223: -- standard call to check for call compatibility.
2224: IF NOT fnd_api.compatible_api_call ( l_api_version,
2225: p_api_version,
2226: l_api_name,
2227: g_pkg_name)
3036:
3037: --
3038: -- end of API body
3039: --
3040: -- standard call to get message count and if count is 1, get message info.
3041: fnd_msg_pub.count_AND_get
3042: ( p_encoded => FND_API.G_FALSE, --Added for bug 10081206
3043: p_count => x_msg_count,
3044: p_data => x_msg_data
4843: l_cascade_instance_rec csi_datastructures_pub.instance_rec;
4844: -- End addition for cascade ownership changes bug 2972082
4845:
4846: BEGIN
4847: -- standard start of api savepoint
4848: SAVEPOINT create_relationship_pvt;
4849:
4850: -- standard call to check for call compatibility.
4851: IF NOT fnd_api.compatible_api_call ( l_api_version,
4846: BEGIN
4847: -- standard start of api savepoint
4848: SAVEPOINT create_relationship_pvt;
4849:
4850: -- standard call to check for call compatibility.
4851: IF NOT fnd_api.compatible_api_call ( l_api_version,
4852: p_api_version,
4853: l_api_name,
4854: g_pkg_name)
5285: --
5286: -- END of API BODY
5287: --
5288:
5289: -- standard check for p_commit
5290: IF fnd_api.to_boolean( p_commit )
5291: THEN
5292: COMMIT WORK;
5293: END IF;
5291: THEN
5292: COMMIT WORK;
5293: END IF;
5294:
5295: -- standard call to get message count and if count is 1, get message info.
5296: fnd_msg_pub.count_AND_get
5297: (p_encoded => FND_API.G_FALSE, --Added for bug 10081206
5298: p_count => x_msg_count,
5299: p_data => x_msg_data
5434: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
5435: l_is_a_child VARCHAR2(1); --Added for Bug 14163453
5436:
5437: BEGIN
5438: -- standard start of api savepoint
5439: SAVEPOINT update_relationship_pvt;
5440: -- standard call to check for call compatibility.
5441: IF NOT fnd_api.compatible_api_call ( l_api_version,
5442: p_api_version,
5436:
5437: BEGIN
5438: -- standard start of api savepoint
5439: SAVEPOINT update_relationship_pvt;
5440: -- standard call to check for call compatibility.
5441: IF NOT fnd_api.compatible_api_call ( l_api_version,
5442: p_api_version,
5443: l_api_name,
5444: g_pkg_name)
6163: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6164: RAISE fnd_api.g_exc_error;
6165: END IF;
6166:
6167: -- standard check for p_commit
6168: IF fnd_api.to_boolean( p_commit )
6169: THEN
6170: COMMIT WORK;
6171: END IF;
6172:
6173:
6174:
6175:
6176: -- standard call to get message count and if count is 1, get message info.
6177: fnd_msg_pub.count_AND_get
6178: ( p_encoded => FND_API.G_FALSE, --Added for bug 10081206
6179: p_count => x_msg_count,
6180: p_data => x_msg_data
6289: l_is_locked BOOLEAN;
6290: l_lock_id NUMBER;
6291: l_serial_number VARCHAR2(60);
6292: BEGIN
6293: -- standard start of api savepoint
6294: SAVEPOINT expire_relationship_pvt;
6295:
6296: -- standard call to check for call compatibility.
6297: IF NOT fnd_api.compatible_api_call ( l_api_version,
6292: BEGIN
6293: -- standard start of api savepoint
6294: SAVEPOINT expire_relationship_pvt;
6295:
6296: -- standard call to check for call compatibility.
6297: IF NOT fnd_api.compatible_api_call ( l_api_version,
6298: p_api_version,
6299: l_api_name,
6300: g_pkg_name)
6653: IF x_return_status <> fnd_api.g_ret_sts_success THEN
6654: RAISE fnd_api.g_exc_error;
6655: END IF;
6656:
6657: -- standard check for p_commit
6658: IF fnd_api.to_boolean( p_commit )
6659: THEN
6660: COMMIT WORK;
6661: END IF;
6659: THEN
6660: COMMIT WORK;
6661: END IF;
6662:
6663: -- standard call to get message count and if count is 1, get message info.
6664: fnd_msg_pub.count_AND_get
6665: ( p_encoded => FND_API.G_FALSE, --Added for bug 10081206
6666: p_count => x_msg_count,
6667: p_data => x_msg_data
6774: END IF;
6775:
6776:
6777:
6778: -- standard call to get message count and if count is 1, get message info.
6779: fnd_msg_pub.count_AND_get
6780: ( p_encoded => FND_API.G_FALSE, --Added for bug 10081206
6781: p_count => x_msg_count,
6782: p_data => x_msg_data
6855: fnd_msg_pub.add;
6856: x_return_status := fnd_api.g_ret_sts_error;
6857: END IF;
6858: END IF;
6859: -- standard call to get message count and if count is 1, get message info.
6860: fnd_msg_pub.count_AND_get
6861: ( p_encoded => FND_API.G_FALSE, --Added for bug 10081206
6862: p_count => x_msg_count,
6863: p_data => x_msg_data
7110: END;
7111: END IF;
7112: END IF;
7113:
7114: -- standard call to get message count and if count is 1, get message info.
7115: fnd_msg_pub.count_and_get
7116: ( p_encoded => FND_API.G_FALSE, --Added for bug 10081206
7117: p_count => x_msg_count,
7118: p_data => x_msg_data
7189: fnd_msg_pub.add;
7190: x_return_status := fnd_api.g_ret_sts_error;
7191: END;
7192: END IF;
7193: -- standard call to get message count and if count is 1, get message info.
7194: fnd_msg_pub.count_AND_get
7195: ( p_encoded => FND_API.G_FALSE, --Added for bug 10081206
7196: p_count => x_msg_count,
7197: p_data => x_msg_data
7225: fnd_msg_pub.add;
7226: x_return_status := fnd_api.g_ret_sts_error;
7227: END IF;
7228: END IF;
7229: -- standard call to get message count and if count is 1, get message info.
7230: fnd_msg_pub.count_AND_get
7231: ( p_encoded => FND_API.G_FALSE, --Added for bug 10081206
7232: p_count => x_msg_count,
7233: p_data => x_msg_data
7270: x_return_status := fnd_api.g_ret_sts_success;
7271: END IF;
7272: END IF;
7273:
7274: -- standard call to get message count and if count is 1, get message info.
7275: fnd_msg_pub.count_and_get
7276: ( p_encoded => FND_API.G_FALSE, --Added for bug 10081206
7277: p_count => x_msg_count,
7278: p_data => x_msg_data
7522: WHERE cih.transaction_id = i_transaction_id
7523: AND cih.relationship_id = cir.relationship_id;
7524:
7525: BEGIN
7526: -- Standard Start of API savepoint
7527: --SAVEPOINT get_inst_relationship_hist;
7528:
7529: -- Standard call to check for call compatibility.
7530: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
7525: BEGIN
7526: -- Standard Start of API savepoint
7527: --SAVEPOINT get_inst_relationship_hist;
7528:
7529: -- Standard call to check for call compatibility.
7530: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
7531: p_api_version ,
7532: l_api_name ,
7533: g_pkg_name )
7669: csi_ii_relationships_pvt.Resolve_id_columns(x_rel_history_tbl);
7670:
7671: -- End of API body
7672:
7673: -- Standard check of p_commit.
7674: /*
7675: IF FND_API.To_Boolean( p_commit ) THEN
7676: COMMIT WORK;
7677: END IF;
7684: END IF;
7685: -- End disable trace
7686: ****/
7687:
7688: -- Standard call to get message count and if count is get message info.
7689: FND_MSG_PUB.Count_And_Get
7690: (p_encoded => FND_API.G_FALSE, --Added for bug 10081206
7691: p_count => x_msg_count ,
7692: p_data => x_msg_data );