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_LOAD_RCM_ORG_DATA dependencies on AMW_AP_ASSOCIATIONS

Line 1256: ,'AMW_AP_ASSOCIATIONS'

1252: p_encoded => fnd_api.g_false), 1,100);
1253: end if;
1254: END LOOP;
1255: update_interface_with_error (v_err_msg
1256: ,'AMW_AP_ASSOCIATIONS'
1257: ,v_interface_id);
1258: END IF;
1259:
1260: ---03.30.2005 npanandi: check to make the Ctrl-AP

Line 2768: FROM AMW_AP_ASSOCIATIONS

2764: if(l_has_assn_access = 'T') then
2765: BEGIN
2766: SELECT AP_ASSOCIATION_ID,APPROVAL_DATE
2767: INTO L_AP_ASSOCIATION_ID,L_AP_APPROVAL_DATE
2768: FROM AMW_AP_ASSOCIATIONS
2769: WHERE AUDIT_PROCEDURE_ID=P_AUDIT_PROCEDURE_ID
2770: AND PK1=P_CONTROL_ID
2771: AND OBJECT_TYPE='CTRL'
2772: AND DELETION_DATE IS NULL;

Line 2804: UPDATE AMW_AP_ASSOCIATIONS

2800: IF(L_AP_APPROVAL_DATE IS NOT NULL) THEN
2801: --THIS MEANS THAT THIS IS LATEST REVISION FOR THIS ASSOCIATION
2802: --AND IS APPROVED, SO
2803: BEGIN
2804: UPDATE AMW_AP_ASSOCIATIONS
2805: SET DELETION_DATE=SYSDATE
2806: ,OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
2807: ,LAST_UPDATE_DATE=SYSDATE
2808: ,LAST_UPDATED_BY=G_USER_ID

Line 2831: UPDATE AMW_AP_ASSOCIATIONS

2827: --THIS MEANS THAT AP 2 CTRL ASSOCIATION IS LATEST REVISION
2828: -- YET APPROVED, SO
2829: --SIMPLY UPDATE THE ASSOCIATION ATTRIBUTES HERE
2830: BEGIN
2831: UPDATE AMW_AP_ASSOCIATIONS
2832: SET DESIGN_EFFECTIVENESS=P_DESIGN_EFFECTIVENESS
2833: ,OP_EFFECTIVENESS=P_OP_EFFECTIVENESS
2834: ,OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
2835: ,LAST_UPDATE_DATE=SYSDATE

Line 2869: FROM AMW_AP_ASSOCIATIONS

2865: if(p_has_assn_access = 'T') then
2866: BEGIN
2867: SELECT AP_ASSOCIATION_ID,APPROVAL_DATE
2868: INTO L_AP_ASSOCIATION_ID,L_AP_APPROVAL_DATE
2869: FROM AMW_AP_ASSOCIATIONS
2870: WHERE AUDIT_PROCEDURE_ID=P_AUDIT_PROCEDURE_ID
2871: AND PK1=P_ORGANIZATION_ID
2872: AND PK2=P_PROCESS_ID
2873: AND PK3=P_CONTROL_ID

Line 2904: UPDATE AMW_AP_ASSOCIATIONS

2900: IF(L_AP_APPROVAL_DATE IS NOT NULL) THEN
2901: --THIS MEANS THAT THIS IS LATEST REVISION FOR THIS ASSOCIATION
2902: --AND IS APPROVED, SO
2903: BEGIN
2904: UPDATE AMW_AP_ASSOCIATIONS
2905: SET DELETION_DATE=SYSDATE
2906: ,OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
2907: ,LAST_UPDATE_DATE=SYSDATE
2908: ,LAST_UPDATED_BY=G_USER_ID

Line 2932: UPDATE AMW_AP_ASSOCIATIONS

2928: --THIS MEANS THAT AP 2 CTRL ASSOCIATION IS LATEST REVISION
2929: -- YET APPROVED, SO
2930: --SIMPLY UPDATE THE ASSOCIATION ATTRIBUTES HERE
2931: BEGIN
2932: UPDATE AMW_AP_ASSOCIATIONS
2933: SET DESIGN_EFFECTIVENESS=P_DESIGN_EFFECTIVENESS
2934: ,OP_EFFECTIVENESS=P_OP_EFFECTIVENESS
2935: ,OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
2936: ,LAST_UPDATE_DATE=SYSDATE

Line 2962: INSERT INTO amw_ap_associations(

2958: )
2959: IS
2960:
2961: BEGIN
2962: INSERT INTO amw_ap_associations(
2963: ap_association_id
2964: ,last_update_date
2965: ,last_updated_by
2966: ,creation_date

Line 2979: AMW_AP_ASSOCIATIONS_S.NEXTVAL

2975: ,op_effectiveness
2976: ,object_version_number
2977: ,ASSOCIATION_CREATION_DATE)
2978: VALUES (
2979: AMW_AP_ASSOCIATIONS_S.NEXTVAL
2980: ,SYSDATE
2981: ,v_user_id
2982: ,SYSDATE
2983: ,v_user_id