42: l_return_status_full VARCHAR2(1);
43: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
44: BEGIN
45:
46: -- Standard Start of API savepoint
47: SAVEPOINT CREATE_rs_camp_PVT;
48:
49: -- Standard call to check for call compatibility.
50: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
45:
46: -- Standard Start of API savepoint
47: SAVEPOINT CREATE_rs_camp_PVT;
48:
49: -- Standard call to check for call compatibility.
50: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
51: p_api_version_number,
52: l_api_name,
53: G_PKG_NAME)
165: --
166: -- End of API body
167: --
168:
169: -- Standard check for p_commit
170: IF FND_API.to_Boolean( p_commit )
171: THEN
172: COMMIT WORK;
173: END IF;
176: -- Debug Message
177: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');
178:
179:
180: -- Standard call to get message count and if count is 1, get message info.
181: FND_MSG_PUB.Count_And_Get
182: ( p_count => x_msg_count,
183: p_data => x_msg_data
184: );
274: l_ref_rs_camp_rec AST_rs_camp_PVT.rs_camp_Rec_Type;
275: l_tar_rs_camp_rec AST_rs_camp_PVT.rs_camp_Rec_Type := P_rs_camp_Rec;
276: l_rowid ROWID;
277: BEGIN
278: -- Standard Start of API savepoint
279: SAVEPOINT UPDATE_rs_camp_PVT;
280:
281: -- Standard call to check for call compatibility.
282: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
277: BEGIN
278: -- Standard Start of API savepoint
279: SAVEPOINT UPDATE_rs_camp_PVT;
280:
281: -- Standard call to check for call compatibility.
282: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
283: p_api_version_number,
284: l_api_name,
285: G_PKG_NAME)
437: --
438: -- End of API body.
439: --
440:
441: -- Standard check for p_commit
442: IF FND_API.to_Boolean( p_commit )
443: THEN
444: COMMIT WORK;
445: END IF;
445: END IF;
446:
447: -- Debug Message
448: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');
449: -- Standard call to get message count and if count is 1, get message info.
450: FND_MSG_PUB.Count_And_Get
451: ( p_count => x_msg_count,
452: p_data => x_msg_data
453: );
522: l_api_name CONSTANT VARCHAR2(30) := 'Delete_rs_camp';
523: l_api_version_number CONSTANT NUMBER := 1.0;
524: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
525: BEGIN
526: -- Standard Start of API savepoint
527: SAVEPOINT DELETE_rs_camp_PVT;
528:
529: -- Standard call to check for call compatibility.
530: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
525: BEGIN
526: -- Standard Start of API savepoint
527: SAVEPOINT DELETE_rs_camp_PVT;
528:
529: -- Standard call to check for call compatibility.
530: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
531: p_api_version_number,
532: l_api_name,
533: G_PKG_NAME)
596: --
597: -- End of API body
598: --
599:
600: -- Standard check for p_commit
601: IF FND_API.to_Boolean( p_commit )
602: THEN
603: COMMIT WORK;
604: END IF;
608: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');
609:
610:
611:
612: -- Standard call to get message count and if count is 1, get message info.
613: FND_MSG_PUB.Count_And_Get
614: ( p_count => x_msg_count,
615: p_data => x_msg_data
616: );
992: -- Local scratch record
993: l_rs_camp_rec AST_rs_camp_PUB.rs_camp_Rec_Type;
994: l_crit_rs_camp_rec AST_rs_camp_PUB.rs_camp_Rec_Type;
995: BEGIN
996: -- Standard Start of API savepoint
997: SAVEPOINT GET_rs_camp_PVT;
998:
999: -- Standard call to check for call compatibility.
1000: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
995: BEGIN
996: -- Standard Start of API savepoint
997: SAVEPOINT GET_rs_camp_PVT;
998:
999: -- Standard call to check for call compatibility.
1000: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1001: p_api_version_number,
1002: l_api_name,
1003: G_PKG_NAME)
1180: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');
1181:
1182:
1183:
1184: -- Standard call to get message count and if count is 1, get message info.
1185: FND_MSG_PUB.Count_And_Get
1186: ( p_count => x_msg_count,
1187: p_data => x_msg_data
1188: );
1266: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1267: NULL;
1268: END IF;
1269:
1270: -- Standard call to get message count and if count is 1, get message info.
1271: FND_MSG_PUB.Count_And_Get
1272: ( p_count => x_msg_count,
1273: p_data => x_msg_data
1274: );
1322: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1323: NULL;
1324: END IF;
1325:
1326: -- Standard call to get message count and if count is 1, get message info.
1327: FND_MSG_PUB.Count_And_Get
1328: ( p_count => x_msg_count,
1329: p_data => x_msg_data
1330: );
1378: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1379: NULL;
1380: END IF;
1381:
1382: -- Standard call to get message count and if count is 1, get message info.
1383: FND_MSG_PUB.Count_And_Get
1384: ( p_count => x_msg_count,
1385: p_data => x_msg_data
1386: );
1426: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1427: NULL;
1428: END IF;
1429:
1430: -- Standard call to get message count and if count is 1, get message info.
1431: FND_MSG_PUB.Count_And_Get
1432: ( p_count => x_msg_count,
1433: p_data => x_msg_data
1434: );
1474: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1475: NULL;
1476: END IF;
1477:
1478: -- Standard call to get message count and if count is 1, get message info.
1479: FND_MSG_PUB.Count_And_Get
1480: ( p_count => x_msg_count,
1481: p_data => x_msg_data
1482: );
1530: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1531: NULL;
1532: END IF;
1533:
1534: -- Standard call to get message count and if count is 1, get message info.
1535: FND_MSG_PUB.Count_And_Get
1536: ( p_count => x_msg_count,
1537: p_data => x_msg_data
1538: );
1586: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1587: NULL;
1588: END IF;
1589:
1590: -- Standard call to get message count and if count is 1, get message info.
1591: FND_MSG_PUB.Count_And_Get
1592: ( p_count => x_msg_count,
1593: p_data => x_msg_data
1594: );
1629:
1630: -- Debug Message
1631: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'API_INVALID_RECORD');
1632:
1633: -- Standard call to get message count and if count is 1, get message info.
1634: FND_MSG_PUB.Count_And_Get
1635: ( p_count => x_msg_count,
1636: p_data => x_msg_data
1637: );