DBA Data[Home] [Help]

APPS.AMW_VIOLATION_PVT dependencies on WF_NOTIFICATION

Line 3343: l_notif_id := WF_NOTIFICATION.send(

3339: FND_MSG_PUB.add;
3340: l_subject := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_LAST,
3341: p_encoded => fnd_api.g_false);
3342:
3343: l_notif_id := WF_NOTIFICATION.send(
3344: role => l_to_role_name,
3345: msg_type => p_item_type,
3346: msg_name => p_message_name);
3347:

Line 3348: WF_NOTIFICATION.SetAttrText(l_notif_id,'VN_MSG_SUBJECT',l_subject);

3344: role => l_to_role_name,
3345: msg_type => p_item_type,
3346: msg_name => p_message_name);
3347:
3348: WF_NOTIFICATION.SetAttrText(l_notif_id,'VN_MSG_SUBJECT',l_subject);
3349: WF_NOTIFICATION.setattrnumber(l_notif_id,'VN_CONSTRAINT_REV_ID',p_constraint_rev_id);
3350: WF_NOTIFICATION.SetAttrText(l_notif_id,'VN_ROLE_NAME',l_role_name);
3351: WF_NOTIFICATION.setattrnumber(l_notif_id,'VN_USER_ID',p_user_id);
3352: WF_NOTIFICATION.setattrnumber(l_notif_id,'VN_ASSIGNED_BY_ID',l_assigned_by_id);

Line 3349: WF_NOTIFICATION.setattrnumber(l_notif_id,'VN_CONSTRAINT_REV_ID',p_constraint_rev_id);

3345: msg_type => p_item_type,
3346: msg_name => p_message_name);
3347:
3348: WF_NOTIFICATION.SetAttrText(l_notif_id,'VN_MSG_SUBJECT',l_subject);
3349: WF_NOTIFICATION.setattrnumber(l_notif_id,'VN_CONSTRAINT_REV_ID',p_constraint_rev_id);
3350: WF_NOTIFICATION.SetAttrText(l_notif_id,'VN_ROLE_NAME',l_role_name);
3351: WF_NOTIFICATION.setattrnumber(l_notif_id,'VN_USER_ID',p_user_id);
3352: WF_NOTIFICATION.setattrnumber(l_notif_id,'VN_ASSIGNED_BY_ID',l_assigned_by_id);
3353:

Line 3350: WF_NOTIFICATION.SetAttrText(l_notif_id,'VN_ROLE_NAME',l_role_name);

3346: msg_name => p_message_name);
3347:
3348: WF_NOTIFICATION.SetAttrText(l_notif_id,'VN_MSG_SUBJECT',l_subject);
3349: WF_NOTIFICATION.setattrnumber(l_notif_id,'VN_CONSTRAINT_REV_ID',p_constraint_rev_id);
3350: WF_NOTIFICATION.SetAttrText(l_notif_id,'VN_ROLE_NAME',l_role_name);
3351: WF_NOTIFICATION.setattrnumber(l_notif_id,'VN_USER_ID',p_user_id);
3352: WF_NOTIFICATION.setattrnumber(l_notif_id,'VN_ASSIGNED_BY_ID',l_assigned_by_id);
3353:
3354: END IF; --end of if: l_to_role_name IS NULL

Line 3351: WF_NOTIFICATION.setattrnumber(l_notif_id,'VN_USER_ID',p_user_id);

3347:
3348: WF_NOTIFICATION.SetAttrText(l_notif_id,'VN_MSG_SUBJECT',l_subject);
3349: WF_NOTIFICATION.setattrnumber(l_notif_id,'VN_CONSTRAINT_REV_ID',p_constraint_rev_id);
3350: WF_NOTIFICATION.SetAttrText(l_notif_id,'VN_ROLE_NAME',l_role_name);
3351: WF_NOTIFICATION.setattrnumber(l_notif_id,'VN_USER_ID',p_user_id);
3352: WF_NOTIFICATION.setattrnumber(l_notif_id,'VN_ASSIGNED_BY_ID',l_assigned_by_id);
3353:
3354: END IF; --end of if: l_to_role_name IS NULL
3355: END LOOP; --end of for: emp_id_list.COUNT

Line 3352: WF_NOTIFICATION.setattrnumber(l_notif_id,'VN_ASSIGNED_BY_ID',l_assigned_by_id);

3348: WF_NOTIFICATION.SetAttrText(l_notif_id,'VN_MSG_SUBJECT',l_subject);
3349: WF_NOTIFICATION.setattrnumber(l_notif_id,'VN_CONSTRAINT_REV_ID',p_constraint_rev_id);
3350: WF_NOTIFICATION.SetAttrText(l_notif_id,'VN_ROLE_NAME',l_role_name);
3351: WF_NOTIFICATION.setattrnumber(l_notif_id,'VN_USER_ID',p_user_id);
3352: WF_NOTIFICATION.setattrnumber(l_notif_id,'VN_ASSIGNED_BY_ID',l_assigned_by_id);
3353:
3354: END IF; --end of if: l_to_role_name IS NULL
3355: END LOOP; --end of for: emp_id_list.COUNT
3356: EXCEPTION