DBA Data[Home] [Help]

APPS.AMS_ACTCATEGORY_PVT dependencies on AMS_ACTCATEGORY_PVT

Line 1: PACKAGE BODY AMS_ActCategory_PVT as

1: PACKAGE BODY AMS_ActCategory_PVT as
2: /*$Header: amsvactb.pls 120.1 2005/06/15 01:31:45 appldev $*/
3:
4: -- NAME
5: -- AMS_ActCategory_PVT

Line 5: -- AMS_ActCategory_PVT

1: PACKAGE BODY AMS_ActCategory_PVT as
2: /*$Header: amsvactb.pls 120.1 2005/06/15 01:31:45 appldev $*/
3:
4: -- NAME
5: -- AMS_ActCategory_PVT
6: --
7: -- HISTORY
8: -- 11/8/99 sugupta CREATED
9: --

Line 10: G_PACKAGE_NAME CONSTANT VARCHAR2(30):='AMS_ActCategory_PVT';

6: --
7: -- HISTORY
8: -- 11/8/99 sugupta CREATED
9: --
10: G_PACKAGE_NAME CONSTANT VARCHAR2(30):='AMS_ActCategory_PVT';
11: G_FILE_NAME CONSTANT VARCHAR2(12):='amsvactb.pls';
12:
13: -- Debug mode
14: g_debug boolean := FALSE;

Line 1337: IF AMS_ActCategory_PVT.g_debug = TRUE THEN

1333:
1334: BEGIN
1335:
1336: -- turned on debug mode
1337: IF AMS_ActCategory_PVT.g_debug = TRUE THEN
1338:
1339: l_category_rec.CATEGORY_ID := 1234;
1340: l_category_rec.ARC_CATEGORY_CREATED_FOR := 'hung';
1341: l_category_rec.CATEGORY_NAME := 'sugupta_category';

