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_ACCESS_PVT dependencies on AMS_ACT_ACCESS

Line 49: SELECT ams_act_access_s.NEXTVAL

45: l_access_rec access_rec_type := p_access_rec;
46: l_access_count NUMBER;
47:
48: CURSOR c_access_seq IS
49: SELECT ams_act_access_s.NEXTVAL
50: FROM DUAL;
51:
52: CURSOR c_access_count(l_access_id IN NUMBER) IS
53: SELECT COUNT(*)

Line 54: FROM ams_act_access

50: FROM DUAL;
51:
52: CURSOR c_access_count(l_access_id IN NUMBER) IS
53: SELECT COUNT(*)
54: FROM ams_act_access
55: WHERE activity_access_id = l_access_id;
56:
57: /* Following code is added by rrajesh on 09/12/01 */
58: CURSOR c_access_camp_schedules(l_camp_id IN NUMBER) IS

Line 67: /* check for the uniqueness of entries ams_act_access table if p_access_rec.arc_user_or_role_type = 'GROUP' */

63: l_schedule_rec c_access_camp_schedules%ROWTYPE;
64: /* end change 09/12/01 */
65:
66: /* added by sunkumar 03-12-2002 bug id.. 2216520 */
67: /* check for the uniqueness of entries ams_act_access table if p_access_rec.arc_user_or_role_type = 'GROUP' */
68: /* if the entry exists ams_act_access table then a message is popped up to run the concurrent program */
69:
70: CURSOR c_group_exists IS
71: SELECT 1

Line 68: /* if the entry exists ams_act_access table then a message is popped up to run the concurrent program */

64: /* end change 09/12/01 */
65:
66: /* added by sunkumar 03-12-2002 bug id.. 2216520 */
67: /* check for the uniqueness of entries ams_act_access table if p_access_rec.arc_user_or_role_type = 'GROUP' */
68: /* if the entry exists ams_act_access table then a message is popped up to run the concurrent program */
69:
70: CURSOR c_group_exists IS
71: SELECT 1
72: FROM DUAL

Line 74: FROM ams_act_access

70: CURSOR c_group_exists IS
71: SELECT 1
72: FROM DUAL
73: WHERE NOT EXISTS(SELECT 1
74: FROM ams_act_access
75: WHERE ams_act_access.act_access_to_object_id = p_access_rec.act_access_to_object_id
76: AND ams_act_access.arc_act_access_to_object = p_access_rec.arc_act_access_to_object
77: AND ams_act_access.user_or_role_id = p_access_rec.user_or_role_id
78: AND ams_act_access.delete_flag='Y');

Line 75: WHERE ams_act_access.act_access_to_object_id = p_access_rec.act_access_to_object_id

71: SELECT 1
72: FROM DUAL
73: WHERE NOT EXISTS(SELECT 1
74: FROM ams_act_access
75: WHERE ams_act_access.act_access_to_object_id = p_access_rec.act_access_to_object_id
76: AND ams_act_access.arc_act_access_to_object = p_access_rec.arc_act_access_to_object
77: AND ams_act_access.user_or_role_id = p_access_rec.user_or_role_id
78: AND ams_act_access.delete_flag='Y');
79:

Line 76: AND ams_act_access.arc_act_access_to_object = p_access_rec.arc_act_access_to_object

72: FROM DUAL
73: WHERE NOT EXISTS(SELECT 1
74: FROM ams_act_access
75: WHERE ams_act_access.act_access_to_object_id = p_access_rec.act_access_to_object_id
76: AND ams_act_access.arc_act_access_to_object = p_access_rec.arc_act_access_to_object
77: AND ams_act_access.user_or_role_id = p_access_rec.user_or_role_id
78: AND ams_act_access.delete_flag='Y');
79:
80: l_group_exists NUMBER;

Line 77: AND ams_act_access.user_or_role_id = p_access_rec.user_or_role_id

73: WHERE NOT EXISTS(SELECT 1
74: FROM ams_act_access
75: WHERE ams_act_access.act_access_to_object_id = p_access_rec.act_access_to_object_id
76: AND ams_act_access.arc_act_access_to_object = p_access_rec.arc_act_access_to_object
77: AND ams_act_access.user_or_role_id = p_access_rec.user_or_role_id
78: AND ams_act_access.delete_flag='Y');
79:
80: l_group_exists NUMBER;
81: BEGIN

Line 78: AND ams_act_access.delete_flag='Y');

74: FROM ams_act_access
75: WHERE ams_act_access.act_access_to_object_id = p_access_rec.act_access_to_object_id
76: AND ams_act_access.arc_act_access_to_object = p_access_rec.arc_act_access_to_object
77: AND ams_act_access.user_or_role_id = p_access_rec.user_or_role_id
78: AND ams_act_access.delete_flag='Y');
79:
80: l_group_exists NUMBER;
81: BEGIN
82:

Line 140: /* check for the uniqueness of entries ams_act_access table if p_access_rec.arc_user_or_role_type = 'GROUP' */

136: END IF;
137:
138:
139: /* added by sunkumar 03-12-2002 bug id.. 2216520 */
140: /* check for the uniqueness of entries ams_act_access table if p_access_rec.arc_user_or_role_type = 'GROUP' */
141: /* if the entry exists in the ams_act_access table then a message is popped up to run the concurrent program */
142:
143: OPEN c_group_exists;
144: FETCH c_group_exists INTO l_group_exists;

Line 141: /* if the entry exists in the ams_act_access table then a message is popped up to run the concurrent program */

137:
138:
139: /* added by sunkumar 03-12-2002 bug id.. 2216520 */
140: /* check for the uniqueness of entries ams_act_access table if p_access_rec.arc_user_or_role_type = 'GROUP' */
141: /* if the entry exists in the ams_act_access table then a message is popped up to run the concurrent program */
142:
143: OPEN c_group_exists;
144: FETCH c_group_exists INTO l_group_exists;
145: IF p_access_rec.arc_user_or_role_type = 'GROUP' AND c_group_exists%NOTFOUND THEN

