1971: l_pricing_attrib_id NUMBER := p_pricing_attribs_rec.pricing_attribute_id;
1972: l_pricing_attrib_h_id NUMBER;
1973: BEGIN
1974:
1975: -- Standard Start of API savepoint
1976: SAVEPOINT create_pricing_attribs;
1977:
1978: -- Standard call to check for call compatibility.
1979: IF NOT FND_API.Compatible_API_Call (l_api_version,
1974:
1975: -- Standard Start of API savepoint
1976: SAVEPOINT create_pricing_attribs;
1977:
1978: -- Standard call to check for call compatibility.
1979: IF NOT FND_API.Compatible_API_Call (l_api_version,
1980: p_api_version,
1981: l_api_name ,
1982: g_pkg_name)
2492:
2493:
2494: -- End of API body
2495:
2496: -- Standard check of p_commit.
2497: IF FND_API.To_Boolean( p_commit ) THEN
2498: COMMIT WORK;
2499: END IF;
2500:
2498: COMMIT WORK;
2499: END IF;
2500:
2501:
2502: -- Standard call to get message count and if count is get message info.
2503: FND_MSG_PUB.Count_And_Get
2504: (p_count => x_msg_count ,
2505: p_data => x_msg_data
2506: );
2586: l_pricing_hist_id NUMBER;
2587: l_pricing_hist_csr pricing_hist_csr%ROWTYPE;
2588: BEGIN
2589:
2590: -- Standard Start of API savepoint
2591: SAVEPOINT update_pricing_attribs;
2592:
2593: -- Standard call to check for call compatibility.
2594: IF NOT FND_API.Compatible_API_Call (l_api_version,
2589:
2590: -- Standard Start of API savepoint
2591: SAVEPOINT update_pricing_attribs;
2592:
2593: -- Standard call to check for call compatibility.
2594: IF NOT FND_API.Compatible_API_Call (l_api_version,
2595: p_api_version,
2596: l_api_name ,
2597: g_pkg_name)
7281: END;
7282: -- End of modification for Bug#2547034 on 09/20/02 - rtalluri
7283: -- End of API body
7284:
7285: -- Standard check of p_commit.
7286: IF FND_API.To_Boolean( p_commit ) THEN
7287: COMMIT WORK;
7288: END IF;
7289:
7286: IF FND_API.To_Boolean( p_commit ) THEN
7287: COMMIT WORK;
7288: END IF;
7289:
7290: -- Standard call to get message count and if count is get message info.
7291: FND_MSG_PUB.Count_And_Get
7292: (p_count => x_msg_count ,
7293: p_data => x_msg_data
7294: );
7364: l_pricing_attribs_rec csi_datastructures_pub.pricing_attribs_rec;
7365: l_object_version_number NUMBER;
7366: BEGIN
7367:
7368: -- Standard Start of API savepoint
7369: SAVEPOINT expire_pricing_attribs;
7370:
7371: -- Standard call to check for call compatibility.
7372: IF NOT FND_API.Compatible_API_Call (l_api_version,
7367:
7368: -- Standard Start of API savepoint
7369: SAVEPOINT expire_pricing_attribs;
7370:
7371: -- Standard call to check for call compatibility.
7372: IF NOT FND_API.Compatible_API_Call (l_api_version,
7373: p_api_version,
7374: l_api_name ,
7375: g_pkg_name)
7573: END IF;
7574:
7575: -- End of API body
7576:
7577: -- Standard check of p_commit.
7578: IF FND_API.To_Boolean( p_commit ) THEN
7579: COMMIT WORK;
7580: END IF;
7581:
7578: IF FND_API.To_Boolean( p_commit ) THEN
7579: COMMIT WORK;
7580: END IF;
7581:
7582: -- Standard call to get message count and if count is get message info.
7583: FND_MSG_PUB.Count_And_Get
7584: (p_count => x_msg_count ,
7585: p_data => x_msg_data
7586: );