APPS.M4U_DMD_REQUESTS dependencies on M4U_DMD_SUBSCRIPTIONS

Line 1167: FROM m4u_dmd_subscriptions

1163: m4u_dmd_utils.log('Update CIS record ',1);
1164: BEGIN
1165: SELECT status
1166: INTO l_cis_status
1167: FROM m4u_dmd_subscriptions
1168: WHERE subscription_name = l_doc_rec.lparameter1;
1169: EXCEPTION
1170: WHEN OTHERS THEN
1171: null;

Line 1194: UPDATE m4u_dmd_subscriptions

1190: l_cis_status := 'DELETE_FAILED';
1191: END IF;
1192: END IF;
1193:
1194: UPDATE m4u_dmd_subscriptions
1195: SET status = l_cis_status
1196: WHERE subscription_name = l_doc_rec.lparameter1;
1197:
1198: m4u_dmd_utils.log('Update SQL%ROWCOUNT - ' ||SQL%rowcount,1);