Line 165: INSERT INTO ams_act_access(

161: EXIT WHEN l_access_count = 0;
162: END LOOP;
163: END IF;
164:
165: INSERT INTO ams_act_access(
166: activity_access_id,
167: last_update_date,
168: last_updated_by,
169: creation_date,

Line 273: INSERT INTO ams_act_access(

269: END LOOP;
270: FETCH c_access_camp_schedules INTO l_schedule_rec;
271: EXIT WHEN c_access_camp_schedules%NOTFOUND;
272:
273: INSERT INTO ams_act_access(
274: activity_access_id,
275: last_update_date,
276: last_updated_by,
277: creation_date,

Line 310: WHERE NOT EXISTS ( SELECT 1 FROM AMS_ACT_ACCESS WHERE act_access_to_object_id = l_schedule_rec.schedule_id

306: l_access_rec.approver_flag,
307: l_access_rec.owner_flag,
308: 'N'
309: FROM DUAL
310: WHERE NOT EXISTS ( SELECT 1 FROM AMS_ACT_ACCESS WHERE act_access_to_object_id = l_schedule_rec.schedule_id
311: and arc_act_access_to_object = 'CSCH'
312: and user_or_role_id = l_access_rec.user_or_role_id
313: and arc_user_or_role_type = 'USER');
314:

Line 440: FROM ams_act_access

436: act_access_to_object_id,
437: arc_user_or_role_type,
438: user_or_role_id,
439: admin_flag
440: FROM ams_act_access
441: WHERE activity_access_id = l_access_id;
442:
443: CURSOR c_getobj_attr ( p_obj_id in NUMBER, p_obj_type IN VARCHAR2) IS
444: SELECT 'x'

Line 445: FROM ams_act_access

441: WHERE activity_access_id = l_access_id;
442:
443: CURSOR c_getobj_attr ( p_obj_id in NUMBER, p_obj_type IN VARCHAR2) IS
444: SELECT 'x'
445: FROM ams_act_access
446: WHERE arc_act_access_to_object = p_obj_type
447: AND act_access_to_object_id = p_obj_id;
448:
449: l_object_id NUMBER;

Line 467: FROM ams_act_access

463:
464: /* commented by skarumur, using c_getobj_type_id cursor
465: CURSOR c_get_camp_id(l_activity_access_id IN NUMBER) IS
466: SELECT act_access_to_object_id
467: FROM ams_act_access
468: WHERE activity_access_id = l_activity_access_id;
469:
470: CURSOR c_get_user_or_role_type(l_activity_access_id IN NUMBER) IS
471: SELECT arc_user_or_role_type

Line 472: FROM ams_act_access

468: WHERE activity_access_id = l_activity_access_id;
469:
470: CURSOR c_get_user_or_role_type(l_activity_access_id IN NUMBER) IS
471: SELECT arc_user_or_role_type
472: FROM ams_act_access
473: WHERE activity_access_id = l_activity_access_id;
474:
475: CURSOR c_get_user_or_role_id(l_activity_access_id IN NUMBER) IS
476: SELECT user_or_role_id

Line 477: FROM ams_act_access

473: WHERE activity_access_id = l_activity_access_id;
474:
475: CURSOR c_get_user_or_role_id(l_activity_access_id IN NUMBER) IS
476: SELECT user_or_role_id
477: FROM ams_act_access
478: WHERE activity_access_id = l_activity_access_id; */
479:
480: l_schedule_rec c_access_camp_schedules%ROWTYPE;
481: /* end change 09/12/01 */

Line 528: DELETE FROM ams_act_access

524: END IF;
525:
526: IF l_role_type = 'USER' THEN
527:
528: DELETE FROM ams_act_access
529: WHERE activity_access_id = p_access_id
530: AND object_version_number = p_object_version;
531:
532: IF (SQL%NOTFOUND) THEN

Line 561: DELETE FROM ams_act_access

557: OPEN c_access_camp_schedules(l_object_id);
558: LOOP
559: FETCH c_access_camp_schedules INTO l_schedule_rec;
560: EXIT WHEN c_access_camp_schedules%NOTFOUND ;
561: DELETE FROM ams_act_access
562: WHERE act_access_to_object_id = l_schedule_rec.schedule_id
563: AND arc_act_access_to_object = 'CSCH'
564: AND user_or_role_id = l_role_id
565: AND arc_user_or_role_type = l_role_type;

Line 626: UPDATE ams_act_access

622: END IF;
623:
624: ELSIF l_role_type = 'GROUP' THEN
625:
626: UPDATE ams_act_access
627: SET delete_flag = 'Y',
628: last_update_date = sysdate,
629: last_update_login = fnd_global.conc_login_id,
630: last_updated_by = fnd_global.user_id

Line 662: UPDATE ams_act_access

658: OPEN c_access_camp_schedules(l_object_id);
659: LOOP
660: FETCH c_access_camp_schedules INTO l_schedule_rec;
661: EXIT WHEN c_access_camp_schedules%NOTFOUND ;
662: UPDATE ams_act_access
663: SET delete_flag = 'Y',
664: last_update_date = sysdate,
665: last_update_login = fnd_global.conc_login_id,
666: last_updated_by = fnd_global.user_id

Line 807: FROM ams_act_access

803: l_access_id NUMBER;
804:
805: CURSOR c_access_b IS
806: SELECT activity_access_id
807: FROM ams_act_access
808: WHERE activity_access_id = p_access_id
809: AND object_version_number = p_object_version
810: FOR UPDATE OF activity_access_id NOWAIT;
811:

Line 950: FROM ams_act_access

946: WHERE campaign_id = l_camp_id;
947:
948: CURSOR c_get_user_or_role_type(l_activity_access_id IN NUMBER) IS
949: SELECT arc_user_or_role_type
950: FROM ams_act_access
951: WHERE activity_access_id = l_activity_access_id;
952:
953: CURSOR c_get_user_or_role_id(l_activity_access_id IN NUMBER) IS
954: SELECT user_or_role_id

Line 955: FROM ams_act_access

951: WHERE activity_access_id = l_activity_access_id;
952:
953: CURSOR c_get_user_or_role_id(l_activity_access_id IN NUMBER) IS
954: SELECT user_or_role_id
955: FROM ams_act_access
956: WHERE activity_access_id = l_activity_access_id;
957:
958: CURSOR c_get_key_id(p_sched_id IN NUMBER, p_user_or_role_type IN VARCHAR2, p_user_or_role_id NUMBER) IS
959: SELECT activity_access_id

Line 960: FROM ams_act_access

956: WHERE activity_access_id = l_activity_access_id;
957:
958: CURSOR c_get_key_id(p_sched_id IN NUMBER, p_user_or_role_type IN VARCHAR2, p_user_or_role_id NUMBER) IS
959: SELECT activity_access_id
960: FROM ams_act_access
961: WHERE act_access_to_object_id = p_sched_id
962: AND arc_act_access_to_object = 'CSCH'
963: AND user_or_role_id = p_user_or_role_id
964: AND arc_user_or_role_type = p_user_or_role_type;

Line 1031: UPDATE ams_act_access SET

1027:
1028: AMS_Utility_PVT.debug_message(l_full_name ||': update');
1029: END IF;
1030:
1031: UPDATE ams_act_access SET
1032: last_update_date = SYSDATE,
1033: last_updated_by = FND_GLOBAL.user_id,
1034: last_update_login = FND_GLOBAL.conc_login_id,
1035: object_version_number = l_access_rec.object_version_number + 1,

Line 1067: UPDATE ams_act_access SET

1063: OPEN c_get_key_id(l_schedule_rec.schedule_id, l_access_rec.arc_user_or_role_type, l_access_rec.user_or_role_id);
1064: FETCH c_get_key_id INTO l_key_id;
1065: CLOSE c_get_key_id;
1066:
1067: UPDATE ams_act_access SET
1068: last_update_date = SYSDATE,
1069: last_updated_by = FND_GLOBAL.user_id,
1070: last_update_login = FND_GLOBAL.conc_login_id,
1071: object_version_number = object_version_number + 1,

Line 1276: FROM ams_act_access

1272: l_obj_ver_no NUMBER;
1273:
1274: CURSOR c_user_exists IS
1275: SELECT activity_access_id, object_version_number
1276: FROM ams_act_access
1277: WHERE act_access_to_object_id = p_object_id
1278: AND arc_act_access_to_object = p_object_type
1279: AND user_or_role_id = p_resource_id
1280: AND arc_user_or_role_type = 'USER';

Line 1335: UPDATE ams_act_access SET

1331: );
1332: -- end of code added by julou
1333: END IF; -- added by sveerave on 06-jun-2002
1334: -- ELSE -- update owner to new resource
1335: UPDATE ams_act_access SET
1336: last_update_date = SYSDATE,
1337: last_updated_by = FND_GLOBAL.user_id,
1338: last_update_login = FND_GLOBAL.conc_login_id,
1339: object_version_number = object_version_number + 1,

Line 1490: FROM ams_act_access

1486: l_user_id IN NUMBER,
1487: l_user_type IN VARCHAR2)
1488: IS
1489: SELECT 'x'
1490: FROM ams_act_access
1491: WHERE act_access_to_object_id = l_obj_id
1492: AND arc_act_access_to_object = l_obj_type
1493: AND user_or_role_id = l_user_id
1494: AND arc_user_or_role_type = l_user_type

Line 1631: FROM ams_act_access

1627: RETURN VARCHAR2
1628: IS
1629: CURSOR cur_is_owner IS
1630: SELECT 'Y'
1631: FROM ams_act_access
1632: WHERE user_or_role_id = p_user_or_role_id
1633: AND arc_user_or_role_type = 'USER'
1634: AND arc_act_access_to_object = p_object_type
1635: AND act_access_to_object_id = p_object_id

Line 1762: FROM ams_act_access_denorm

1758: x_return_full_priv VARCHAR2(1) := 'F';
1759:
1760: CURSOR cur_check_access IS
1761: SELECT decode(edit_metrics_yn,'Y','F','R')
1762: FROM ams_act_access_denorm
1763: WHERE resource_id = p_user_or_role_id
1764: AND object_id = p_object_id
1765: AND object_type = p_object_type;
1766:

Line 1826: c_act_access_to_object_id IN ams_act_access.act_access_to_object_id%TYPE)

1822:
1823: x_access VARCHAR2(1);
1824:
1825: cursor c_access_camp (
1826: c_act_access_to_object_id IN ams_act_access.act_access_to_object_id%TYPE)
1827: IS
1828: SELECT private_flag
1829: FROM ams_campaigns_all_b
1830: --FROM ams_campaigns_vl

Line 1835: c_act_access_to_object_id IN ams_act_access.act_access_to_object_id%TYPE)

1831: -- commented by ptendulk on 22-Jan-2001 Ref Bug #1607548
1832: WHERE campaign_id = c_act_access_to_object_id;
1833:
1834: cursor c_access_eveo (
1835: c_act_access_to_object_id IN ams_act_access.act_access_to_object_id%TYPE)
1836: IS
1837: SELECT private_flag
1838: -- commented by ptendulk on 22-Jan-2001 Ref Bug #1607548
1839: --FROM ams_event_offers_vl

Line 1844: c_act_access_to_object_id IN ams_act_access.act_access_to_object_id%TYPE)

