DBA Data[Home] [Help]

APPS.AMS_CATEGORY_PVT dependencies on AMS_CATEGORY_PVT

Line 1: PACKAGE BODY AMS_Category_PVT as

1: PACKAGE BODY AMS_Category_PVT as
2: /* $Header: amsvctyb.pls 120.2 2005/11/23 05:23:52 vmodur noship $ */
3: --
4: -- NAME
5: -- AMS_Category_PVT

Line 5: -- AMS_Category_PVT

1: PACKAGE BODY AMS_Category_PVT as
2: /* $Header: amsvctyb.pls 120.2 2005/11/23 05:23:52 vmodur noship $ */
3: --
4: -- NAME
5: -- AMS_Category_PVT
6: --
7: -- HISTORY
8: -- 01/04/2000 sugupta CREATED
9: -- 06/01/2000 khung add two new columns accrued_liability_account

Line 28: G_PACKAGE_NAME CONSTANT VARCHAR2(30):='AMS_Category_PVT';

24: -- 09/30/2005 vmodur Added Ledger_Id
25: -- 11/23/2005 vmodur Missed Bug 4064984 in R12 shipped using Bug 4755142
26:
27: --
28: G_PACKAGE_NAME CONSTANT VARCHAR2(30):='AMS_Category_PVT';
29: G_FILE_NAME CONSTANT VARCHAR2(12):='amsvctyb.pls';
30:
31: -- Debug mode
32: --g_debug boolean := FALSE;

Line 2062: IF AMS_Category_PVT.g_debug = TRUE THEN

2058:
2059: BEGIN
2060:
2061: -- turned on debug mode
2062: IF AMS_Category_PVT.g_debug = TRUE THEN
2063:
2064: l_category_rec.CATEGORY_ID := 1234;
2065: l_category_rec.ARC_CATEGORY_CREATED_FOR := 'hung';
2066: l_category_rec.CATEGORY_NAME := 'sugupta_category';

