eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_APPROVAL_DETAILS_PVT dependencies on AMS_APPROVAL_DETAILS

Line 1: PACKAGE BODY AMS_APPROVAL_DETAILS_PVT AS

1: PACKAGE BODY AMS_APPROVAL_DETAILS_PVT AS
2: /* $Header: amsvapdb.pls 120.2 2005/12/28 00:14:47 vmodur noship $ */
3:
4: -----------------------------------------------------------
5: -- PACKAGE

Line 6: -- AMS_APPROVAL_DETAILS_PVT

2: /* $Header: amsvapdb.pls 120.2 2005/12/28 00:14:47 vmodur noship $ */
3:
4: -----------------------------------------------------------
5: -- PACKAGE
6: -- AMS_APPROVAL_DETAILS_PVT
7: --
8: -- PURPOSE
9: -- This package is a Private API for managing Approval details
10: -- in AMS. It contains specification for pl/sql records and tables

Line 12: -- AMS_APPROVAL_DETAILS_VL:

8: -- PURPOSE
9: -- This package is a Private API for managing Approval details
10: -- in AMS. It contains specification for pl/sql records and tables
11: --
12: -- AMS_APPROVAL_DETAILS_VL:
13: -- Create_Approval_Details (see below for specification)
14: -- Update_Approval_Details (see below for specification)
15: -- Delete_Approval_Details (see below for specification)
16: -- Lock_Approval_Details (see below for specification)

Line 62: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_Approval_Details_PVT';

58: -- 14-SEP-2005 VMODUR R12 Changes - No LITE/PHAT distinction for CSCH
59: -----------------------------------------------------------
60:
61: -- Global CONSTANTS
62: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_Approval_Details_PVT';
63:
64: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
65: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
66: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

Line 131: FROM ams_approval_details_v

127: l_rule_name VARCHAR2(240);
128: BEGIN
129: SELECT name
130: INTO l_rule_name
131: FROM ams_approval_details_v
132: where approval_detail_id = p_approval_detail_id;
133: x_rule_name := l_rule_name;
134: END;
135:

Line 166: -- p_approval_detail_rec: the record representing AMS_APPROVAL_DETAILS_VL view..

162: -- PURPOSE
163: -- Create Approval Details entry.
164: --
165: -- PARAMETERS
166: -- p_approval_detail_rec: the record representing AMS_APPROVAL_DETAILS_VL view..
167: -- x_approval_detail_id: the approval_detail_id.
168: --
169: -- NOTES
170: -- 1. object_version_number will be set to 1.

Line 195: l_exist_rule_name AMS_APPROVAL_DETAILS_V.Name%TYPE;

191: L_API_VERSION CONSTANT NUMBER := 1.0;
192: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Approval_Details';
193: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || L_API_NAME;
194: l_Approval_Details_rec Approval_Details_Rec_Type := p_approval_details_rec;
195: l_exist_rule_name AMS_APPROVAL_DETAILS_V.Name%TYPE;
196: l_dummy NUMBER;
197: l_return_status VARCHAR2(1);
198: l_row_id VARCHAR2(40);
199:

Line 201: SELECT ams_approval_details_s.NEXTVAL

197: l_return_status VARCHAR2(1);
198: l_row_id VARCHAR2(40);
199:
200: CURSOR c_seq IS
201: SELECT ams_approval_details_s.NEXTVAL
202: FROM dual;
203:
204: CURSOR c_id_exists (x_id IN NUMBER) IS
205: SELECT 1 FROM dual

