DBA Data[Home] [Help]

APPS.ITA_NOTIFICATION_PKG dependencies on WF_NOTIFICATION

Line 479: m_notification_id := WF_NOTIFICATION.Send(

475: FND_MSG_PUB.ADD;
476: return;
477: end if;
478:
479: m_notification_id := WF_NOTIFICATION.Send(
480: role => m_role_name,
481: msg_type => 'AMWGUTIL',
482: msg_name => 'ITA_MESG');
483:

Line 484: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_SUBJECT', m_message_subject);

480: role => m_role_name,
481: msg_type => 'AMWGUTIL',
482: msg_name => 'ITA_MESG');
483:
484: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_SUBJECT', m_message_subject);
485: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_BODY', m_message_body);
486: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_SEND_TO', m_role_name);
487: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_GROUP', p_setup_group);
488: WF_NOTIFICATION.SetAttrText(m_notification_id, 'APPLICATION', p_application);

Line 485: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_BODY', m_message_body);

481: msg_type => 'AMWGUTIL',
482: msg_name => 'ITA_MESG');
483:
484: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_SUBJECT', m_message_subject);
485: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_BODY', m_message_body);
486: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_SEND_TO', m_role_name);
487: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_GROUP', p_setup_group);
488: WF_NOTIFICATION.SetAttrText(m_notification_id, 'APPLICATION', p_application);
489: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG_TYPE', p_org_type);

Line 486: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_SEND_TO', m_role_name);

482: msg_name => 'ITA_MESG');
483:
484: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_SUBJECT', m_message_subject);
485: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_BODY', m_message_body);
486: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_SEND_TO', m_role_name);
487: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_GROUP', p_setup_group);
488: WF_NOTIFICATION.SetAttrText(m_notification_id, 'APPLICATION', p_application);
489: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG_TYPE', p_org_type);
490: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG', p_org);

Line 487: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_GROUP', p_setup_group);

483:
484: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_SUBJECT', m_message_subject);
485: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_BODY', m_message_body);
486: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_SEND_TO', m_role_name);
487: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_GROUP', p_setup_group);
488: WF_NOTIFICATION.SetAttrText(m_notification_id, 'APPLICATION', p_application);
489: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG_TYPE', p_org_type);
490: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG', p_org);
491: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_PARAMETER', p_setup_parameter);

Line 488: WF_NOTIFICATION.SetAttrText(m_notification_id, 'APPLICATION', p_application);

484: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_SUBJECT', m_message_subject);
485: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_BODY', m_message_body);
486: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_SEND_TO', m_role_name);
487: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_GROUP', p_setup_group);
488: WF_NOTIFICATION.SetAttrText(m_notification_id, 'APPLICATION', p_application);
489: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG_TYPE', p_org_type);
490: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG', p_org);
491: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_PARAMETER', p_setup_parameter);
492: WF_NOTIFICATION.SetAttrText(m_notification_id, 'REC_VALUE', p_rec_value);

Line 489: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG_TYPE', p_org_type);

485: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_BODY', m_message_body);
486: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_SEND_TO', m_role_name);
487: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_GROUP', p_setup_group);
488: WF_NOTIFICATION.SetAttrText(m_notification_id, 'APPLICATION', p_application);
489: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG_TYPE', p_org_type);
490: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG', p_org);
491: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_PARAMETER', p_setup_parameter);
492: WF_NOTIFICATION.SetAttrText(m_notification_id, 'REC_VALUE', p_rec_value);
493: WF_NOTIFICATION.SetAttrText(m_notification_id, 'PRIOR_VALUE', p_prior_value);

Line 490: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG', p_org);

486: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_SEND_TO', m_role_name);
487: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_GROUP', p_setup_group);
488: WF_NOTIFICATION.SetAttrText(m_notification_id, 'APPLICATION', p_application);
489: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG_TYPE', p_org_type);
490: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG', p_org);
491: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_PARAMETER', p_setup_parameter);
492: WF_NOTIFICATION.SetAttrText(m_notification_id, 'REC_VALUE', p_rec_value);
493: WF_NOTIFICATION.SetAttrText(m_notification_id, 'PRIOR_VALUE', p_prior_value);
494: WF_NOTIFICATION.SetAttrText(m_notification_id, 'CURRENT_VALUE', p_current_value);

Line 491: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_PARAMETER', p_setup_parameter);

487: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_GROUP', p_setup_group);
488: WF_NOTIFICATION.SetAttrText(m_notification_id, 'APPLICATION', p_application);
489: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG_TYPE', p_org_type);
490: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG', p_org);
491: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_PARAMETER', p_setup_parameter);
492: WF_NOTIFICATION.SetAttrText(m_notification_id, 'REC_VALUE', p_rec_value);
493: WF_NOTIFICATION.SetAttrText(m_notification_id, 'PRIOR_VALUE', p_prior_value);
494: WF_NOTIFICATION.SetAttrText(m_notification_id, 'CURRENT_VALUE', p_current_value);
495: WF_NOTIFICATION.SetAttrText(m_notification_id, 'UPDATED_ON', p_updated_on);

