DBA Data[Home] [Help]

APPS.PSB_BUDGET_REVISIONS_PVT dependencies on STANDARD

Line 245: -- Standard Start of API savepoint

241: l_api_version CONSTANT NUMBER := 1.0;
242:
243: BEGIN
244:
245: -- Standard Start of API savepoint
246:
247: SAVEPOINT DELETE_ROW;
248:
249: -- Standard call to check for call compatibility.

Line 249: -- Standard call to check for call compatibility.

245: -- Standard Start of API savepoint
246:
247: SAVEPOINT DELETE_ROW;
248:
249: -- Standard call to check for call compatibility.
250:
251: if not FND_API.Compatible_API_Call (l_api_version,
252: p_api_version,
253: l_api_name,

Line 276: -- Standard call to get message count and if count is 1, get message info.

272: END IF;
273:
274: p_return_status := FND_API.G_RET_STS_SUCCESS;
275:
276: -- Standard call to get message count and if count is 1, get message info.
277:
278: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
279: p_data => p_msg_data);
280:

Line 281: -- Standard check of p_commit.

277:
278: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
279: p_data => p_msg_data);
280:
281: -- Standard check of p_commit.
282:
283: if FND_API.to_Boolean (p_commit) THEN
284: commit work;
285: END IF;

Line 400: -- Standard Start of API savepoint

396: from dual;
397:
398: BEGIN
399:
400: -- Standard Start of API savepoint
401:
402: SAVEPOINT Create_Budget_Revision;
403:
404: -- Standard call to check for call compatibility.

Line 404: -- Standard call to check for call compatibility.

400: -- Standard Start of API savepoint
401:
402: SAVEPOINT Create_Budget_Revision;
403:
404: -- Standard call to check for call compatibility.
405:
406: if not FND_API.Compatible_API_Call (l_api_version,
407: p_api_version,
408: l_api_name,

Line 628: -- Standard check of p_commit.

624: -- Initialize API return status to success
625:
626: p_return_status := FND_API.G_RET_STS_SUCCESS;
627:
628: -- Standard check of p_commit.
629:
630: IF FND_API.to_Boolean (p_commit) THEN
631: commit work;
632: END IF;

Line 634: -- Standard call to get message count and if count is 1, get message info.

630: IF FND_API.to_Boolean (p_commit) THEN
631: commit work;
632: END IF;
633:
634: -- Standard call to get message count and if count is 1, get message info.
635:
636: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
637: p_data => p_msg_data);
638:

Line 960: -- Standard call to check for call compatibility.

956: AND set_of_books_id = g_set_of_books_id
957: AND period_name = p_gl_period_name;
958: --
959: BEGIN
960: -- Standard call to check for call compatibility.
961: IF NOT FND_API.Compatible_API_Call (l_api_version,
962: p_api_version,
963: l_api_name,
964: G_PKG_NAME)

Line 1180: -- Standard call to get message count and if count is 1, get message info.

1176: -- Initialize API return status to success
1177:
1178: p_return_status := FND_API.G_RET_STS_SUCCESS;
1179:
1180: -- Standard call to get message count and if count is 1, get message info.
1181:
1182: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1183: p_data => p_msg_data);
1184:

Line 1616: -- Standard Start of API savepoint

1612: pgi.currency_code;
1613: -- Bug#4310411 End
1614: BEGIN
1615:
1616: -- Standard Start of API savepoint
1617:
1618: SAVEPOINT CREATE_BASE_BUDGET_REVISION;
1619:
1620: -- Standard call to check for call compatibility.

Line 1620: -- Standard call to check for call compatibility.

1616: -- Standard Start of API savepoint
1617:
1618: SAVEPOINT CREATE_BASE_BUDGET_REVISION;
1619:
1620: -- Standard call to check for call compatibility.
1621:
1622: if not FND_API.Compatible_API_Call (l_api_version,
1623: p_api_version,
1624: l_api_name,

Line 1763: -- Standard check of p_commit.

1759: -- Initialize API return status to success
1760:
1761: p_return_status := FND_API.G_RET_STS_SUCCESS;
1762:
1763: -- Standard check of p_commit.
1764:
1765: IF FND_API.to_Boolean (p_commit) THEN
1766: commit work;
1767: END IF;

Line 1769: -- Standard call to get message count and if count is 1, get message info.

1765: IF FND_API.to_Boolean (p_commit) THEN
1766: commit work;
1767: END IF;
1768:
1769: -- Standard call to get message count and if count is 1, get message info.
1770:
1771: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1772: p_data => p_msg_data);
1773:

