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.AMW_VIOLATION_PVT dependencies on JTF_VARCHAR2_TABLE_400

Line 120: p_role_names IN JTF_VARCHAR2_TABLE_400,

116: -- 07/19/2005 tsho Create
117: -- ===============================================================
118: Procedure Has_Violations_For_Mode (
119: p_user_id IN NUMBER,
120: p_role_names IN JTF_VARCHAR2_TABLE_400,
121: p_mode IN VARCHAR2,
122: x_violat_hashtable OUT NOCOPY G_VARCHAR2_HASHTABLE
123: )
124: IS

Line 167: p_role_names IN JTF_VARCHAR2_TABLE_400,

163: -- This procedure is obsolated due to bug 5407266
164: -- ===============================================================
165: Procedure Has_Violations (
166: p_user_id IN NUMBER,
167: p_role_names IN JTF_VARCHAR2_TABLE_400,
168: p_mode IN VARCHAR2,
169: x_violat_region OUT NOCOPY VARCHAR2,
170: x_violat_btn_region OUT NOCOPY VARCHAR2,
171: x_has_violation OUT NOCOPY VARCHAR2,

Line 232: p_role_names IN JTF_VARCHAR2_TABLE_400,

228: -- 04/28/2006 dliao Consider RESPALL/RESPME/RESPSET
229: -- ===============================================================
230: Procedure Has_Violations (
231: p_user_id IN NUMBER,
232: p_role_names IN JTF_VARCHAR2_TABLE_400,
233: p_revoked_role_names IN JTF_VARCHAR2_TABLE_400,
234: p_mode IN VARCHAR2,
235: x_violat_region OUT NOCOPY VARCHAR2,
236: x_violat_btn_region OUT NOCOPY VARCHAR2,

Line 233: p_revoked_role_names IN JTF_VARCHAR2_TABLE_400,

229: -- ===============================================================
230: Procedure Has_Violations (
231: p_user_id IN NUMBER,
232: p_role_names IN JTF_VARCHAR2_TABLE_400,
233: p_revoked_role_names IN JTF_VARCHAR2_TABLE_400,
234: p_mode IN VARCHAR2,
235: x_violat_region OUT NOCOPY VARCHAR2,
236: x_violat_btn_region OUT NOCOPY VARCHAR2,
237: x_has_violation OUT NOCOPY VARCHAR2,

Line 329: l_violating_new_resp_table JTF_VARCHAR2_TABLE_400;

325: l_sub_revoked_role_names VARCHAR2(32767);
326:
327:
328: l_violating_new_roles_sql varchar2(32767);
329: l_violating_new_resp_table JTF_VARCHAR2_TABLE_400;
330: l_violating_existing_roles_sql VARCHAR2(32767);
331: l_violating_old_resp_table JTF_VARCHAR2_TABLE_400;
332:
333: l_existing_violation_sql varchar2(32676);

Line 331: l_violating_old_resp_table JTF_VARCHAR2_TABLE_400;

327:
328: l_violating_new_roles_sql varchar2(32767);
329: l_violating_new_resp_table JTF_VARCHAR2_TABLE_400;
330: l_violating_existing_roles_sql VARCHAR2(32767);
331: l_violating_old_resp_table JTF_VARCHAR2_TABLE_400;
332:
333: l_existing_violation_sql varchar2(32676);
334: l_new_violation_table JTF_VARCHAR2_TABLE_400;
335: l_existing_violation_table JTF_VARCHAR2_TABLE_400;

Line 334: l_new_violation_table JTF_VARCHAR2_TABLE_400;

330: l_violating_existing_roles_sql VARCHAR2(32767);
331: l_violating_old_resp_table JTF_VARCHAR2_TABLE_400;
332:
333: l_existing_violation_sql varchar2(32676);
334: l_new_violation_table JTF_VARCHAR2_TABLE_400;
335: l_existing_violation_table JTF_VARCHAR2_TABLE_400;
336:
337:
338: BEGIN

Line 335: l_existing_violation_table JTF_VARCHAR2_TABLE_400;

331: l_violating_old_resp_table JTF_VARCHAR2_TABLE_400;
332:
333: l_existing_violation_sql varchar2(32676);
334: l_new_violation_table JTF_VARCHAR2_TABLE_400;
335: l_existing_violation_table JTF_VARCHAR2_TABLE_400;
336:
337:
338: BEGIN
339: l_role_names := NULL;

Line 2344: l_new_role_table JTF_VARCHAR2_TABLE_400;

2340: L_API_NAME CONSTANT VARCHAR2(30) := 'Get_Violat_New_Role_List';
2341: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
2342:
2343: -- store the new role this user has against this constraint
2344: l_new_role_table JTF_VARCHAR2_TABLE_400;
2345:
2346: -- store the return value
2347: l_new_role_string VARCHAR2(32767);
2348:

Line 2459: l_existing_role_table JTF_VARCHAR2_TABLE_400;

2455: -- store the return value
2456: l_existing_role_string VARCHAR2(32767);
2457:
2458: -- store the existing role this user has against this constraint
2459: l_existing_role_table JTF_VARCHAR2_TABLE_400;
2460:
2461: TYPE refCurTyp IS REF CURSOR;
2462: existing_role_c refCurTyp;
2463:

Line 2538: l_existing_resp_table JTF_VARCHAR2_TABLE_400;

2534: -- store the return value
2535: l_existing_resp_string VARCHAR2(32767);
2536:
2537: -- store the existing responsibilities this user has against this constraint
2538: l_existing_resp_table JTF_VARCHAR2_TABLE_400;
2539:
2540: TYPE refCurTyp IS REF CURSOR;
2541: existing_resp_c refCurTyp;
2542:

Line 2617: l_existing_menu_table JTF_VARCHAR2_TABLE_400;

2613: -- store the return value
2614: l_existing_menu_string VARCHAR2(32767);
2615:
2616: -- store the existing menus this user has against this constraint
2617: l_existing_menu_table JTF_VARCHAR2_TABLE_400;
2618:
2619: TYPE refCurTyp IS REF CURSOR;
2620: existing_menu_c refCurTyp;
2621: