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 AMW_VIOLATION_PVT

Line 1: PACKAGE BODY AMW_VIOLATION_PVT AS

1: PACKAGE BODY AMW_VIOLATION_PVT AS
2: /* $Header: amwvvlab.pls 120.40 2007/09/18 10:58:44 ptulasi ship $ */
3: -- ===============================================================
4: -- Package name
5: -- AMW_VIOLATION_PVT

Line 5: -- AMW_VIOLATION_PVT

1: PACKAGE BODY AMW_VIOLATION_PVT AS
2: /* $Header: amwvvlab.pls 120.40 2007/09/18 10:58:44 ptulasi ship $ */
3: -- ===============================================================
4: -- Package name
5: -- AMW_VIOLATION_PVT
6: -- Purpose
7: --
8: -- History
9: -- 06/01/2005 tsho Create

Line 2799: WF_CORE.CONTEXT('AMW_VIOLATION_PVT','Do_On_Role_Assigned error', p_event.getEventName(), p_subscription_guid);

2795: FND_MESSAGE.SET_NAME( 'AMW', 'GENERIC_MESSAGE' );
2796: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
2797: FND_MSG_PUB.ADD;
2798:
2799: WF_CORE.CONTEXT('AMW_VIOLATION_PVT','Do_On_Role_Assigned error', p_event.getEventName(), p_subscription_guid);
2800: WF_EVENT.setErrorInfo(p_event,'ERROR');
2801: RETURN 'ERROR';
2802: END Do_On_Role_Assigned;
2803:

Line 2854: ||' select AMW_VIOLATION_PVT.get_violat_new_role_list(:1,cst.constraint_rev_id,cst.type_code,:2) NEW_ROLE '

2850: c_violated_cst_dynamic_sql curTyp;
2851: l_violated_cst_dynamic_sql VARCHAR2(32767) :=
2852: 'select * from ( '
2853: -- ALL
2854: ||' select AMW_VIOLATION_PVT.get_violat_new_role_list(:1,cst.constraint_rev_id,cst.type_code,:2) NEW_ROLE '
2855: ||' ,cst.constraint_rev_id '
2856: ||' from amw_constraints_b cst '
2857: ||' where cst.type_code = ''ALL'' '
2858: ||' and cst.start_date <= sysdate AND (cst.end_date IS NULL OR cst.end_date >= sysdate) '

Line 2904: ||' select AMW_VIOLATION_PVT.get_violat_new_role_list(:7,cst.constraint_rev_id,cst.type_code,:8) NEW_ROLE '

2900: ||' ) '
2901: ||' ) '
2902: ||' UNION ALL '
2903: -- ME
2904: ||' select AMW_VIOLATION_PVT.get_violat_new_role_list(:7,cst.constraint_rev_id,cst.type_code,:8) NEW_ROLE '
2905: ||' , cst.constraint_rev_id '
2906: ||' from amw_constraints_b cst '
2907: ||' where cst.type_code = ''ME'' '
2908: ||' and cst.start_date <= sysdate AND (cst.end_date IS NULL OR cst.end_date >= sysdate) '

Line 2951: ||' select AMW_VIOLATION_PVT.get_violat_new_role_list(:13,cst.constraint_rev_id,cst.type_code,:14) NEW_ROLE '

2947: ||' ) '
2948: ||' ) >= 2 '
2949: ||' UNION ALL '
2950: -- SET
2951: ||' select AMW_VIOLATION_PVT.get_violat_new_role_list(:13,cst.constraint_rev_id,cst.type_code,:14) NEW_ROLE '
2952: ||' ,cst.constraint_rev_id '
2953: ||' from amw_constraints_b cst '
2954: ||' where cst.type_code = ''SET'' '
2955: ||' and cst.start_date <= sysdate AND (cst.end_date IS NULL OR cst.end_date >= sysdate) '

Line 2998: ||' select AMW_VIOLATION_PVT.get_violat_new_role_list(:19,cst.constraint_rev_id,cst.type_code,:20) NEW_ROLE '

2994: ||' ) '
2995: ||' ) >= 2 '
2996: ||' UNION ALL '
2997: -- RESPALL
2998: ||' select AMW_VIOLATION_PVT.get_violat_new_role_list(:19,cst.constraint_rev_id,cst.type_code,:20) NEW_ROLE '
2999: ||' ,cst.constraint_rev_id '
3000: ||' from amw_constraints_b cst '
3001: ||' where cst.type_code = ''RESPALL'' '
3002: ||' and cst.start_date <= sysdate AND (cst.end_date IS NULL OR cst.end_date >= sysdate) '

Line 3026: ||' select AMW_VIOLATION_PVT.get_violat_new_role_list(:23,cst.constraint_rev_id,cst.type_code,:24) NEW_ROLE '

3022: ||') '
3023: || ') '
3024: ||' UNION ALL '
3025: -- RESPME
3026: ||' select AMW_VIOLATION_PVT.get_violat_new_role_list(:23,cst.constraint_rev_id,cst.type_code,:24) NEW_ROLE '
3027: ||' , cst.constraint_rev_id '
3028: ||' from amw_constraints_b cst '
3029: ||' where cst.type_code = ''RESPME'' '
3030: ||' and cst.start_date <= sysdate AND (cst.end_date IS NULL OR cst.end_date >= sysdate) '

Line 3053: ||' select AMW_VIOLATION_PVT.get_violat_new_role_list(:27,cst.constraint_rev_id,cst.type_code,:28) NEW_ROLE '

3049: ||') '
3050: ||' >= 2 '
3051: ||' UNION ALL '
3052: -- RESPSET
3053: ||' select AMW_VIOLATION_PVT.get_violat_new_role_list(:27,cst.constraint_rev_id,cst.type_code,:28) NEW_ROLE '
3054: ||' , cst.constraint_rev_id '
3055: ||' from amw_constraints_b cst '
3056: ||' where cst.type_code = ''RESPME'' '
3057: ||' and cst.start_date <= sysdate AND (cst.end_date IS NULL OR cst.end_date >= sysdate) '

Line 4141: END AMW_VIOLATION_PVT;

4137:
4138: end FUNCTION_VIOLATES_MENU;
4139:
4140: -- ----------------------------------------------------------------------
4141: END AMW_VIOLATION_PVT;