DBA Data[Home] [Help]

APPS.JTF_PERZ_DDF_PVT dependencies on STANDARD

Line 557: -- Following variables are needed to adhere to standards

553: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
554: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
555: )IS
556: -- ******* Create_data_default Local Variables ********
557: -- Following variables are needed to adhere to standards
558: l_api_version_number NUMBER := p_api_version_number;
559: l_api_name CONSTANT VARCHAR2(30) := 'Create_data_default';
560: -- Following variables are needed for implementation
561: l_profile_id NUMBER := NULL;

Line 575: -- ******* create_data_default Standard Begins ********

571: -- check_duplicate_profiles()
572: -- If not, raise an error and exit
573: --2. call the insert table handler()
574:
575: -- ******* create_data_default Standard Begins ********
576:
577: -- Standard Start of API savepoint
578: SAVEPOINT CREATE_PERZ_DDF_PVT;
579:

Line 577: -- Standard Start of API savepoint

573: --2. call the insert table handler()
574:
575: -- ******* create_data_default Standard Begins ********
576:
577: -- Standard Start of API savepoint
578: SAVEPOINT CREATE_PERZ_DDF_PVT;
579:
580: -- Standard call to check for call compatibility.
581: -- IF NOT FND_API.Compatible_API_Call (

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

576:
577: -- Standard Start of API savepoint
578: SAVEPOINT CREATE_PERZ_DDF_PVT;
579:
580: -- Standard call to check for call compatibility.
581: -- IF NOT FND_API.Compatible_API_Call (
582: -- l_api_version_number,
583: -- p_api_version_number,
584: -- l_api_name,

Line 644: -- ******** Standard Ends ***********

640: else
641: x_perz_ddf_id := l_perz_ddf_id;
642: end if;
643:
644: -- ******** Standard Ends ***********
645: --
646: -- End of API body.
647: --
648: -- 7. Commit the whole thing

Line 650: -- Standard check of p_commit.

646: -- End of API body.
647: --
648: -- 7. Commit the whole thing
649:
650: -- Standard check of p_commit.
651: IF FND_API.To_Boolean ( p_commit )
652: THEN
653: COMMIT WORK;
654: END IF;

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

653: COMMIT WORK;
654: END IF;
655:
656: -- Debug Message
657: -- Standard call to get message count and if count is 1, get message info.
658: FND_MSG_PUB.Count_And_Get
659: (
660: p_count => x_msg_count,
661: p_data => x_msg_data

Line 785: -- Following variables are needed to adhere to standards

781: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
782: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
783: )IS
784: -- ******* Update_data_default Local Variables ********
785: -- Following variables are needed to adhere to standards
786: l_api_version_number NUMBER := p_api_version_number;
787: l_api_name CONSTANT VARCHAR2(30) := 'Update_data_default';
788: -- Following variables are needed for implementation
789: l_profile_id NUMBER := NULL;

Line 804: -- ******* update_data_default Standard Begins ********

800: -- If not, raise an error and exit
801: --2. Check if DDF exists
802: --3. call the update table handler()
803:
804: -- ******* update_data_default Standard Begins ********
805:
806: -- Standard Start of API savepoint
807: SAVEPOINT UPDATE_PERZ_DDF_PVT;
808:

Line 806: -- Standard Start of API savepoint

802: --3. call the update table handler()
803:
804: -- ******* update_data_default Standard Begins ********
805:
806: -- Standard Start of API savepoint
807: SAVEPOINT UPDATE_PERZ_DDF_PVT;
808:
809: -- Standard call to check for call compatibility.
810: -- IF NOT FND_API.Compatible_API_Call (

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

805:
806: -- Standard Start of API savepoint
807: SAVEPOINT UPDATE_PERZ_DDF_PVT;
808:
809: -- Standard call to check for call compatibility.
810: -- IF NOT FND_API.Compatible_API_Call (
811: -- l_api_version_number,
812: -- p_api_version_number,
813: -- l_api_name,

Line 894: -- ******** Standard Ends ***********

890: end if;
891:
892: end if;
893:
894: -- ******** Standard Ends ***********
895: --
896: -- End of API body.
897: --
898: -- 7. Commit the whole thing

Line 900: -- Standard check of p_commit.

896: -- End of API body.
897: --
898: -- 7. Commit the whole thing
899:
900: -- Standard check of p_commit.
901: IF FND_API.To_Boolean ( p_commit )
902: THEN
903: COMMIT WORK;
904: END IF;

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

903: COMMIT WORK;
904: END IF;
905:
906: -- Debug Message
907: -- Standard call to get message count and if count is 1, get message info.
908: FND_MSG_PUB.Count_And_Get
909: (
910: p_count => x_msg_count,
911: p_data => x_msg_data

Line 1044: -- Following variables are needed to adhere to standards

1040: )IS
1041:
1042:
1043: -- ******* save_data_default Local Variables ********
1044: -- Following variables are needed to adhere to standards
1045: l_api_version_number NUMBER := p_api_version_number;
1046: l_api_name CONSTANT VARCHAR2(30) := 'save_data_default';
1047: -- Following variables are needed for implementation
1048: l_profile_id NUMBER := NULL;

Line 1069: -- ******* save_data_default Standard Begins ********

1065: --2. Check if DDF exists
1066: -- If not, call create_data_default()
1067: -- If yes, update_data_default()
1068:
1069: -- ******* save_data_default Standard Begins ********
1070:
1071: -- Standard Start of API savepoint
1072: SAVEPOINT SAVE_PERZ_DDF_PVT;
1073:

Line 1071: -- Standard Start of API savepoint

1067: -- If yes, update_data_default()
1068:
1069: -- ******* save_data_default Standard Begins ********
1070:
1071: -- Standard Start of API savepoint
1072: SAVEPOINT SAVE_PERZ_DDF_PVT;
1073:
1074: -- Standard call to check for call compatibility.
1075: -- IF NOT FND_API.Compatible_API_Call (

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

1070:
1071: -- Standard Start of API savepoint
1072: SAVEPOINT SAVE_PERZ_DDF_PVT;
1073:
1074: -- Standard call to check for call compatibility.
1075: -- IF NOT FND_API.Compatible_API_Call (
1076: -- l_api_version_number,
1077: -- p_api_version_number,
1078: -- l_api_name,

Line 1217: -- ******** Standard Ends ***********

1213: x_msg_count ,
1214: x_msg_data
1215: );
1216: end if ;
1217: -- ******** Standard Ends ***********
1218: --
1219: -- End of API body.
1220: --
1221: -- 7. Commit the whole thing

Line 1223: -- Standard check of p_commit.

1219: -- End of API body.
1220: --
1221: -- 7. Commit the whole thing
1222:
1223: -- Standard check of p_commit.
1224: IF FND_API.To_Boolean ( p_commit )
1225: THEN
1226: COMMIT WORK;
1227: END IF;

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

1226: COMMIT WORK;
1227: END IF;
1228:
1229: -- Debug Message
1230: -- Standard call to get message count and if count is 1, get message info.
1231: FND_MSG_PUB.Count_And_Get
1232: (
1233: p_count => x_msg_count,
1234: p_data => x_msg_data

Line 1357: -- Following variables are needed to adhere to standards

1353: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1354: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1355: )IS
1356: -- ******* get_data_default Local Variables ********
1357: -- Following variables are needed to adhere to standards
1358: l_api_version_number NUMBER := p_api_version_number;
1359: l_api_name CONSTANT VARCHAR2(30) := 'get_data_default';
1360: -- Following variables are needed for implementation
1361: l_profile_id NUMBER := NULL;

Line 1377: -- ******* get_data_default Standard Begins ********

1373: -- check_duplicate_profiles()
1374: -- If not, raise an error and exit
1375: --2. get the ddf
1376:
1377: -- ******* get_data_default Standard Begins ********
1378:
1379: -- Standard call to check for call compatibility.
1380: -- IF NOT FND_API.Compatible_API_Call (
1381: -- l_api_version_number,

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

1375: --2. get the ddf
1376:
1377: -- ******* get_data_default Standard Begins ********
1378:
1379: -- Standard call to check for call compatibility.
1380: -- IF NOT FND_API.Compatible_API_Call (
1381: -- l_api_version_number,
1382: -- p_api_version_number,
1383: -- l_api_name,

Line 1512: -- Following variables are needed to adhere to standards

1508: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1509: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1510: )IS
1511: -- ******* Delete_data_default Local Variables ********
1512: -- Following variables are needed to adhere to standards
1513: l_api_version_number NUMBER := p_api_version_number;
1514: l_api_name CONSTANT VARCHAR2(30) := 'Delete_data_default';
1515: -- Following variables are needed for implementation
1516:

Line 1519: -- ******* delete_data_default Standard Begins ********

1515: -- Following variables are needed for implementation
1516:
1517: BEGIN
1518:
1519: -- ******* delete_data_default Standard Begins ********
1520:
1521: -- Standard Start of API savepoint
1522: SAVEPOINT DELETE_PERZ_DDF_PVT;
1523:

Line 1521: -- Standard Start of API savepoint

1517: BEGIN
1518:
1519: -- ******* delete_data_default Standard Begins ********
1520:
1521: -- Standard Start of API savepoint
1522: SAVEPOINT DELETE_PERZ_DDF_PVT;
1523:
1524: -- Standard call to check for call compatibility.
1525: -- IF NOT FND_API.Compatible_API_Call (

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

1520:
1521: -- Standard Start of API savepoint
1522: SAVEPOINT DELETE_PERZ_DDF_PVT;
1523:
1524: -- Standard call to check for call compatibility.
1525: -- IF NOT FND_API.Compatible_API_Call (
1526: -- l_api_version_number,
1527: -- p_api_version_number,
1528: -- l_api_name,

Line 1552: -- ******** Standard Ends ***********

1548: else
1549: RAISE FND_API.G_EXC_ERROR;
1550:
1551: end if;
1552: -- ******** Standard Ends ***********
1553: --
1554: -- End of API body.
1555: --
1556: -- 7. Commit the whole thing

Line 1558: -- Standard check of p_commit.

1554: -- End of API body.
1555: --
1556: -- 7. Commit the whole thing
1557:
1558: -- Standard check of p_commit.
1559: IF FND_API.To_Boolean ( p_commit )
1560: THEN
1561: COMMIT WORK;
1562: END IF;

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

1561: COMMIT WORK;
1562: END IF;
1563:
1564: -- Debug Message
1565: -- Standard call to get message count and if count is 1, get message info.
1566: FND_MSG_PUB.Count_And_Get
1567: (
1568: p_count => x_msg_count,
1569: p_data => x_msg_data