Line 206: WHERE EXISTS (SELECT 1 FROM ams_approval_details

202: FROM dual;
203:
204: CURSOR c_id_exists (x_id IN NUMBER) IS
205: SELECT 1 FROM dual
206: WHERE EXISTS (SELECT 1 FROM ams_approval_details
207: WHERE approval_detail_id = x_id);
208: BEGIN
209: --------------------- initialize -----------------------
210: SAVEPOINT Create_Approval_Details;

Line 295: AMS_APPROVAL_DETAILS_PKG.INSERT_ROW (

291: END IF;
292: --
293: -- Insert into mutli-language supported table.
294: --
295: AMS_APPROVAL_DETAILS_PKG.INSERT_ROW (
296: X_ROWID => l_row_id,
297: X_APPROVAL_DETAIL_ID => l_Approval_Details_rec.APPROVAL_DETAIL_ID,
298: X_START_DATE_ACTIVE => l_Approval_Details_rec.START_DATE_ACTIVE,
299: X_END_DATE_ACTIVE => l_Approval_Details_rec.END_DATE_ACTIVE,

Line 381: -- p_approval_details_rec: the record representing AMS_APPROVAL_DETAILS_VL (without the ROW_ID column).

377: -- PURPOSE
378: -- Update an approval details entry.
379: --
380: -- PARAMETERS
381: -- p_approval_details_rec: the record representing AMS_APPROVAL_DETAILS_VL (without the ROW_ID column).
382: --
383: -- NOTES
384: -- 1. Raise exception if the object_version_number doesn't match.
385: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,

Line 407: l_exist_rule_name AMS_APPROVAL_DETAILS_V.Name%TYPE;

403: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Approval_Details';
404: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || L_API_NAME;
405:
406: l_Approval_Details_rec Approval_Details_Rec_Type := p_approval_details_rec;
407: l_exist_rule_name AMS_APPROVAL_DETAILS_V.Name%TYPE;
408: l_dummy NUMBER;
409: l_return_status VARCHAR2(1);
410:
411: CURSOR c_rec_exists (x_id IN NUMBER, ver IN NUMBER) IS

Line 412: SELECT 1 FROM ams_approval_details

408: l_dummy NUMBER;
409: l_return_status VARCHAR2(1);
410:
411: CURSOR c_rec_exists (x_id IN NUMBER, ver IN NUMBER) IS
412: SELECT 1 FROM ams_approval_details
413: WHERE approval_detail_id = x_id
414: AND object_version_number = ver;
415:
416: BEGIN

Line 514: AMS_APPROVAL_DETAILS_PKG.UPDATE_ROW(

510: else
511: CLOSE c_rec_exists;
512: end IF;
513:
514: AMS_APPROVAL_DETAILS_PKG.UPDATE_ROW(
515: X_APPROVAL_DETAIL_ID => l_Approval_Details_rec.approval_detail_id,
516: X_START_DATE_ACTIVE => l_approval_details_rec.START_DATE_ACTIVE,
517: X_END_DATE_ACTIVE => l_approval_details_rec.END_DATE_ACTIVE,
518: X_OBJECT_VERSION_NUMBER => l_approval_details_rec.OBJECT_VERSION_NUMBER+1,

Line 620: FROM ams_approval_details_vl

616: ) IS
617:
618: CURSOR c_approval_details IS
619: SELECT *
620: FROM ams_approval_details_vl
621: WHERE approval_detail_id = p_approval_detail_id;
622: --
623: -- This is the only exception for using %ROWTYPE.
624: -- We are selecting from the VL view, which may

Line 673: AMS_APPROVAL_DETAILS_PKG.DELETE_ROW (p_approval_detail_id);

669: END IF;
670: -- Delete TL data
671: IF l_approval_details_rec.seeded_flag='N'
672: THEN
673: AMS_APPROVAL_DETAILS_PKG.DELETE_ROW (p_approval_detail_id);
674: ELSE
675: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
676: FND_MESSAGE.set_name ('AMS', 'AMS_API_SEED_DATA');
677: FND_MSG_PUB.add;

Line 769: -- p_approval_details_rec: the record representing AMS_APPROVAL_DETAILS_VL (without ROW_ID).

765: -- PURPOSE
766: -- Validate a approval_details entry.
767: --
768: -- PARAMETERS
769: -- p_approval_details_rec: the record representing AMS_APPROVAL_DETAILS_VL (without ROW_ID).
770: --
771: -- NOTES
772: -- 1. p_approval_details_rec should be the complete approval_details record.
773: -- There should not be any FND_API.g_miss_char/num/date in it.

Line 1266: FROM ams_approval_details_vl

1262: x_complete_rec OUT NOCOPY approval_details_Rec_Type
1263: ) IS
1264: CURSOR c_approval_details IS
1265: SELECT *
1266: FROM ams_approval_details_vl
1267: WHERE approval_detail_id = p_approval_details_rec.approval_detail_id;
1268: --
1269: -- This is the only exception for using %ROWTYPE.
1270: -- We are selecting from the VL view, which may

Line 1406: from AMS_APPROVAL_DETAILS_VL

1402: if p_approval_details_rec.start_date_active is NOT NULL then
1403: if p_approval_details_rec.end_Date_active is NOT NULL then
1404: BEGIN
1405: select 1 into l_count
1406: from AMS_APPROVAL_DETAILS_VL
1407: where approval_detail_id =p_approval_details_rec.approval_detail_id
1408: and name = p_approval_details_rec.name
1409: and description = p_approval_details_rec.description
1410: and start_date_active = p_approval_details_rec.start_date_active

Line 1433: from AMS_APPROVAL_DETAILS_VL

1429: END;
1430: else -- for end date
1431: BEGIN
1432: select 1 into l_count
1433: from AMS_APPROVAL_DETAILS_VL
1434: where approval_detail_id =p_approval_details_rec.approval_detail_id
1435: and name = p_approval_details_rec.name
1436: and description = p_approval_details_rec.description
1437: and start_date_active = p_approval_details_rec.start_date_active

Line 1461: from AMS_APPROVAL_DETAILS_VL

1457: end if; -- for end date
1458: else
1459: BEGIN
1460: select 1 into l_count
1461: from AMS_APPROVAL_DETAILS_VL
1462: where approval_detail_id =p_approval_details_rec.approval_detail_id
1463: and name = p_approval_details_rec.name
1464: and description = p_approval_details_rec.description
1465: and start_date_active = p_approval_details_rec.start_date_active

Line 1508: from AMS_APPROVAL_DETAILS

1504:
1505: BEGIN
1506: BEGIN
1507: select 1 into l_count
1508: from AMS_APPROVAL_DETAILS
1509: where approval_detail_id = p_approval_details_rec.approval_detail_id
1510: and seeded_flag = 'Y';
1511: EXCEPTION
1512: WHEN NO_DATA_FOUND THEN

Line 1562: FROM ams_approval_details_vl

1558:
1559:
1560: CURSOR c_approval_details(id_in IN NUMBER) IS
1561: SELECT *
1562: FROM ams_approval_details_vl
1563: WHERE approval_detail_id = id_in;
1564:
1565: cursor c_appr_name1(name_in IN VARCHAR2) IS
1566: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from AMS_APPROVAL_DETAILS_VL

Line 1566: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from AMS_APPROVAL_DETAILS_VL

1562: FROM ams_approval_details_vl
1563: WHERE approval_detail_id = id_in;
1564:
1565: cursor c_appr_name1(name_in IN VARCHAR2) IS
1566: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from AMS_APPROVAL_DETAILS_VL
1567: where name = name_in);
1568:
1569: cursor c_appr_name2(name_in IN VARCHAR2, id_in IN NUMBER) IS
1570: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from AMS_APPROVAL_DETAILS_VL

Line 1570: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from AMS_APPROVAL_DETAILS_VL

1566: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from AMS_APPROVAL_DETAILS_VL
1567: where name = name_in);
1568:
1569: cursor c_appr_name2(name_in IN VARCHAR2, id_in IN NUMBER) IS
1570: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from AMS_APPROVAL_DETAILS_VL
1571: where name = name_in
1572: and approval_detail_id = id_in);
1573:
1574: l_approval_details_rec c_approval_details%ROWTYPE;

