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 58: SELECT ams_act_access_s.NEXTVAL

54:
55: --End:Fix for Bug#10192372
56:
57: CURSOR c_access_seq IS
58: SELECT ams_act_access_s.NEXTVAL
59: FROM DUAL;
60:
61: CURSOR c_access_count(l_access_id IN NUMBER) IS
62: SELECT COUNT(*)

Line 63: FROM ams_act_access

59: FROM DUAL;
60:
61: CURSOR c_access_count(l_access_id IN NUMBER) IS
62: SELECT COUNT(*)
63: FROM ams_act_access
64: WHERE activity_access_id = l_access_id;
65:
66:
67: ----Start:Fix for Bug#10192372

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

88: l_schedule_rec c_access_camp_schedules%ROWTYPE;
89: /* end change 09/12/01 */
90:
91: /* added by sunkumar 03-12-2002 bug id.. 2216520 */
92: /* check for the uniqueness of entries ams_act_access table if p_access_rec.arc_user_or_role_type = 'GROUP' */
93: /* if the entry exists ams_act_access table then a message is popped up to run the concurrent program */
94:
95: CURSOR c_group_exists IS
96: SELECT 1

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

89: /* end change 09/12/01 */
90:
91: /* added by sunkumar 03-12-2002 bug id.. 2216520 */
92: /* check for the uniqueness of entries ams_act_access table if p_access_rec.arc_user_or_role_type = 'GROUP' */
93: /* if the entry exists ams_act_access table then a message is popped up to run the concurrent program */
94:
95: CURSOR c_group_exists IS
96: SELECT 1
97: FROM DUAL

Line 99: FROM ams_act_access

95: CURSOR c_group_exists IS
96: SELECT 1
97: FROM DUAL
98: WHERE NOT EXISTS(SELECT 1
99: FROM ams_act_access
100: WHERE ams_act_access.act_access_to_object_id = p_access_rec.act_access_to_object_id
101: AND ams_act_access.arc_act_access_to_object = p_access_rec.arc_act_access_to_object
102: AND ams_act_access.user_or_role_id = p_access_rec.user_or_role_id
103: AND ams_act_access.delete_flag='Y');

Line 100: WHERE ams_act_access.act_access_to_object_id = p_access_rec.act_access_to_object_id

96: SELECT 1
97: FROM DUAL
98: WHERE NOT EXISTS(SELECT 1
99: FROM ams_act_access
100: WHERE ams_act_access.act_access_to_object_id = p_access_rec.act_access_to_object_id
101: AND ams_act_access.arc_act_access_to_object = p_access_rec.arc_act_access_to_object
102: AND ams_act_access.user_or_role_id = p_access_rec.user_or_role_id
103: AND ams_act_access.delete_flag='Y');
104:

Line 101: AND ams_act_access.arc_act_access_to_object = p_access_rec.arc_act_access_to_object

97: FROM DUAL
98: WHERE NOT EXISTS(SELECT 1
99: FROM ams_act_access
100: WHERE ams_act_access.act_access_to_object_id = p_access_rec.act_access_to_object_id
101: AND ams_act_access.arc_act_access_to_object = p_access_rec.arc_act_access_to_object
102: AND ams_act_access.user_or_role_id = p_access_rec.user_or_role_id
103: AND ams_act_access.delete_flag='Y');
104:
105: l_group_exists NUMBER;

Line 102: AND ams_act_access.user_or_role_id = p_access_rec.user_or_role_id

98: WHERE NOT EXISTS(SELECT 1
99: FROM ams_act_access
100: WHERE ams_act_access.act_access_to_object_id = p_access_rec.act_access_to_object_id
101: AND ams_act_access.arc_act_access_to_object = p_access_rec.arc_act_access_to_object
102: AND ams_act_access.user_or_role_id = p_access_rec.user_or_role_id
103: AND ams_act_access.delete_flag='Y');
104:
105: l_group_exists NUMBER;
106: BEGIN

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

99: FROM ams_act_access
100: WHERE ams_act_access.act_access_to_object_id = p_access_rec.act_access_to_object_id
101: AND ams_act_access.arc_act_access_to_object = p_access_rec.arc_act_access_to_object
102: AND ams_act_access.user_or_role_id = p_access_rec.user_or_role_id
103: AND ams_act_access.delete_flag='Y');
104:
105: l_group_exists NUMBER;
106: BEGIN
107:

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