Line 2186: -- Standard Start of API savepoint

2182: from dual;
2183:
2184: Begin
2185:
2186: -- Standard Start of API savepoint
2187: SAVEPOINT Budget_Revision_Funds_Check;
2188:
2189: -- Standard call to check for call compatibility.
2190: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 2189: -- Standard call to check for call compatibility.

2185:
2186: -- Standard Start of API savepoint
2187: SAVEPOINT Budget_Revision_Funds_Check;
2188:
2189: -- Standard call to check for call compatibility.
2190: IF NOT FND_API.Compatible_API_Call (l_api_version,
2191: p_api_version,
2192: l_api_name,
2193: G_PKG_NAME)

Line 2413: -- Standard check of p_commit.

2409:
2410: -- Initialize API return status to success
2411: p_return_status := FND_API.G_RET_STS_SUCCESS;
2412:
2413: -- Standard check of p_commit.
2414: if FND_API.to_Boolean (p_commit) then
2415: commit work;
2416: end if;
2417:

Line 3241: -- Standard Start of API savepoint

3237: and startdate between start_date and end_date;
3238:
3239: Begin
3240:
3241: -- Standard Start of API savepoint
3242:
3243: SAVEPOINT Create_Mass_Revision_Entries;
3244:
3245: -- Standard call to check for call compatibility.

Line 3245: -- Standard call to check for call compatibility.

3241: -- Standard Start of API savepoint
3242:
3243: SAVEPOINT Create_Mass_Revision_Entries;
3244:
3245: -- Standard call to check for call compatibility.
3246:
3247: if not FND_API.Compatible_API_Call (l_api_version,
3248: p_api_version,
3249: l_api_name,

Line 3662: -- Standard check of p_commit.

3658: -- Initialize API return status to success
3659:
3660: p_return_status := FND_API.G_RET_STS_SUCCESS;
3661:
3662: -- Standard check of p_commit.
3663:
3664: if FND_API.to_Boolean (p_commit) then
3665: commit work;
3666: end if;

Line 3668: -- Standard call to get message count and if count is 1, get message info.

3664: if FND_API.to_Boolean (p_commit) then
3665: commit work;
3666: end if;
3667:
3668: -- Standard call to get message count and if count is 1, get message info.
3669:
3670: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
3671: p_data => p_msg_data);
3672:

Line 3908: -- Standard call to check for call compatibility.

3904: BEGIN
3905:
3906: SAVEPOINT Create_Revision_Positions;
3907:
3908: -- Standard call to check for call compatibility.
3909:
3910: IF NOT FND_API.Compatible_API_Call (l_api_version,
3911: p_api_version,
3912: l_api_name,

Line 4209: -- Standard check of p_commit.

4205: -- Initialize API return status to success
4206:
4207: p_return_status := FND_API.G_RET_STS_SUCCESS;
4208:
4209: -- Standard check of p_commit.
4210:
4211: if FND_API.to_Boolean (p_commit) then
4212: commit work;
4213: end if;

Line 4215: -- Standard call to get message count and if count is 1, get message info.

4211: if FND_API.to_Boolean (p_commit) then
4212: commit work;
4213: end if;
4214:
4215: -- Standard call to get message count and if count is 1, get message info.
4216:
4217: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
4218: p_data => p_msg_data);
4219:

Line 4706: -- Standard Start of API savepoint

4702: where worksheet_id = p_budget_revision_id;
4703:
4704: BEGIN
4705:
4706: -- Standard Start of API savepoint
4707:
4708: /* Bug No 2532617 Start */
4709: -- Removed the savepoint since intermediate commits have been introduced in called procedures
4710: -- SAVEPOINT Update_Baseline_Values;

Line 4713: -- Standard call to check for call compatibility.

