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_PROC_ORG_APPROVAL_PKG dependencies on AMW_EXCEPTIONS_B

Line 1047: FROM amw_exceptions_b

1043: old_pk4,
1044: old_pk5,
1045: old_pk6,
1046: object_type
1047: FROM amw_exceptions_b
1048: WHERE approved_flag = 'N'
1049: AND old_PK1 = org_Id
1050: AND old_PK2 = process_id
1051: AND transaction_type = 'DEL'

Line 1064: FROM amw_exceptions_b

1060: new_pk4,
1061: new_pk5,
1062: new_pk6,
1063: object_type
1064: FROM amw_exceptions_b
1065: WHERE approved_flag = 'N'
1066: AND new_pk1 = org_Id
1067: AND new_pk2 = process_id
1068: AND transaction_type = 'ADD'

Line 1076: FROM amw_exceptions_b

1072:
1073: CURSOR past_appr_addd_ex(p_pk1 VARCHAR2, p_pk2 VARCHAR2, p_pk3 VARCHAR2,p_pk4 VARCHAR2,p_pk5 VARCHAR2,p_pk6 VARCHAR2, p_obj_type VARCHAR2)
1074: IS
1075: SELECT exception_object_id
1076: FROM amw_exceptions_b
1077: WHERE NVL(new_pk1, -99) = NVL(p_pk1, -99)
1078: AND NVL(new_pk2, -99) = NVL(p_pk2, -99)
1079: AND NVL(new_pk3, -99) = NVL(p_pk3, -99)
1080: AND NVL(new_pk4, -99) = NVL(p_pk4, -99)

Line 1091: FROM amw_exceptions_b

1087:
1088: CURSOR past_appr_del_ex(p_pk1 VARCHAR2, p_pk2 VARCHAR2, p_pk3 VARCHAR2,p_pk4 VARCHAR2,p_pk5 VARCHAR2,p_pk6 VARCHAR2, p_obj_type VARCHAR2)
1089: IS
1090: SELECT exception_object_id
1091: FROM amw_exceptions_b
1092: WHERE NVL(old_pk1, -99) = NVL(p_pk1, -99)
1093: AND NVL(old_pk2, -99) = NVL(p_pk2, -99)
1094: AND NVL(old_pk3, -99) = NVL(p_pk3, -99)
1095: AND NVL(old_pk4, -99) = NVL(p_pk4, -99)

Line 1125: UPDATE amw_exceptions_b SET end_date = SYSDATE where exception_object_id = past_appr_del_ex_rec.exception_object_id;

1121: added_exceptions_rec.OBJECT_TYPE) LOOP
1122: EXIT WHEN past_appr_del_ex%NOTFOUND;
1123: l_exception_exists := TRUE;
1124: -- We have an past exception for the opposite action.. So end date that exception...
1125: UPDATE amw_exceptions_b SET end_date = SYSDATE where exception_object_id = past_appr_del_ex_rec.exception_object_id;
1126: END LOOP;
1127: IF l_exception_exists = TRUE THEN
1128: UPDATE amw_exceptions_b SET end_date = SYSDATE, approved_flag = 'Y' where exception_object_id = added_exceptions_rec.exception_object_id;
1129: END IF;

Line 1128: UPDATE amw_exceptions_b SET end_date = SYSDATE, approved_flag = 'Y' where exception_object_id = added_exceptions_rec.exception_object_id;

1124: -- We have an past exception for the opposite action.. So end date that exception...
1125: UPDATE amw_exceptions_b SET end_date = SYSDATE where exception_object_id = past_appr_del_ex_rec.exception_object_id;
1126: END LOOP;
1127: IF l_exception_exists = TRUE THEN
1128: UPDATE amw_exceptions_b SET end_date = SYSDATE, approved_flag = 'Y' where exception_object_id = added_exceptions_rec.exception_object_id;
1129: END IF;
1130: END LOOP;
1131:
1132: -- Similarly Check For the Delete Exceptions .... End Date if any previous exceptions exists..

Line 1147: UPDATE amw_exceptions_b SET end_date = SYSDATE where exception_object_id = past_appr_addd_ex_rec.exception_object_id;

1143: deleted_exceptions_rec.OBJECT_TYPE) LOOP
1144: EXIT WHEN past_appr_addd_ex%NOTFOUND;
1145: l_exception_exists := TRUE;
1146: -- We have an past exception for the opposite action.. So end date that exception...
1147: UPDATE amw_exceptions_b SET end_date = SYSDATE where exception_object_id = past_appr_addd_ex_rec.exception_object_id;
1148: END LOOP;
1149: IF l_exception_exists = TRUE THEN
1150: UPDATE amw_exceptions_b SET end_date = SYSDATE, approved_flag = 'Y' where exception_object_id = deleted_exceptions_rec.exception_object_id;
1151: END IF;

Line 1150: UPDATE amw_exceptions_b SET end_date = SYSDATE, approved_flag = 'Y' where exception_object_id = deleted_exceptions_rec.exception_object_id;

1146: -- We have an past exception for the opposite action.. So end date that exception...
1147: UPDATE amw_exceptions_b SET end_date = SYSDATE where exception_object_id = past_appr_addd_ex_rec.exception_object_id;
1148: END LOOP;
1149: IF l_exception_exists = TRUE THEN
1150: UPDATE amw_exceptions_b SET end_date = SYSDATE, approved_flag = 'Y' where exception_object_id = deleted_exceptions_rec.exception_object_id;
1151: END IF;
1152: END LOOP;
1153:
1154: -- After end dated those exceptions which have previous exceptions entered.. Approved the remaining excepitons..

Line 1156: UPDATE amw_exceptions_b

1152: END LOOP;
1153:
1154: -- After end dated those exceptions which have previous exceptions entered.. Approved the remaining excepitons..
1155:
1156: UPDATE amw_exceptions_b
1157: SET approved_flag = 'Y'
1158: WHERE end_date is null
1159: AND ( (old_pk1 = p_org_id AND old_pk2 = p_process_id AND transaction_type = 'DEL')
1160: OR (new_pk1 = p_org_id AND new_pk2 = p_process_id AND transaction_type = 'ADD') )