1840: FROM ams_event_offers_all_b
1841: WHERE event_offer_id = c_act_access_to_object_id;
1842:
1843: cursor c_access_eveh (
1844: c_act_access_to_object_id IN ams_act_access.act_access_to_object_id%TYPE)
1845: IS
1846: SELECT private_flag
1847: -- commented by ptendulk on 22-Jan-2001 Ref Bug #1607548
1848: -- FROM ams_event_headers_vl

Line 1853: c_act_access_to_object_id IN ams_act_access.act_access_to_object_id%TYPE)

1849: FROM ams_event_headers_all_b
1850: WHERE event_header_id = c_act_access_to_object_id;
1851:
1852: cursor c_access_delv (
1853: c_act_access_to_object_id IN ams_act_access.act_access_to_object_id%TYPE)
1854: IS
1855: SELECT private_flag
1856: FROM ams_deliverables_vl
1857: WHERE deliverable_id = c_act_access_to_object_id;

Line 1860: c_act_access_to_object_id IN ams_act_access.act_access_to_object_id%TYPE,

1856: FROM ams_deliverables_vl
1857: WHERE deliverable_id = c_act_access_to_object_id;
1858:
1859: cursor c_access (
1860: c_act_access_to_object_id IN ams_act_access.act_access_to_object_id%TYPE,
1861: c_arc_act_access_to_object IN ams_act_access.arc_act_access_to_object%TYPE,
1862: c_user_or_role_id IN ams_act_access.user_or_role_id%TYPE,
1863: c_arc_user_or_role_type IN ams_act_access.arc_user_or_role_type%TYPE )
1864: IS