4709: -- Removed the savepoint since intermediate commits have been introduced in called procedures
4710: -- SAVEPOINT Update_Baseline_Values;
4711: /* Bug No 2532617 End */
4712:
4713: -- Standard call to check for call compatibility.
4714:
4715: if not FND_API.Compatible_API_Call (l_api_version,
4716: p_api_version,
4717: l_api_name,

Line 5009: -- Standard check of p_commit.

5005: end if;
5006: --++ end upload to HRMS budget
5007:
5008:
5009: -- Standard check of p_commit.
5010:
5011: if FND_API.to_Boolean (p_commit) THEN
5012: commit work;
5013: END IF;

Line 5015: -- Standard call to get message count and if count is 1, get message info.

5011: if FND_API.to_Boolean (p_commit) THEN
5012: commit work;
5013: END IF;
5014:
5015: -- Standard call to get message count and if count is 1, get message info.
5016:
5017: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
5018: p_data => p_msg_data);
5019:

Line 5227: -- Standard call to check for call compatibility.

5223: )
5224: );
5225: --
5226: BEGIN
5227: -- Standard call to check for call compatibility.
5228: IF NOT FND_API.Compatible_API_Call (l_api_version,
5229: p_api_version,
5230: l_api_name,
5231: G_PKG_NAME)

Line 5328: -- Standard call to get message count and if count is 1, get message info.

5324:
5325: -- Initialize API return status to success
5326: p_return_status := FND_API.G_RET_STS_SUCCESS;
5327:
5328: -- Standard call to get message count and if count is 1, get message info.
5329: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
5330: p_data => p_msg_data);
5331: --
5332: EXCEPTION

Line 7027: -- Standard call to check for call compatibility

7023: and (end_date > p_revision_end_date)));
7024:
7025: BEGIN
7026:
7027: -- Standard call to check for call compatibility
7028:
7029: if not FND_API.Compatible_API_Call (l_api_version,
7030: p_api_version,
7031: l_api_name,

Line 9263: -- Standard call to check for call compatibility.

9259: l_return_status VARCHAR2(1);
9260:
9261: BEGIN
9262:
9263: -- Standard call to check for call compatibility.
9264:
9265: if not FND_API.Compatible_API_Call (l_api_version,
9266: p_api_version,
9267: l_api_name,

Line 9409: -- Standard call to check for call compatibility.

9405: where budget_revision_pos_line_id = p_budget_revision_pos_line_id;
9406:
9407: BEGIN
9408:
9409: -- Standard call to check for call compatibility.
9410:
9411: IF NOT FND_API.Compatible_API_Call (l_api_version,
9412: p_api_version,
9413: l_api_name,

Line 9478: -- Standard call to get message count and if count is 1, get message info.

9474: -- Initialize API return status to success
9475:
9476: p_return_status := FND_API.G_RET_STS_SUCCESS;
9477:
9478: -- Standard call to get message count and if count is 1, get message info.
9479:
9480: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
9481: p_data => p_msg_data);
9482:

Line 9550: -- Standard call to check for call compatibility.

9546: and pbrl.budget_revision_acct_line_id = p_budget_revision_acct_line_id;
9547:
9548: Begin
9549:
9550: -- Standard call to check for call compatibility.
9551:
9552: IF NOT FND_API.Compatible_API_Call (l_api_version,
9553: p_api_version,
9554: l_api_name,

Line 9599: -- Standard call to get message count and if count is 1, get message info.

9595: END IF;
9596:
9597: end if;
9598:
9599: -- Standard call to get message count and if count is 1, get message info.
9600:
9601: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
9602: p_data => p_msg_data);
9603:

Line 11038: --as AD coding standards doesn't allow chr(10), it has been changed

11034: /*For Bug No : 2150471 Start*/
11035: l_apply_message := NULL;
11036: l_balance_message := NULL;
11037: --Pls. do not change the formatted new line characters below.
11038: --as AD coding standards doesn't allow chr(10), it has been changed
11039: FOR l_index IN 1..g_no_ccids LOOP
11040: SELECT concatenated_segments INTO l_con_segments
11041: FROM GL_CODE_COMBINATIONS_KFV
11042: WHERE code_combination_id = g_ccid_rec(l_index).ccid;