161: END IF;
162:
163:
164: /* added by sunkumar 03-12-2002 bug id.. 2216520 */
165: /* check for the uniqueness of entries ams_act_access table if p_access_rec.arc_user_or_role_type = 'GROUP' */
166: /* if the entry exists in the ams_act_access table then a message is popped up to run the concurrent program */
167:
168: OPEN c_group_exists;
169: FETCH c_group_exists INTO l_group_exists;

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

162:
163:
164: /* added by sunkumar 03-12-2002 bug id.. 2216520 */
165: /* check for the uniqueness of entries ams_act_access table if p_access_rec.arc_user_or_role_type = 'GROUP' */
166: /* if the entry exists in the ams_act_access table then a message is popped up to run the concurrent program */
167:
168: OPEN c_group_exists;
169: FETCH c_group_exists INTO l_group_exists;
170: IF p_access_rec.arc_user_or_role_type = 'GROUP' AND c_group_exists%NOTFOUND THEN

Line 190: INSERT INTO ams_act_access(

186: EXIT WHEN l_access_count = 0;
187: END LOOP;
188: END IF;
189:
190: INSERT INTO ams_act_access(
191: activity_access_id,
192: last_update_date,
193: last_updated_by,
194: creation_date,

Line 298: INSERT INTO ams_act_access(

294: END LOOP;
295: FETCH c_access_camp_schedules INTO l_schedule_rec;
296: EXIT WHEN c_access_camp_schedules%NOTFOUND;
297:
298: INSERT INTO ams_act_access(
299: activity_access_id,
300: last_update_date,
301: last_updated_by,
302: creation_date,

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

331: l_access_rec.approver_flag,
332: l_access_rec.owner_flag,
333: 'N'
334: FROM DUAL
335: WHERE NOT EXISTS ( SELECT 1 FROM AMS_ACT_ACCESS WHERE act_access_to_object_id = l_schedule_rec.schedule_id
336: and arc_act_access_to_object = 'CSCH'
337: and user_or_role_id = l_access_rec.user_or_role_id
338: and arc_user_or_role_type = 'USER');
339:

Line 399: INSERT INTO ams_act_access(

395:
396: ----------------
397: IF l_qp_list_header_id IS NOT NULL THEN
398:
399: INSERT INTO ams_act_access(
400: activity_access_id,
401: last_update_date,
402: last_updated_by,
403: creation_date,

Line 438: WHERE NOT EXISTS ( SELECT 1 FROM AMS_ACT_ACCESS WHERE act_access_to_object_id = l_qp_list_header_id

434: l_access_rec.approver_flag,
435: l_access_rec.owner_flag,
436: 'N'
437: FROM DUAL
438: WHERE NOT EXISTS ( SELECT 1 FROM AMS_ACT_ACCESS WHERE act_access_to_object_id = l_qp_list_header_id
439: and arc_act_access_to_object = 'OFFR'
440: and user_or_role_id = l_access_rec.user_or_role_id
441: and arc_user_or_role_type = 'USER');
442:

Line 580: FROM ams_act_access

576: act_access_to_object_id,
577: arc_user_or_role_type,
578: user_or_role_id,
579: admin_flag
580: FROM ams_act_access
581: WHERE activity_access_id = l_access_id;
582:
583: CURSOR c_getobj_attr ( p_obj_id in NUMBER, p_obj_type IN VARCHAR2) IS
584: SELECT 'x'

Line 585: FROM ams_act_access

581: WHERE activity_access_id = l_access_id;
582:
583: CURSOR c_getobj_attr ( p_obj_id in NUMBER, p_obj_type IN VARCHAR2) IS
584: SELECT 'x'
585: FROM ams_act_access
586: WHERE arc_act_access_to_object = p_obj_type
587: AND act_access_to_object_id = p_obj_id;
588:
589: l_object_id NUMBER;

Line 607: FROM ams_act_access

603:
604: /* commented by skarumur, using c_getobj_type_id cursor
605: CURSOR c_get_camp_id(l_activity_access_id IN NUMBER) IS
606: SELECT act_access_to_object_id
607: FROM ams_act_access
608: WHERE activity_access_id = l_activity_access_id;
609:
610: CURSOR c_get_user_or_role_type(l_activity_access_id IN NUMBER) IS
611: SELECT arc_user_or_role_type

Line 612: FROM ams_act_access

608: WHERE activity_access_id = l_activity_access_id;
609:
610: CURSOR c_get_user_or_role_type(l_activity_access_id IN NUMBER) IS
611: SELECT arc_user_or_role_type
612: FROM ams_act_access
613: WHERE activity_access_id = l_activity_access_id;
614:
615: CURSOR c_get_user_or_role_id(l_activity_access_id IN NUMBER) IS
616: SELECT user_or_role_id

Line 617: FROM ams_act_access

613: WHERE activity_access_id = l_activity_access_id;
614:
615: CURSOR c_get_user_or_role_id(l_activity_access_id IN NUMBER) IS
616: SELECT user_or_role_id
617: FROM ams_act_access
618: WHERE activity_access_id = l_activity_access_id; */
619:
620: l_schedule_rec c_access_camp_schedules%ROWTYPE;
621: /* end change 09/12/01 */

Line 685: DELETE FROM ams_act_access

681: END IF;
682:
683: IF l_role_type = 'USER' THEN
684:
685: DELETE FROM ams_act_access
686: WHERE activity_access_id = p_access_id
687: AND object_version_number = p_object_version;
688:
689: IF (SQL%NOTFOUND) THEN

Line 718: DELETE FROM ams_act_access

714: OPEN c_access_camp_schedules(l_object_id);
715: LOOP
716: FETCH c_access_camp_schedules INTO l_schedule_rec;
717: EXIT WHEN c_access_camp_schedules%NOTFOUND ;
718: DELETE FROM ams_act_access
719: WHERE act_access_to_object_id = l_schedule_rec.schedule_id
720: AND arc_act_access_to_object = 'CSCH'
721: AND user_or_role_id = l_role_id
722: AND arc_user_or_role_type = l_role_type;

Line 766: DELETE FROM ams_act_access

762: OPEN ozf_offer_cursor(l_fund_number);
763: FETCH ozf_offer_cursor INTO l_qp_list_header_id;
764: CLOSE ozf_offer_cursor;
765: IF l_qp_list_header_id IS NOT NULL THEN
766: DELETE FROM ams_act_access
767: WHERE act_access_to_object_id = l_qp_list_header_id
768: AND arc_act_access_to_object = 'OFFR'
769: AND user_or_role_id = l_role_id
770: AND arc_user_or_role_type = l_role_type;

Line 835: UPDATE ams_act_access

831: END IF;
832:
833: ELSIF l_role_type = 'GROUP' THEN
834:
835: UPDATE ams_act_access
836: SET delete_flag = 'Y',
837: last_update_date = sysdate,
838: last_update_login = fnd_global.conc_login_id,
839: last_updated_by = fnd_global.user_id

Line 871: UPDATE ams_act_access

867: OPEN c_access_camp_schedules(l_object_id);
868: LOOP
869: FETCH c_access_camp_schedules INTO l_schedule_rec;
870: EXIT WHEN c_access_camp_schedules%NOTFOUND ;
871: UPDATE ams_act_access
872: SET delete_flag = 'Y',
873: last_update_date = sysdate,
874: last_update_login = fnd_global.conc_login_id,
875: last_updated_by = fnd_global.user_id

Line 904: UPDATE ams_act_access

900: CLOSE ozf_offer_cursor;
901:
902: IF l_qp_list_header_id IS NOT NULL THEN
903:
904: UPDATE ams_act_access
905: SET delete_flag = 'Y',
906: last_update_date = sysdate,
907: last_update_login = fnd_global.conc_login_id,
908: last_updated_by = fnd_global.user_id

Line 1050: FROM ams_act_access

1046: l_access_id NUMBER;
1047:
1048: CURSOR c_access_b IS
1049: SELECT activity_access_id
1050: FROM ams_act_access
1051: WHERE activity_access_id = p_access_id
1052: AND object_version_number = p_object_version
1053: FOR UPDATE OF activity_access_id NOWAIT;
1054:

Line 1193: FROM ams_act_access

1189: WHERE campaign_id = l_camp_id;
1190:
1191: CURSOR c_get_user_or_role_type(l_activity_access_id IN NUMBER) IS
1192: SELECT arc_user_or_role_type
1193: FROM ams_act_access
1194: WHERE activity_access_id = l_activity_access_id;
1195:
1196: CURSOR c_get_user_or_role_id(l_activity_access_id IN NUMBER) IS
1197: SELECT user_or_role_id

Line 1198: FROM ams_act_access

1194: WHERE activity_access_id = l_activity_access_id;
1195:
1196: CURSOR c_get_user_or_role_id(l_activity_access_id IN NUMBER) IS
1197: SELECT user_or_role_id
1198: FROM ams_act_access
1199: WHERE activity_access_id = l_activity_access_id;
1200:
1201: CURSOR c_get_key_id(p_sched_id IN NUMBER, p_user_or_role_type IN VARCHAR2, p_user_or_role_id NUMBER,p_act_access_to_object VARCHAR2) IS
1202: SELECT activity_access_id

Line 1203: FROM ams_act_access

1199: WHERE activity_access_id = l_activity_access_id;
1200:
1201: CURSOR c_get_key_id(p_sched_id IN NUMBER, p_user_or_role_type IN VARCHAR2, p_user_or_role_id NUMBER,p_act_access_to_object VARCHAR2) IS
1202: SELECT activity_access_id
1203: FROM ams_act_access
1204: WHERE act_access_to_object_id = p_sched_id
1205: AND arc_act_access_to_object = p_act_access_to_object
1206: AND user_or_role_id = p_user_or_role_id
1207: AND arc_user_or_role_type = p_user_or_role_type;

Line 1302: UPDATE ams_act_access SET

1298: END IF;
1299:
1300:
1301:
1302: UPDATE ams_act_access SET
1303: last_update_date = SYSDATE,
1304: last_updated_by = FND_GLOBAL.user_id,
1305: last_update_login = FND_GLOBAL.conc_login_id,
1306: object_version_number = l_access_rec.object_version_number + 1,

Line 1338: UPDATE ams_act_access SET

1334: 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,'CSCH');
1335: FETCH c_get_key_id INTO l_key_id;
1336: CLOSE c_get_key_id;
1337:
1338: UPDATE ams_act_access SET
1339: last_update_date = SYSDATE,
1340: last_updated_by = FND_GLOBAL.user_id,
1341: last_update_login = FND_GLOBAL.conc_login_id,
1342: object_version_number = object_version_number + 1,

Line 1409: UPDATE ams_act_access SET

1405: CLOSE c_get_key_id;
1406:
1407:
1408:
1409: UPDATE ams_act_access SET
1410: last_update_date = SYSDATE,
1411: last_updated_by = FND_GLOBAL.user_id,
1412: last_update_login = FND_GLOBAL.conc_login_id,
1413: object_version_number = object_version_number + 1,

Line 1619: FROM ams_act_access

1615: l_obj_ver_no NUMBER;
1616:
1617: CURSOR c_user_exists IS
1618: SELECT activity_access_id, object_version_number
1619: FROM ams_act_access
1620: WHERE act_access_to_object_id = p_object_id
1621: AND arc_act_access_to_object = p_object_type
1622: AND user_or_role_id = p_resource_id
1623: AND arc_user_or_role_type = 'USER';

Line 1678: UPDATE ams_act_access SET

1674: );
1675: -- end of code added by julou
1676: END IF; -- added by sveerave on 06-jun-2002
1677: -- ELSE -- update owner to new resource
1678: UPDATE ams_act_access SET
1679: last_update_date = SYSDATE,
1680: last_updated_by = FND_GLOBAL.user_id,
1681: last_update_login = FND_GLOBAL.conc_login_id,
1682: object_version_number = object_version_number + 1,

Line 1833: FROM ams_act_access

1829: l_user_id IN NUMBER,
1830: l_user_type IN VARCHAR2)
1831: IS
1832: SELECT 'x'
1833: FROM ams_act_access
1834: WHERE act_access_to_object_id = l_obj_id
1835: AND arc_act_access_to_object = l_obj_type
1836: AND user_or_role_id = l_user_id
1837: AND arc_user_or_role_type = l_user_type

Line 1974: FROM ams_act_access

1970: RETURN VARCHAR2
1971: IS
1972: CURSOR cur_is_owner IS
1973: SELECT 'Y'
1974: FROM ams_act_access
1975: WHERE user_or_role_id = p_user_or_role_id
1976: AND arc_user_or_role_type = 'USER'
1977: AND arc_act_access_to_object = p_object_type
1978: AND act_access_to_object_id = p_object_id

Line 2105: FROM ams_act_access_denorm

2101: x_return_full_priv VARCHAR2(1) := 'F';
2102:
2103: CURSOR cur_check_access IS
2104: SELECT decode(edit_metrics_yn,'Y','F','R')
2105: FROM ams_act_access_denorm
2106: WHERE resource_id = p_user_or_role_id
2107: AND object_id = p_object_id
2108: AND object_type = p_object_type;
2109:

Line 2169: c_act_access_to_object_id IN ams_act_access.act_access_to_object_id%TYPE)

2165:
2166: x_access VARCHAR2(1);
2167:
2168: cursor c_access_camp (
2169: c_act_access_to_object_id IN ams_act_access.act_access_to_object_id%TYPE)
2170: IS
2171: SELECT private_flag
2172: FROM ams_campaigns_all_b
2173: --FROM ams_campaigns_vl

Line 2178: c_act_access_to_object_id IN ams_act_access.act_access_to_object_id%TYPE)

2174: -- commented by ptendulk on 22-Jan-2001 Ref Bug #1607548
2175: WHERE campaign_id = c_act_access_to_object_id;
2176:
2177: cursor c_access_eveo (
2178: c_act_access_to_object_id IN ams_act_access.act_access_to_object_id%TYPE)
2179: IS
2180: SELECT private_flag
2181: -- commented by ptendulk on 22-Jan-2001 Ref Bug #1607548
2182: --FROM ams_event_offers_vl

Line 2187: c_act_access_to_object_id IN ams_act_access.act_access_to_object_id%TYPE)

2183: FROM ams_event_offers_all_b
2184: WHERE event_offer_id = c_act_access_to_object_id;
2185:
2186: cursor c_access_eveh (
2187: c_act_access_to_object_id IN ams_act_access.act_access_to_object_id%TYPE)
2188: IS
2189: SELECT private_flag
2190: -- commented by ptendulk on 22-Jan-2001 Ref Bug #1607548
2191: -- FROM ams_event_headers_vl

Line 2196: c_act_access_to_object_id IN ams_act_access.act_access_to_object_id%TYPE)