Line 1861: c_arc_act_access_to_object IN ams_act_access.arc_act_access_to_object%TYPE,

1857: WHERE deliverable_id = c_act_access_to_object_id;
1858:
1859: cursor c_access (
1860: c_act_access_to_object_id IN ams_act_access.act_access_to_object_id%TYPE,
1861: c_arc_act_access_to_object IN ams_act_access.arc_act_access_to_object%TYPE,
1862: c_user_or_role_id IN ams_act_access.user_or_role_id%TYPE,
1863: c_arc_user_or_role_type IN ams_act_access.arc_user_or_role_type%TYPE )
1864: IS
1865: SELECT admin_flag

Line 1862: c_user_or_role_id IN ams_act_access.user_or_role_id%TYPE,

1858:
1859: cursor c_access (
1860: c_act_access_to_object_id IN ams_act_access.act_access_to_object_id%TYPE,
1861: c_arc_act_access_to_object IN ams_act_access.arc_act_access_to_object%TYPE,
1862: c_user_or_role_id IN ams_act_access.user_or_role_id%TYPE,
1863: c_arc_user_or_role_type IN ams_act_access.arc_user_or_role_type%TYPE )
1864: IS
1865: SELECT admin_flag
1866: FROM ams_act_access

Line 1863: c_arc_user_or_role_type IN ams_act_access.arc_user_or_role_type%TYPE )

1859: cursor c_access (
1860: c_act_access_to_object_id IN ams_act_access.act_access_to_object_id%TYPE,
1861: c_arc_act_access_to_object IN ams_act_access.arc_act_access_to_object%TYPE,
1862: c_user_or_role_id IN ams_act_access.user_or_role_id%TYPE,
1863: c_arc_user_or_role_type IN ams_act_access.arc_user_or_role_type%TYPE )
1864: IS
1865: SELECT admin_flag
1866: FROM ams_act_access
1867: WHERE act_access_to_object_id = c_act_access_to_object_id

Line 1866: FROM ams_act_access

