DBA Data[Home] [Help]

APPS.CSD_REPAIR_JOB_XREF_PVT dependencies on STANDARD

Line 42: -- Standard Start of API savepoint

38: l_api_version_number CONSTANT NUMBER := 1.0;
39: l_return_status_full VARCHAR2(1);
40: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
41: BEGIN
42: -- Standard Start of API savepoint
43: SAVEPOINT CREATE_REPJOBXREF_PVT;
44:
45: -- Standard call to check for call compatibility.
46: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

41: BEGIN
42: -- Standard Start of API savepoint
43: SAVEPOINT CREATE_REPJOBXREF_PVT;
44:
45: -- Standard call to check for call compatibility.
46: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
47: p_api_version_number,
48: l_api_name,
49: G_PKG_NAME)

Line 192: -- Standard check for p_commit

188: --
189: -- End of API body
190: --
191:
192: -- Standard check for p_commit
193: IF FND_API.to_Boolean( p_commit )
194: THEN
195: COMMIT WORK;
196: END IF;

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

199: -- Debug Message
200: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
201:
202:
203: -- Standard call to get message count and if count is 1, get message info.
204: FND_MSG_PUB.Count_And_Get
205: ( p_count => x_msg_count,
206: p_data => x_msg_data
207: );

Line 322: -- Standard Start of API savepoint

318: l_ref_REPJOBXREF_rec CSD_repair_job_xref_PVT.REPJOBXREF_Rec_Type;
319: l_tar_REPJOBXREF_rec CSD_repair_job_xref_PVT.REPJOBXREF_Rec_Type := P_REPJOBXREF_Rec;
320: l_rowid ROWID;
321: BEGIN
322: -- Standard Start of API savepoint
323: SAVEPOINT UPDATE_REPJOBXREF_PVT;
324:
325: -- Standard call to check for call compatibility.
326: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

321: BEGIN
322: -- Standard Start of API savepoint
323: SAVEPOINT UPDATE_REPJOBXREF_PVT;
324:
325: -- Standard call to check for call compatibility.
326: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
327: p_api_version_number,
328: l_api_name,
329: G_PKG_NAME)

Line 524: -- Standard check for p_commit

520: --
521: -- End of API body.
522: --
523:
524: -- Standard check for p_commit
525: IF FND_API.to_Boolean( p_commit )
526: THEN
527: COMMIT WORK;
528: END IF;

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

531: -- Debug Message
532: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
533:
534:
535: -- Standard call to get message count and if count is 1, get message info.
536: FND_MSG_PUB.Count_And_Get
537: ( p_count => x_msg_count,
538: p_data => x_msg_data
539: );

Line 613: -- Standard Start of API savepoint

609: l_api_name CONSTANT VARCHAR2(30) := 'Delete_repjobxref';
610: l_api_version_number CONSTANT NUMBER := 2.0;
611: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
612: BEGIN
613: -- Standard Start of API savepoint
614: SAVEPOINT DELETE_REPJOBXREF_PVT;
615:
616: -- Standard call to check for call compatibility.
617: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

612: BEGIN
613: -- Standard Start of API savepoint
614: SAVEPOINT DELETE_REPJOBXREF_PVT;
615:
616: -- Standard call to check for call compatibility.
617: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
618: p_api_version_number,
619: l_api_name,
620: G_PKG_NAME)

Line 685: -- Standard check for p_commit

681: --
682: -- End of API body
683: --
684:
685: -- Standard check for p_commit
686: IF FND_API.to_Boolean( p_commit )
687: THEN
688: COMMIT WORK;
689: END IF;

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

692: -- Debug Message
693: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
694:
695:
696: -- Standard call to get message count and if count is 1, get message info.
697: FND_MSG_PUB.Count_And_Get
698: ( p_count => x_msg_count,
699: p_data => x_msg_data
700: );

Line 1125: -- Standard Start of API savepoint

1121: -- Local scratch record
1122: l_REPJOBXREF_rec REPJOBXREF_Rec_Type;
1123: l_crit_REPJOBXREF_rec REPJOBXREF_Rec_Type;
1124: BEGIN
1125: -- Standard Start of API savepoint
1126: SAVEPOINT GET_REPJOBXREF_PVT;
1127:
1128: -- Standard call to check for call compatibility.
1129: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1124: BEGIN
1125: -- Standard Start of API savepoint
1126: SAVEPOINT GET_REPJOBXREF_PVT;
1127:
1128: -- Standard call to check for call compatibility.
1129: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1130: p_api_version_number,
1131: l_api_name,
1132: G_PKG_NAME)

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

1293: -- Debug Message
1294: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
1295:
1296:
1297: -- Standard call to get message count and if count is 1, get message info.
1298: FND_MSG_PUB.Count_And_Get
1299: ( p_count => x_msg_count,
1300: p_data => x_msg_data
1301: );

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

1381: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1382: NULL;
1383: END IF;
1384:
1385: -- Standard call to get message count and if count is 1, get message info.
1386: FND_MSG_PUB.Count_And_Get
1387: ( p_count => x_msg_count,
1388: p_data => x_msg_data
1389: );

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

1435: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1436: NULL;
1437: END IF;
1438:
1439: -- Standard call to get message count and if count is 1, get message info.
1440: FND_MSG_PUB.Count_And_Get
1441: ( p_count => x_msg_count,
1442: p_data => x_msg_data
1443: );

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

1489: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1490: NULL;
1491: END IF;
1492:
1493: -- Standard call to get message count and if count is 1, get message info.
1494: FND_MSG_PUB.Count_And_Get
1495: ( p_count => x_msg_count,
1496: p_data => x_msg_data
1497: );

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

1543: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1544: NULL;
1545: END IF;
1546:
1547: -- Standard call to get message count and if count is 1, get message info.
1548: FND_MSG_PUB.Count_And_Get
1549: ( p_count => x_msg_count,
1550: p_data => x_msg_data
1551: );

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

1597: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1598: NULL;
1599: END IF;
1600:
1601: -- Standard call to get message count and if count is 1, get message info.
1602: FND_MSG_PUB.Count_And_Get
1603: ( p_count => x_msg_count,
1604: p_data => x_msg_data
1605: );

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

1651: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1652: NULL;
1653: END IF;
1654:
1655: -- Standard call to get message count and if count is 1, get message info.
1656: FND_MSG_PUB.Count_And_Get
1657: ( p_count => x_msg_count,
1658: p_data => x_msg_data
1659: );

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

1745: end if;
1746:
1747: END IF;
1748:
1749: -- Standard call to get message count and if count is 1, get message info.
1750: FND_MSG_PUB.Count_And_Get
1751: ( p_count => x_msg_count,
1752: p_data => x_msg_data
1753: );

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

1786:
1787: -- Debug Message
1788: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'API_INVALID_RECORD');
1789:
1790: -- Standard call to get message count and if count is 1, get message info.
1791: FND_MSG_PUB.Count_And_Get
1792: ( p_count => x_msg_count,
1793: p_data => x_msg_data
1794: );