2192: FROM ams_event_headers_all_b
2193: WHERE event_header_id = c_act_access_to_object_id;
2194:
2195: cursor c_access_delv (
2196: c_act_access_to_object_id IN ams_act_access.act_access_to_object_id%TYPE)
2197: IS
2198: SELECT private_flag
2199: FROM ams_deliverables_vl
2200: WHERE deliverable_id = c_act_access_to_object_id;

Line 2203: c_act_access_to_object_id IN ams_act_access.act_access_to_object_id%TYPE,

2199: FROM ams_deliverables_vl
2200: WHERE deliverable_id = c_act_access_to_object_id;
2201:
2202: cursor c_access (
2203: c_act_access_to_object_id IN ams_act_access.act_access_to_object_id%TYPE,
2204: c_arc_act_access_to_object IN ams_act_access.arc_act_access_to_object%TYPE,
2205: c_user_or_role_id IN ams_act_access.user_or_role_id%TYPE,
2206: c_arc_user_or_role_type IN ams_act_access.arc_user_or_role_type%TYPE )
2207: IS

Line 2204: c_arc_act_access_to_object IN ams_act_access.arc_act_access_to_object%TYPE,

2200: WHERE deliverable_id = c_act_access_to_object_id;
2201:
2202: cursor c_access (
2203: c_act_access_to_object_id IN ams_act_access.act_access_to_object_id%TYPE,
2204: c_arc_act_access_to_object IN ams_act_access.arc_act_access_to_object%TYPE,
2205: c_user_or_role_id IN ams_act_access.user_or_role_id%TYPE,
2206: c_arc_user_or_role_type IN ams_act_access.arc_user_or_role_type%TYPE )
2207: IS
2208: SELECT admin_flag