1862: c_user_or_role_id IN ams_act_access.user_or_role_id%TYPE,
1863: c_arc_user_or_role_type IN ams_act_access.arc_user_or_role_type%TYPE )
1864: IS
1865: SELECT admin_flag
1866: FROM ams_act_access
1867: WHERE act_access_to_object_id = c_act_access_to_object_id
1868: AND arc_act_access_to_object = c_arc_act_access_to_object
1869: AND user_or_role_id = c_user_or_role_id
1870: AND arc_user_or_role_type = c_arc_user_or_role_type;

Line 1881: -- FROM ams_act_access A, jtf_rs_group_members_vl B

1877: -- SELECT 1
1878: -- FROM DUAL
1879: -- WHERE EXISTS(
1880: -- SELECT 1
1881: -- FROM ams_act_access A, jtf_rs_group_members_vl B
1882: -- WHERE A.arc_act_access_to_object = p_object_type
1883: -- AND A.act_access_to_object_id = p_object_id
1884: -- AND A.arc_user_or_role_type = 'GROUP'
1885: -- AND (A.active_from_date IS NULL OR A.active_from_date <= SYSDATE)

Line 1896: FROM ams_act_access

1892: SELECT 1
1893: FROM DUAL
1894: WHERE EXISTS(
1895: SELECT 1
1896: FROM ams_act_access
1897: WHERE arc_act_access_to_object = p_object_type
1898: AND act_access_to_object_id = p_object_id
1899: AND arc_user_or_role_type = 'GROUP'
1900: AND (active_from_date IS NULL OR active_from_date <= SYSDATE)

Line 2051: FROM ams_act_access

2047: p_inp_user_type IN VARCHAR2,
2048: p_inp_obj_id IN NUMBER,
2049: p_inp_obj_type IN VARCHAR2
2050: ) is SELECT 'x'
2051: FROM ams_act_access
2052: WHERE user_or_role_id = p_inp_user_id
2053: AND arc_user_or_role_type = p_inp_user_type
2054: AND act_access_to_object_id = p_inp_obj_id
2055: AND arc_act_access_to_object= p_inp_obj_type

Line 2177: 'ams_act_access',

2173: IF p_validation_mode = JTF_PLSQL_API.g_create
2174: AND p_Access_rec.activity_access_id IS NOT NULL
2175: THEN
2176: IF AMS_Utility_PVT.check_uniqueness(
2177: 'ams_act_access',
2178: 'activity_access_id = ' || p_Access_rec.activity_access_id
2179: ) = FND_API.g_false
2180: THEN
2181: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 2412: FROM ams_act_access

2408: CURSOR c_user_exist IS
2409: SELECT 1
2410: FROM DUAL
2411: WHERE EXISTS(SELECT 1
2412: FROM ams_act_access
2413: WHERE act_access_to_object_id = p_access_rec.act_access_to_object_id
2414: AND arc_act_access_to_object = p_access_rec.arc_act_access_to_object
2415: AND user_or_role_id = p_access_rec.user_or_role_id
2416: AND arc_user_or_role_type = p_access_rec.arc_user_or_role_type

Line 2449: /* check for the uniqueness of entries ams_act_access table if p_access_rec.arc_user_or_role_type='USER' */

2445:
2446: END IF;
2447:
2448: /* added by sunkumar 03-12-2002 bug id.. 2216520 */
2449: /* check for the uniqueness of entries ams_act_access table if p_access_rec.arc_user_or_role_type='USER' */
2450: /* then only check for the unique constraint on the ams_act_access table */
2451:
2452: IF p_access_rec.arc_user_or_role_type='USER' THEN
2453: BEGIN

Line 2450: /* then only check for the unique constraint on the ams_act_access table */

2446: END IF;
2447:
2448: /* added by sunkumar 03-12-2002 bug id.. 2216520 */
2449: /* check for the uniqueness of entries ams_act_access table if p_access_rec.arc_user_or_role_type='USER' */
2450: /* then only check for the unique constraint on the ams_act_access table */
2451:
2452: IF p_access_rec.arc_user_or_role_type='USER' THEN
2453: BEGIN
2454: check_Access_uk_items(

Line 2638: FROM ams_act_access

2634: IS
2635:
2636: CURSOR c_Access IS
2637: SELECT *
2638: FROM ams_act_access
2639: WHERE activity_access_id = p_Access_rec.activity_access_id;
2640:
2641: l_Access_rec c_Access%ROWTYPE;
2642: