671: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;
672:
673: BEGIN
674:
675: -- Standard Start of API savepoint
676: SAVEPOINT create_organization_unit;
677:
678: -- Standard call to check for call compatibility.
679: IF NOT FND_API.Compatible_API_Call (l_api_version,
674:
675: -- Standard Start of API savepoint
676: SAVEPOINT create_organization_unit;
677:
678: -- Standard call to check for call compatibility.
679: IF NOT FND_API.Compatible_API_Call (l_api_version,
680: p_api_version,
681: l_api_name ,
682: g_pkg_name)
1060: -- END IF;
1061: END IF; -- called from grp check
1062:
1063: END IF; -- Added by sk for bug 2232880.
1064: -- Standard check of p_commit
1065: IF FND_API.To_Boolean( p_commit ) THEN
1066: COMMIT WORK;
1067: END IF;
1068: -- End of API body
1065: IF FND_API.To_Boolean( p_commit ) THEN
1066: COMMIT WORK;
1067: END IF;
1068: -- End of API body
1069: -- Standard call to get message count and if count is get message info.
1070: FND_MSG_PUB.Count_And_Get
1071: (p_count => x_msg_count ,
1072: p_data => x_msg_data
1073: );
1208: l_org_hist_csr org_hist_csr%ROWTYPE;
1209: l_org_hist_id NUMBER;
1210:
1211: BEGIN
1212: -- Standard Start of API savepoint
1213: SAVEPOINT update_organization_unit;
1214:
1215: -- Standard call to check for call compatibility.
1216: IF NOT FND_API.Compatible_API_Call (l_api_version,
1211: BEGIN
1212: -- Standard Start of API savepoint
1213: SAVEPOINT update_organization_unit;
1214:
1215: -- Standard call to check for call compatibility.
1216: IF NOT FND_API.Compatible_API_Call (l_api_version,
1217: p_api_version,
1218: l_api_name ,
1219: g_pkg_name)
2367: END;
2368: -- End of modification for Bug#2547034 on 09/20/02 - rtalluri
2369: -- End of API body
2370:
2371: -- Standard check of p_commit.
2372: IF FND_API.To_Boolean( p_commit ) THEN
2373: COMMIT WORK;
2374: END IF;
2375:
2451: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;
2452:
2453: BEGIN
2454:
2455: -- Standard Start of API savepoint
2456: SAVEPOINT expire_organization_unit;
2457:
2458: -- Standard call to check for call compatibility.
2459: IF NOT FND_API.Compatible_API_Call (l_api_version,
2454:
2455: -- Standard Start of API savepoint
2456: SAVEPOINT expire_organization_unit;
2457:
2458: -- Standard call to check for call compatibility.
2459: IF NOT FND_API.Compatible_API_Call (l_api_version,
2460: p_api_version,
2461: l_api_name ,
2462: g_pkg_name)
2567:
2568: -- End of API body
2569:
2570:
2571: -- Standard check of p_commit.
2572: IF FND_API.To_Boolean( p_commit ) THEN
2573: COMMIT WORK;
2574: END IF;
2575:
2573: COMMIT WORK;
2574: END IF;
2575:
2576:
2577: -- Standard call to get message count and if count is get message info.
2578: FND_MSG_PUB.Count_And_Get
2579: (p_count => x_msg_count ,
2580: p_data => x_msg_data
2581: );
2700: WHERE oah.transaction_id = i_transaction_id
2701: AND oah.instance_ou_id = oa.instance_ou_id;
2702:
2703: BEGIN
2704: -- Standard Start of API savepoint
2705: -- SAVEPOINT get_org_unit_history;
2706:
2707:
2708: -- Standard call to check for call compatibility.
2704: -- Standard Start of API savepoint
2705: -- SAVEPOINT get_org_unit_history;
2706:
2707:
2708: -- Standard call to check for call compatibility.
2709: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2710: p_api_version ,
2711: l_api_name ,
2712: g_pkg_name )
2819:
2820:
2821: -- End of API body
2822:
2823: -- Standard check of p_commit.
2824: /*
2825: IF FND_API.To_Boolean( p_commit ) THEN
2826: COMMIT WORK;
2827: END IF;
2827: END IF;
2828: */
2829:
2830:
2831: -- Standard call to get message count and if count is get message info.
2832: FND_MSG_PUB.Count_And_Get
2833: (p_count => x_msg_count,
2834: p_data => x_msg_data
2835: );