Line 2205: c_user_or_role_id IN ams_act_access.user_or_role_id%TYPE,

2201:
2202: cursor c_access (
2203: c_act_access_to_object_id IN ams_act_access.act_access_to_object_id%TYPE,
2204: c_arc_act_access_to_object IN ams_act_access.arc_act_access_to_object%TYPE,
2205: c_user_or_role_id IN ams_act_access.user_or_role_id%TYPE,
2206: c_arc_user_or_role_type IN ams_act_access.arc_user_or_role_type%TYPE )
2207: IS
2208: SELECT admin_flag
2209: FROM ams_act_access

Line 2206: c_arc_user_or_role_type IN ams_act_access.arc_user_or_role_type%TYPE )

2202: cursor c_access (
2203: c_act_access_to_object_id IN ams_act_access.act_access_to_object_id%TYPE,
2204: c_arc_act_access_to_object IN ams_act_access.arc_act_access_to_object%TYPE,
2205: c_user_or_role_id IN ams_act_access.user_or_role_id%TYPE,
2206: c_arc_user_or_role_type IN ams_act_access.arc_user_or_role_type%TYPE )
2207: IS
2208: SELECT admin_flag
2209: FROM ams_act_access
2210: WHERE act_access_to_object_id = c_act_access_to_object_id