Line 2069: AMS_Category_PVT.Create_Category (

2065: l_category_rec.ARC_CATEGORY_CREATED_FOR := 'hung';
2066: l_category_rec.CATEGORY_NAME := 'sugupta_category';
2067:
2068:
2069: AMS_Category_PVT.Create_Category (
2070: p_api_version => 1.0 -- p_api_version
2071: ,p_init_msg_list => FND_API.G_FALSE
2072: ,p_commit => FND_API.G_FALSE
2073: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2121: IF AMS_Category_PVT.g_debug = TRUE

2117:
2118: BEGIN
2119:
2120: -- turned on debug mode
2121: IF AMS_Category_PVT.g_debug = TRUE
2122: THEN
2123:
2124: l_category_rec.category_id := 1234;
2125:

Line 2127: AMS_Category_PVT.Delete_Category (

2123:
2124: l_category_rec.category_id := 1234;
2125:
2126:
2127: AMS_Category_PVT.Delete_Category (
2128: p_api_version => 1.0 -- p_api_version
2129: ,p_init_msg_list => FND_API.G_FALSE
2130: ,p_commit => FND_API.G_FALSE
2131: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2177: IF AMS_Category_PVT.g_debug = TRUE

2173: WHERE CATEGORY_ID = my_category_id;
2174: BEGIN
2175:
2176: -- turned on debug mode
2177: IF AMS_Category_PVT.g_debug = TRUE
2178: THEN
2179:
2180: l_category_id := 1234;
2181: OPEN C(l_category_id);

Line 2187: AMS_Category_PVT.Update_Category (

2183:
2184: l_category_rec.NOTES := 'NOTES UPDATED1';
2185:
2186:
2187: AMS_Category_PVT.Update_Category (
2188: p_api_version => 1.0 -- p_api_version
2189: ,p_init_msg_list => FND_API.G_FALSE
2190: ,p_commit => FND_API.G_FALSE
2191: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2238: IF AMS_Category_PVT.g_debug = TRUE

2234: select * from AMS_CATEGORIES_B WHERE CATEGORY_ID = my_category_id;
2235: BEGIN
2236:
2237: -- turned on debug mode
2238: IF AMS_Category_PVT.g_debug = TRUE
2239: THEN
2240:
2241: l_category_rec.category_id := 1234;
2242: l_category_rec.NOTES := 'server side test';

Line 2245: AMS_Category_PVT.Lock_Category (

2241: l_category_rec.category_id := 1234;
2242: l_category_rec.NOTES := 'server side test';
2243:
2244:
2245: AMS_Category_PVT.Lock_Category (
2246: p_api_version => 1.0 -- p_api_version
2247: ,p_init_msg_list => FND_API.G_FALSE
2248: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2249: ,p_category_rec => l_category_rec

Line 2290: IF AMS_Category_PVT.G_DEBUG = TRUE THEN

2286:
2287: BEGIN
2288:
2289: -- turned on debug mode
2290: IF AMS_Category_PVT.G_DEBUG = TRUE THEN
2291:
2292: --********************************************************
2293: -- Insert case 1
2294:

Line 2301: AMS_Category_PVT.Create_Act_Category (

2297: l_act_category_rec.ARC_ACT_CATEGORY_USED_BY := 1000;
2298: l_act_category_rec.CATEGORY_ID := 1234;
2299:
2300:
2301: AMS_Category_PVT.Create_Act_Category (
2302: p_api_version => 1.0 -- p_api_version
2303: ,p_init_msg_list => FND_API.G_FALSE
2304: ,p_commit => FND_API.G_FALSE
2305: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2352: IF AMS_Category_PVT.G_DEBUG = TRUE THEN

2348:
2349: BEGIN
2350:
2351: -- turned on debug mode
2352: IF AMS_Category_PVT.G_DEBUG = TRUE THEN
2353:
2354:
2355: -- Delete test case 1
2356: l_act_category_rec.activity_category_id := 1234;

Line 2357: AMS_Category_PVT.Delete_Act_Category (

2353:
2354:
2355: -- Delete test case 1
2356: l_act_category_rec.activity_category_id := 1234;
2357: AMS_Category_PVT.Delete_Act_Category (
2358: p_api_version => 1.0 -- p_api_version
2359: ,p_init_msg_list => FND_API.G_FALSE
2360: ,p_commit => FND_API.G_FALSE
2361: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2406: IF AMS_Category_PVT.G_DEBUG = TRUE THEN

2402:
2403: BEGIN
2404:
2405: -- turned on debug mode
2406: IF AMS_Category_PVT.G_DEBUG = TRUE THEN
2407:
2408:
2409: -- Update test case 1
2410:

Line 2418: AMS_Category_PVT.Update_Act_Category (

2414:
2415: l_act_category_rec.ATTRIBUTE1 := 'ATTRIBUTE1 UPDATED1';
2416:
2417:
2418: AMS_Category_PVT.Update_Act_Category (
2419: p_api_version => 1.0 -- p_api_version
2420: ,p_init_msg_list => FND_API.G_FALSE
2421: ,p_commit => FND_API.G_FALSE
2422: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2463: IF AMS_Category_PVT.G_DEBUG = TRUE THEN

2459:
2460: BEGIN
2461:
2462: -- turned on debug mode
2463: IF AMS_Category_PVT.G_DEBUG = TRUE THEN
2464:
2465:
2466: --********************************************************
2467: -- Lock test case 1

Line 2472: AMS_Category_PVT.Lock_Act_Category (

2468:
2469: l_act_category_rec.activity_category_id := 1234;
2470:
2471:
2472: AMS_Category_PVT.Lock_Act_Category (
2473: p_api_version => 1.0 -- p_api_version
2474: ,p_init_msg_list => FND_API.G_FALSE
2475: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2476: ,p_category_rec => l_act_category_rec

Line 2496: END AMS_Category_PVT;

2492: END IF;
2493:
2494: END Unit_Test_Act_Lock;
2495: */
2496: END AMS_Category_PVT;