DBA Data[Home] [Help]

APPS.CSC_CUST_PLANS_PVT dependencies on STANDARD

Line 254: -- Standard Start of API savepoint

250:
251: l_start_date_active DATE := p_csc_cust_plans_rec.start_date_active;
252: l_end_date_active DATE := p_csc_cust_plans_rec.end_date_active;
253: BEGIN
254: -- Standard Start of API savepoint
255: SAVEPOINT CREATE_CUST_PLANS_PVT;
256:
257: -- Standard call to check for call compatibility.
258: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

253: BEGIN
254: -- Standard Start of API savepoint
255: SAVEPOINT CREATE_CUST_PLANS_PVT;
256:
257: -- Standard call to check for call compatibility.
258: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
259: p_api_version_number,
260: l_api_name,
261: G_PKG_NAME)

Line 400: -- Standard check for p_commit

396: p_ATTRIBUTE15 => p_CSC_CUST_PLANS_rec.ATTRIBUTE15 ,
397: p_ATTRIBUTE_CATEGORY => p_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY,
398: x_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID );
399:
400: -- Standard check for p_commit
401: IF FND_API.to_Boolean( p_commit )
402: THEN
403: COMMIT WORK;
404: END IF;

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

402: THEN
403: COMMIT WORK;
404: END IF;
405:
406: -- Standard call to get message count and if count is 1, get message info.
407: FND_MSG_PUB.Count_And_Get
408: ( p_count => x_msg_count,
409: p_data => x_msg_data );
410:

Line 594: -- Standard Start of API savepoint

590: --l_tar_CSC_CUST_PLANS_rec CSC_cust_plans_PVT.CSC_CUST_PLANS_Rec_Type := P_CSC_CUST_PLANS_Rec;
591: l_upd_CSC_CUST_PLANS_rec CSC_cust_plans_PVT.CSC_CUST_PLANS_Rec_Type := P_CSC_CUST_PLANS_REC;
592: l_rowid ROWID;
593: BEGIN
594: -- Standard Start of API savepoint
595: SAVEPOINT UPDATE_CUST_PLANS_PVT;
596:
597: -- Standard call to check for call compatibility.
598: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

593: BEGIN
594: -- Standard Start of API savepoint
595: SAVEPOINT UPDATE_CUST_PLANS_PVT;
596:
597: -- Standard call to check for call compatibility.
598: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
599: p_api_version_number,
600: l_api_name,
601: G_PKG_NAME)

Line 815: -- Standard check for p_commit

811: p_ATTRIBUTE_CATEGORY => p_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY,
812: x_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID );
813:
814: --denzb***************************************************/
815: -- Standard check for p_commit
816: IF FND_API.to_Boolean( p_commit )
817: THEN
818: COMMIT WORK;
819: END IF;

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

817: THEN
818: COMMIT WORK;
819: END IF;
820:
821: -- Standard call to get message count and if count is 1, get message info.
822: FND_MSG_PUB.Count_And_Get
823: ( p_count => x_msg_count,
824: p_data => x_msg_data );
825:

Line 879: -- Standard Start of API savepoint

875: l_csc_cust_plans_rec CSC_CUST_PLANS_REC_TYPE;
876: l_api_name CONSTANT VARCHAR2(30) := 'Enable_Plan';
877: l_api_version_number CONSTANT NUMBER := 1.0;
878: BEGIN
879: -- Standard Start of API savepoint
880: SAVEPOINT ENABLE_PLAN_PVT;
881:
882: -- Standard call to check for call compatibility.
883: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

878: BEGIN
879: -- Standard Start of API savepoint
880: SAVEPOINT ENABLE_PLAN_PVT;
881:
882: -- Standard call to check for call compatibility.
883: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
884: p_api_version_number,
885: l_api_name,
886: G_PKG_NAME)

Line 947: -- Standard check for p_commit

943: X_OBJ_VER_NUM_TBL(i) := p_party_id_tbl(i).object_version_number + 1;
944: end loop;
945: ****************/
946:
947: -- Standard check for p_commit
948: IF FND_API.to_Boolean( p_commit )
949: THEN
950: COMMIT WORK;
951: END IF;

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

949: THEN
950: COMMIT WORK;
951: END IF;
952:
953: -- Standard call to get message count and if count is 1, get message info.
954: FND_MSG_PUB.Count_And_Get
955: ( p_count => x_msg_count,
956: p_data => x_msg_data );
957:

Line 977: -- Standard Start of API savepoint

973: l_csc_cust_plans_rec CSC_CUST_PLANS_REC_TYPE;
974: l_api_name CONSTANT VARCHAR2(30) := 'Disable_Plan';
975: l_api_version_number CONSTANT NUMBER := 1.0;
976: BEGIN
977: -- Standard Start of API savepoint
978: SAVEPOINT DISABLE_PLAN_PVT;
979:
980: -- Standard call to check for call compatibility.
981: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

976: BEGIN
977: -- Standard Start of API savepoint
978: SAVEPOINT DISABLE_PLAN_PVT;
979:
980: -- Standard call to check for call compatibility.
981: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
982: p_api_version_number,
983: l_api_name,
984: G_PKG_NAME)

Line 1044: -- Standard check for p_commit

1040:
1041: end loop;
1042: ***********/
1043:
1044: -- Standard check for p_commit
1045: IF FND_API.to_Boolean( p_commit )
1046: THEN
1047: COMMIT WORK;
1048: END IF;

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

1046: THEN
1047: COMMIT WORK;
1048: END IF;
1049:
1050: -- Standard call to get message count and if count is 1, get message info.
1051: FND_MSG_PUB.Count_And_Get
1052: ( p_count => x_msg_count,
1053: p_data => x_msg_data );
1054:

Line 1090: -- Standard Start of API savepoint

1086: l_cust_plan_id NUMBER;
1087: l_object_version_number NUMBER;
1088: lx_object_version_number NUMBER;
1089: BEGIN
1090: -- Standard Start of API savepoint
1091: SAVEPOINT UPDATE_FOR_CUSTMIZED_PLANS_PVT;
1092:
1093: -- Standard call to check for call compatibility.
1094: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1089: BEGIN
1090: -- Standard Start of API savepoint
1091: SAVEPOINT UPDATE_FOR_CUSTMIZED_PLANS_PVT;
1092:
1093: -- Standard call to check for call compatibility.
1094: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1095: p_api_version_number,
1096: l_api_name,
1097: G_PKG_NAME)

Line 1173: -- Standard check for p_commit

1169: p_ATTRIBUTE15 => c1rec.ATTRIBUTE15 ,
1170: p_ATTRIBUTE_CATEGORY => c1rec.ATTRIBUTE_CATEGORY,
1171: x_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID );
1172:
1173: -- Standard check for p_commit
1174: IF FND_API.to_Boolean( p_commit )
1175: THEN
1176: COMMIT WORK;
1177: END IF;

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

1175: THEN
1176: COMMIT WORK;
1177: END IF;
1178:
1179: -- Standard call to get message count and if count is 1, get message info.
1180: FND_MSG_PUB.Count_And_Get
1181: ( p_count => x_msg_count,
1182: p_data => x_msg_data );
1183:

Line 1220: -- Standard Start of API savepoint

1216:
1217: l_api_name CONSTANT VARCHAR2(30) := 'Delete_cust_plans';
1218: l_api_version_number CONSTANT NUMBER := 1.0;
1219: BEGIN
1220: -- Standard Start of API savepoint
1221: SAVEPOINT DELETE_CUST_PLANS_PVT;
1222:
1223: -- Standard call to check for call compatibility.
1224: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1219: BEGIN
1220: -- Standard Start of API savepoint
1221: SAVEPOINT DELETE_CUST_PLANS_PVT;
1222:
1223: -- Standard call to check for call compatibility.
1224: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1225: p_api_version_number,
1226: l_api_name,
1227: G_PKG_NAME)

Line 1290: -- Standard check for p_commit

1286: p_ATTRIBUTE15 => c1rec.ATTRIBUTE15 ,
1287: p_ATTRIBUTE_CATEGORY => c1rec.ATTRIBUTE_CATEGORY,
1288: x_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID );
1289:
1290: -- Standard check for p_commit
1291: IF FND_API.to_Boolean( p_commit )
1292: THEN
1293: COMMIT WORK;
1294: END IF;

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

1292: THEN
1293: COMMIT WORK;
1294: END IF;
1295:
1296: -- Standard call to get message count and if count is 1, get message info.
1297: FND_MSG_PUB.Count_And_Get
1298: ( p_count => x_msg_count,
1299: p_data => x_msg_data );
1300:

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

1453: end if;
1454: close check_dup_id;
1455: END IF;
1456:
1457: -- Standard call to get message count and if count is 1, get message info.
1458: FND_MSG_PUB.Count_And_Get
1459: ( p_count => x_msg_count,
1460: p_data => x_msg_data );
1461:

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

1511: end if;
1512: close c1;
1513: end if;
1514:
1515: -- Standard call to get message count and if count is 1, get message info.
1516: FND_MSG_PUB.Count_And_Get
1517: ( p_count => x_msg_count,
1518: p_data => x_msg_data );
1519:

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

1568: end if;
1569: close c1;
1570: end if;
1571:
1572: -- Standard call to get message count and if count is 1, get message info.
1573: FND_MSG_PUB.Count_And_Get
1574: ( p_count => x_msg_count,
1575: p_data => x_msg_data );
1576:

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

1638: end if;
1639: close c1;
1640: end if;
1641:
1642: -- Standard call to get message count and if count is 1, get message info.
1643: FND_MSG_PUB.Count_And_Get
1644: ( p_count => x_msg_count,
1645: p_data => x_msg_data );
1646:

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

1686: x_return_status := FND_API.G_RET_STS_ERROR;
1687: end if;
1688: end if;
1689:
1690: -- Standard call to get message count and if count is 1, get message info.
1691: FND_MSG_PUB.Count_And_Get
1692: ( p_count => x_msg_count,
1693: p_data => x_msg_data );
1694:

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

1747: x_return_status := FND_API.G_RET_STS_ERROR;
1748: end if;
1749: end if;
1750:
1751: -- Standard call to get message count and if count is 1, get message info.
1752: FND_MSG_PUB.Count_And_Get
1753: ( p_count => x_msg_count,
1754: p_data => x_msg_data );
1755: