APPS.ARP_CC_PKG dependencies on AR_ACTION_NOTIFICATIONS

Line 397: PROCEDURE insert_f_notifications (p_notification_rec IN ar_action_notifications

393:
394:
395:
396:
397: PROCEDURE insert_f_notifications (p_notification_rec IN ar_action_notifications
398: %rowtype) IS
399: l_notif_id ar_action_notifications.action_notification_id%type;
400:
401: l_created_by number;

Line 399: l_notif_id ar_action_notifications.action_notification_id%type;

395:
396:
397: PROCEDURE insert_f_notifications (p_notification_rec IN ar_action_notifications
398: %rowtype) IS
399: l_notif_id ar_action_notifications.action_notification_id%type;
400:
401: l_created_by number;
402: l_creation_date date;
403: l_last_updated_by number;

Line 419: select ar_action_notifications_s.nextval

415:
416: /*------------------------+
417: | insert the unique id |
418: +-------------------------*/
419: select ar_action_notifications_s.nextval
420: into l_notif_id
421: from dual;
422:
423: /*------------------------+\

Line 427: insert into ar_action_notifications

423: /*------------------------+\
424: | insert the row |
425: +-------------------------*/
426:
427: insert into ar_action_notifications
428: (action_notification_id,
429: last_updated_by,
430: last_update_date,
431: last_update_login,