Line 1344: AMS_ActCategory_PVT.Create_Category (

1340: l_category_rec.ARC_CATEGORY_CREATED_FOR := 'hung';
1341: l_category_rec.CATEGORY_NAME := 'sugupta_category';
1342:
1343:
1344: AMS_ActCategory_PVT.Create_Category (
1345: p_api_version => 1.0 -- p_api_version
1346: ,p_init_msg_list => FND_API.G_FALSE
1347: ,p_commit => FND_API.G_FALSE
1348: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1396: IF AMS_ActCategory_PVT.g_debug = TRUE

1392:
1393: BEGIN
1394:
1395: -- turned on debug mode
1396: IF AMS_ActCategory_PVT.g_debug = TRUE
1397: THEN
1398:
1399: l_category_rec.category_id := 1234;
1400:

Line 1402: AMS_ActCategory_PVT.Delete_Category (

1398:
1399: l_category_rec.category_id := 1234;
1400:
1401:
1402: AMS_ActCategory_PVT.Delete_Category (
1403: p_api_version => 1.0 -- p_api_version
1404: ,p_init_msg_list => FND_API.G_FALSE
1405: ,p_commit => FND_API.G_FALSE
1406: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1452: IF AMS_ActCategory_PVT.g_debug = TRUE

1448: WHERE CATEGORY_ID = my_category_id;
1449: BEGIN
1450:
1451: -- turned on debug mode
1452: IF AMS_ActCategory_PVT.g_debug = TRUE
1453: THEN
1454:
1455: l_category_id := 1234;
1456: OPEN C(l_category_id);

Line 1461: AMS_ActCategory_PVT.Update_Category (

1457: FETCH C INTO l_category_rec;
1458:
1459: l_category_rec.NOTES := 'NOTES UPDATED1';
1460:
1461: AMS_ActCategory_PVT.Update_Category (
1462: p_api_version => 1.0 -- p_api_version
1463: ,p_init_msg_list => FND_API.G_FALSE
1464: ,p_commit => FND_API.G_FALSE
1465: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1512: IF AMS_ActCategory_PVT.g_debug = TRUE

1508: select * from AMS_CATEGORIES_B WHERE CATEGORY_ID = my_category_id;
1509: BEGIN
1510:
1511: -- turned on debug mode
1512: IF AMS_ActCategory_PVT.g_debug = TRUE
1513: THEN
1514:
1515: l_category_rec.category_id := 1234;
1516: l_category_rec.NOTES := 'server side test';

Line 1518: AMS_ActCategory_PVT.Lock_Category (

1514:
1515: l_category_rec.category_id := 1234;
1516: l_category_rec.NOTES := 'server side test';
1517:
1518: AMS_ActCategory_PVT.Lock_Category (
1519: p_api_version => 1.0 -- p_api_version
1520: ,p_init_msg_list => FND_API.G_FALSE
1521: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1522: ,p_category_rec => l_category_rec

Line 1578: IF AMS_ActCategory_PVT.G_DEBUG = TRUE THEN

1574:
1575: BEGIN
1576:
1577: -- turned on debug mode
1578: IF AMS_ActCategory_PVT.G_DEBUG = TRUE THEN
1579:
1580: -- Insert case 1
1581:
1582: l_act_category_rec.ACTIVITY_CATEGORY_ID := 1234;

Line 1588: AMS_ActCategory_PVT.Create_Act_Category (

1584: l_act_category_rec.ARC_ACT_CATEGORY_USED_BY := 1000;
1585: l_act_category_rec.CATEGORY_ID := 1234;
1586:
1587:
1588: AMS_ActCategory_PVT.Create_Act_Category (
1589: p_api_version => 1.0 -- p_api_version
1590: ,p_init_msg_list => FND_API.G_FALSE
1591: ,p_commit => FND_API.G_FALSE
1592: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1639: IF AMS_ActCategory_PVT.G_DEBUG = TRUE THEN

1635:
1636: BEGIN
1637:
1638: -- turned on debug mode
1639: IF AMS_ActCategory_PVT.G_DEBUG = TRUE THEN
1640:
1641:
1642: -- Delete test case 1
1643: l_act_category_rec.activity_category_id := 1234;

Line 1644: AMS_ActCategory_PVT.Delete_Act_Category (

1640:
1641:
1642: -- Delete test case 1
1643: l_act_category_rec.activity_category_id := 1234;
1644: AMS_ActCategory_PVT.Delete_Act_Category (
1645: p_api_version => 1.0 -- p_api_version
1646: ,p_init_msg_list => FND_API.G_FALSE
1647: ,p_commit => FND_API.G_FALSE
1648: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1693: IF AMS_ActCategory_PVT.G_DEBUG = TRUE THEN

1689:
1690: BEGIN
1691:
1692: -- turned on debug mode
1693: IF AMS_ActCategory_PVT.G_DEBUG = TRUE THEN
1694:
1695:
1696: -- Update test case 1
1697:

Line 1704: AMS_ActCategory_PVT.Update_Act_Category (

1700: FETCH C INTO l_act_category_rec;
1701:
1702: l_act_category_rec.ATTRIBUTE1 := 'ATTRIBUTE1 UPDATED1';
1703:
1704: AMS_ActCategory_PVT.Update_Act_Category (
1705: p_api_version => 1.0 -- p_api_version
1706: ,p_init_msg_list => FND_API.G_FALSE
1707: ,p_commit => FND_API.G_FALSE
1708: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1749: IF AMS_ActCategory_PVT.G_DEBUG = TRUE THEN

1745:
1746: BEGIN
1747:
1748: -- turned on debug mode
1749: IF AMS_ActCategory_PVT.G_DEBUG = TRUE THEN
1750:
1751:
1752: -- Lock test case 1
1753:

Line 1756: AMS_ActCategory_PVT.Lock_Act_Category (

1752: -- Lock test case 1
1753:
1754: l_act_category_rec.activity_category_id := 1234;
1755:
1756: AMS_ActCategory_PVT.Lock_Act_Category (
1757: p_api_version => 1.0 -- p_api_version
1758: ,p_init_msg_list => FND_API.G_FALSE
1759: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1760: ,p_category_rec => l_act_category_rec

Line 1780: END AMS_ActCategory_PVT;

1776: END IF;
1777:
1778: END Unit_Test_Act_Lock;
1779: */--0614
1780: END AMS_ActCategory_PVT;