Line 2209: FROM ams_act_access

2205: c_user_or_role_id IN ams_act_access.user_or_role_id%TYPE,
2206: c_arc_user_or_role_type IN ams_act_access.arc_user_or_role_type%TYPE )
2207: IS
2208: SELECT admin_flag
2209: FROM ams_act_access
2210: WHERE act_access_to_object_id = c_act_access_to_object_id
2211: AND arc_act_access_to_object = c_arc_act_access_to_object
2212: AND user_or_role_id = c_user_or_role_id
2213: AND arc_user_or_role_type = c_arc_user_or_role_type;

Line 2224: -- FROM ams_act_access A, jtf_rs_group_members_vl B

2220: -- SELECT 1
2221: -- FROM DUAL
2222: -- WHERE EXISTS(
2223: -- SELECT 1
2224: -- FROM ams_act_access A, jtf_rs_group_members_vl B
2225: -- WHERE A.arc_act_access_to_object = p_object_type
2226: -- AND A.act_access_to_object_id = p_object_id
2227: -- AND A.arc_user_or_role_type = 'GROUP'
2228: -- AND (A.active_from_date IS NULL OR A.active_from_date <= SYSDATE)

Line 2239: FROM ams_act_access

2235: SELECT 1
2236: FROM DUAL
2237: WHERE EXISTS(
2238: SELECT 1
2239: FROM ams_act_access
2240: WHERE arc_act_access_to_object = p_object_type
2241: AND act_access_to_object_id = p_object_id
2242: AND arc_user_or_role_type = 'GROUP'
2243: AND (active_from_date IS NULL OR active_from_date <= SYSDATE)

Line 2394: FROM ams_act_access

2390: p_inp_user_type IN VARCHAR2,
2391: p_inp_obj_id IN NUMBER,
2392: p_inp_obj_type IN VARCHAR2
2393: ) is SELECT 'x'
2394: FROM ams_act_access
2395: WHERE user_or_role_id = p_inp_user_id
2396: AND arc_user_or_role_type = p_inp_user_type
2397: AND act_access_to_object_id = p_inp_obj_id
2398: AND arc_act_access_to_object= p_inp_obj_type

Line 2520: 'ams_act_access',

2516: IF p_validation_mode = JTF_PLSQL_API.g_create
2517: AND p_Access_rec.activity_access_id IS NOT NULL
2518: THEN
2519: IF AMS_Utility_PVT.check_uniqueness(
2520: 'ams_act_access',
2521: 'activity_access_id = ' || p_Access_rec.activity_access_id
2522: ) = FND_API.g_false
2523: THEN
2524: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 2755: FROM ams_act_access

2751: CURSOR c_user_exist IS
2752: SELECT 1
2753: FROM DUAL
2754: WHERE EXISTS(SELECT 1
2755: FROM ams_act_access
2756: WHERE act_access_to_object_id = p_access_rec.act_access_to_object_id
2757: AND arc_act_access_to_object = p_access_rec.arc_act_access_to_object
2758: AND user_or_role_id = p_access_rec.user_or_role_id
2759: AND arc_user_or_role_type = p_access_rec.arc_user_or_role_type

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

2788:
2789: END IF;
2790:
2791: /* added by sunkumar 03-12-2002 bug id.. 2216520 */
2792: /* check for the uniqueness of entries ams_act_access table if p_access_rec.arc_user_or_role_type='USER' */
2793: /* then only check for the unique constraint on the ams_act_access table */
2794:
2795: IF p_access_rec.arc_user_or_role_type='USER' THEN
2796: BEGIN

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

2789: END IF;
2790:
2791: /* added by sunkumar 03-12-2002 bug id.. 2216520 */
2792: /* check for the uniqueness of entries ams_act_access table if p_access_rec.arc_user_or_role_type='USER' */
2793: /* then only check for the unique constraint on the ams_act_access table */
2794:
2795: IF p_access_rec.arc_user_or_role_type='USER' THEN
2796: BEGIN
2797: check_Access_uk_items(

Line 2981: FROM ams_act_access

2977: IS
2978:
2979: CURSOR c_Access IS
2980: SELECT *
2981: FROM ams_act_access
2982: WHERE activity_access_id = p_Access_rec.activity_access_id;
2983:
2984: l_Access_rec c_Access%ROWTYPE;
2985: