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_V

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 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 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 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 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 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 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 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)