Line 492: WF_NOTIFICATION.SetAttrText(m_notification_id, 'REC_VALUE', p_rec_value);

488: WF_NOTIFICATION.SetAttrText(m_notification_id, 'APPLICATION', p_application);
489: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG_TYPE', p_org_type);
490: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG', p_org);
491: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_PARAMETER', p_setup_parameter);
492: WF_NOTIFICATION.SetAttrText(m_notification_id, 'REC_VALUE', p_rec_value);
493: WF_NOTIFICATION.SetAttrText(m_notification_id, 'PRIOR_VALUE', p_prior_value);
494: WF_NOTIFICATION.SetAttrText(m_notification_id, 'CURRENT_VALUE', p_current_value);
495: WF_NOTIFICATION.SetAttrText(m_notification_id, 'UPDATED_ON', p_updated_on);
496: WF_NOTIFICATION.SetAttrText(m_notification_id, 'UPDATED_BY', p_updated_by);

Line 493: WF_NOTIFICATION.SetAttrText(m_notification_id, 'PRIOR_VALUE', p_prior_value);

489: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG_TYPE', p_org_type);
490: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG', p_org);
491: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_PARAMETER', p_setup_parameter);
492: WF_NOTIFICATION.SetAttrText(m_notification_id, 'REC_VALUE', p_rec_value);
493: WF_NOTIFICATION.SetAttrText(m_notification_id, 'PRIOR_VALUE', p_prior_value);
494: WF_NOTIFICATION.SetAttrText(m_notification_id, 'CURRENT_VALUE', p_current_value);
495: WF_NOTIFICATION.SetAttrText(m_notification_id, 'UPDATED_ON', p_updated_on);
496: WF_NOTIFICATION.SetAttrText(m_notification_id, 'UPDATED_BY', p_updated_by);
497:

Line 494: WF_NOTIFICATION.SetAttrText(m_notification_id, 'CURRENT_VALUE', p_current_value);

490: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG', p_org);
491: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_PARAMETER', p_setup_parameter);
492: WF_NOTIFICATION.SetAttrText(m_notification_id, 'REC_VALUE', p_rec_value);
493: WF_NOTIFICATION.SetAttrText(m_notification_id, 'PRIOR_VALUE', p_prior_value);
494: WF_NOTIFICATION.SetAttrText(m_notification_id, 'CURRENT_VALUE', p_current_value);
495: WF_NOTIFICATION.SetAttrText(m_notification_id, 'UPDATED_ON', p_updated_on);
496: WF_NOTIFICATION.SetAttrText(m_notification_id, 'UPDATED_BY', p_updated_by);
497:
498: WF_NOTIFICATION.Denormalize_Notification(m_notification_id);

Line 495: WF_NOTIFICATION.SetAttrText(m_notification_id, 'UPDATED_ON', p_updated_on);

491: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_PARAMETER', p_setup_parameter);
492: WF_NOTIFICATION.SetAttrText(m_notification_id, 'REC_VALUE', p_rec_value);
493: WF_NOTIFICATION.SetAttrText(m_notification_id, 'PRIOR_VALUE', p_prior_value);
494: WF_NOTIFICATION.SetAttrText(m_notification_id, 'CURRENT_VALUE', p_current_value);
495: WF_NOTIFICATION.SetAttrText(m_notification_id, 'UPDATED_ON', p_updated_on);
496: WF_NOTIFICATION.SetAttrText(m_notification_id, 'UPDATED_BY', p_updated_by);
497:
498: WF_NOTIFICATION.Denormalize_Notification(m_notification_id);
499:

Line 496: WF_NOTIFICATION.SetAttrText(m_notification_id, 'UPDATED_BY', p_updated_by);

492: WF_NOTIFICATION.SetAttrText(m_notification_id, 'REC_VALUE', p_rec_value);
493: WF_NOTIFICATION.SetAttrText(m_notification_id, 'PRIOR_VALUE', p_prior_value);
494: WF_NOTIFICATION.SetAttrText(m_notification_id, 'CURRENT_VALUE', p_current_value);
495: WF_NOTIFICATION.SetAttrText(m_notification_id, 'UPDATED_ON', p_updated_on);
496: WF_NOTIFICATION.SetAttrText(m_notification_id, 'UPDATED_BY', p_updated_by);
497:
498: WF_NOTIFICATION.Denormalize_Notification(m_notification_id);
499:
500: end loop;

Line 498: WF_NOTIFICATION.Denormalize_Notification(m_notification_id);

494: WF_NOTIFICATION.SetAttrText(m_notification_id, 'CURRENT_VALUE', p_current_value);
495: WF_NOTIFICATION.SetAttrText(m_notification_id, 'UPDATED_ON', p_updated_on);
496: WF_NOTIFICATION.SetAttrText(m_notification_id, 'UPDATED_BY', p_updated_by);
497:
498: WF_NOTIFICATION.Denormalize_Notification(m_notification_id);
499:
500: end loop;
501:
502: p_return_status := m_return_status;