Line 1577: SELECT '1' FROM DUAL WHERE EXISTS (select 1 from AMS_APPROVAL_DETAILS_VL

1573:
1574: l_approval_details_rec c_approval_details%ROWTYPE;
1575: */
1576: cursor c_rule_name(name_in IN VARCHAR2, id_in IN NUMBER) IS
1577: SELECT '1' FROM DUAL WHERE EXISTS (select 1 from AMS_APPROVAL_DETAILS_VL
1578: where name = name_in
1579: and approval_detail_id <> id_in);
1580:
1581: BEGIN

Line 1591: 'ams_approval_details',

1587:
1588: --Validate unique approval_id
1589: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1590: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1591: 'ams_approval_details',
1592: 'approval_detail_id = ''' || p_approval_details_rec.approval_detail_id ||'''');
1593: ELSE
1594: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1595: 'ams_approval_details',

Line 1595: 'ams_approval_details',

1591: 'ams_approval_details',
1592: 'approval_detail_id = ''' || p_approval_details_rec.approval_detail_id ||'''');
1593: ELSE
1594: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1595: 'ams_approval_details',
1596: 'approval_detail_id = ''' || p_approval_details_rec.approval_detail_id ||
1597: ''' AND approval_detail_id <> ' || p_approval_details_rec.approval_detail_id);
1598: END IF;
1599:

Line 1616: 'ams_approval_details_vl', 'NAME = ''' || p_approval_details_rec.name ||

1612: -- operators like 'AND'
1613: /*
1614:
1615: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1616: 'ams_approval_details_vl', 'NAME = ''' || p_approval_details_rec.name ||
1617: ''' AND approval_detail_id <> ' || NVL(p_approval_details_rec.approval_detail_id,FND_API.G_MISS_NUM));
1618: */
1619:
1620: OPEN c_rule_name(p_approval_details_rec.name,NVL(p_approval_details_rec.approval_detail_id,FND_API.G_MISS_NUM));

Line 1975: FROM ams_approval_details

1971: l_rule_name VARCHAR2(240);
1972:
1973: CURSOR c_approval_rule (l_approval_id IN NUMBER)IS
1974: SELECT approval_limit_from, approval_limit_to
1975: FROM ams_approval_details
1976: WHERE approval_detail_id = l_approval_id;
1977:
1978: BEGIN
1979:

Line 2068: l_approval_rule_name AMS_APPROVAL_DETAILS_V.Name%TYPE;

2064: l_miss_num NUMBER := FND_API.g_miss_num;
2065: l_miss_char VARCHAR2(30) := FND_API.g_miss_char;
2066: l_miss_date DATE := FND_API.g_miss_date;
2067: l_approval_detail_id NUMBER;
2068: l_approval_rule_name AMS_APPROVAL_DETAILS_V.Name%TYPE;
2069:
2070: CURSOR c_approval_unique IS
2071: select approval_detail_id, name
2072: from AMS_APPROVAL_DETAILS_VL -- Perf Bug Fix. Was previously using _V

Line 2072: from AMS_APPROVAL_DETAILS_VL -- Perf Bug Fix. Was previously using _V

2068: l_approval_rule_name AMS_APPROVAL_DETAILS_V.Name%TYPE;
2069:
2070: CURSOR c_approval_unique IS
2071: select approval_detail_id, name
2072: from AMS_APPROVAL_DETAILS_VL -- Perf Bug Fix. Was previously using _V
2073: where nvl(start_date_active,l_miss_date) = nvl(p_approval_details_rec.start_date_active, l_miss_date)
2074: and nvl(end_date_active,l_miss_date) = nvl(p_approval_details_rec.end_date_active, l_miss_date)
2075: and nvl(business_unit_id,l_miss_num) = nvl(p_approval_details_rec.business_unit_id, l_miss_num)
2076: and nvl(user_country_code,l_miss_char) = nvl(p_approval_details_rec.user_country_code, l_miss_char)

Line 2143: SELECT TRUNC(start_date_active) , TRUNC(end_date_active) FROM ams_approval_details

2139:
2140: v_approvalIds t_approval_id_table;
2141:
2142: CURSOR c_approval_dates IS
2143: SELECT TRUNC(start_date_active) , TRUNC(end_date_active) FROM ams_approval_details
2144: WHERE approval_detail_id = p_approval_details_rec.approval_detail_id;
2145:
2146: CURSOR c_approval_rule IS
2147: SELECT approval_detail_id, TRUNC(start_date_active), TRUNC(end_date_active) FROM ams_approval_details

Line 2147: SELECT approval_detail_id, TRUNC(start_date_active), TRUNC(end_date_active) FROM ams_approval_details

2143: SELECT TRUNC(start_date_active) , TRUNC(end_date_active) FROM ams_approval_details
2144: WHERE approval_detail_id = p_approval_details_rec.approval_detail_id;
2145:
2146: CURSOR c_approval_rule IS
2147: SELECT approval_detail_id, TRUNC(start_date_active), TRUNC(end_date_active) FROM ams_approval_details
2148: where nvl(business_unit_id,l_miss_num) = nvl(p_approval_details_rec.business_unit_id, l_miss_num)
2149: and nvl(user_country_code,l_miss_char) = nvl(p_approval_details_rec.user_country_code, l_miss_char)
2150: and nvl(currency_code,l_miss_char) = nvl(p_approval_details_rec.currency_code, l_miss_char)
2151: and nvl(organization_id,l_miss_num) = nvl(p_approval_details_rec.organization_id, l_miss_num)

Line 2442: END AMS_approval_details_PVT;

2438:
2439: END Check_Dates_Overlap;
2440: --------------------------------------------------------------------
2441:
2442: END AMS_approval_details_PVT;