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.UMX_NOTIFICATION_UTIL dependencies on WF_ACTIVITY_ATTRIBUTES

Line 218: l_ame_transaction_type_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

214: activity_id in number,
215: command in varchar2,
216: resultout out NOCOPY varchar2) IS
217:
218: l_ame_transaction_type_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
219: l_ame_application_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
220: l_reg_request_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
221: l_approver_name fnd_user.USER_NAME%TYPE;
222: l_display_name wf_users.display_name%type;

Line 219: l_ame_application_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

215: command in varchar2,
216: resultout out NOCOPY varchar2) IS
217:
218: l_ame_transaction_type_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
219: l_ame_application_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
220: l_reg_request_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
221: l_approver_name fnd_user.USER_NAME%TYPE;
222: l_display_name wf_users.display_name%type;
223: l_next_approver ame_util.approverRecord2;

Line 220: l_reg_request_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

216: resultout out NOCOPY varchar2) IS
217:
218: l_ame_transaction_type_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
219: l_ame_application_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
220: l_reg_request_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
221: l_approver_name fnd_user.USER_NAME%TYPE;
222: l_display_name wf_users.display_name%type;
223: l_next_approver ame_util.approverRecord2;
224: l_requested_for_user_id fnd_user.user_id%type;

Line 228: l_person_first_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

224: l_requested_for_user_id fnd_user.user_id%type;
225: l_registration_data wf_event_t;
226: l_requested_for_party_id hz_parties.party_id%type;
227: l_user_role_name wf_local_roles.name%type;
228: l_person_first_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
229: l_person_last_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
230: l_person_middle_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
231: l_prefix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
232: l_suffix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

Line 229: l_person_last_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

225: l_registration_data wf_event_t;
226: l_requested_for_party_id hz_parties.party_id%type;
227: l_user_role_name wf_local_roles.name%type;
228: l_person_first_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
229: l_person_last_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
230: l_person_middle_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
231: l_prefix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
232: l_suffix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
233: l_return_status varchar2 (10);

Line 230: l_person_middle_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

226: l_requested_for_party_id hz_parties.party_id%type;
227: l_user_role_name wf_local_roles.name%type;
228: l_person_first_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
229: l_person_last_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
230: l_person_middle_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
231: l_prefix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
232: l_suffix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
233: l_return_status varchar2 (10);
234: l_requester_email_address fnd_user.email_address%type;

Line 231: l_prefix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

227: l_user_role_name wf_local_roles.name%type;
228: l_person_first_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
229: l_person_last_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
230: l_person_middle_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
231: l_prefix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
232: l_suffix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
233: l_return_status varchar2 (10);
234: l_requester_email_address fnd_user.email_address%type;
235: l_role_display_name wf_local_roles.display_name%type;

Line 232: l_suffix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

228: l_person_first_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
229: l_person_last_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
230: l_person_middle_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
231: l_prefix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
232: l_suffix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
233: l_return_status varchar2 (10);
234: l_requester_email_address fnd_user.email_address%type;
235: l_role_display_name wf_local_roles.display_name%type;
236: l_reg_service_type WF_ACTIVITY_ATTRIBUTES.text_default%type;

Line 236: l_reg_service_type WF_ACTIVITY_ATTRIBUTES.text_default%type;

232: l_suffix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
233: l_return_status varchar2 (10);
234: l_requester_email_address fnd_user.email_address%type;
235: l_role_display_name wf_local_roles.display_name%type;
236: l_reg_service_type WF_ACTIVITY_ATTRIBUTES.text_default%type;
237:
238: l_msg_count number;
239: l_msg_data varchar2 (280);
240: l_formatted_lines_cnt number;

Line 472: --l_context WF_ACTIVITY_ATTRIBUTES.text_default%type;

468: activity_id in number,
469: command in varchar2,
470: resultout out NOCOPY varchar2) is
471:
472: --l_context WF_ACTIVITY_ATTRIBUTES.text_default%type;
473: l_display_name varchar2 (100);
474: l_first_name WF_ACTIVITY_ATTRIBUTES.text_default%type;
475: l_last_name WF_ACTIVITY_ATTRIBUTES.text_default%type;
476: l_middle_name WF_ACTIVITY_ATTRIBUTES.text_default%type;

Line 474: l_first_name WF_ACTIVITY_ATTRIBUTES.text_default%type;

470: resultout out NOCOPY varchar2) is
471:
472: --l_context WF_ACTIVITY_ATTRIBUTES.text_default%type;
473: l_display_name varchar2 (100);
474: l_first_name WF_ACTIVITY_ATTRIBUTES.text_default%type;
475: l_last_name WF_ACTIVITY_ATTRIBUTES.text_default%type;
476: l_middle_name WF_ACTIVITY_ATTRIBUTES.text_default%type;
477: l_suffix WF_ACTIVITY_ATTRIBUTES.text_default%type;
478: l_prefix WF_ACTIVITY_ATTRIBUTES.text_default%type;

Line 475: l_last_name WF_ACTIVITY_ATTRIBUTES.text_default%type;

471:
472: --l_context WF_ACTIVITY_ATTRIBUTES.text_default%type;
473: l_display_name varchar2 (100);
474: l_first_name WF_ACTIVITY_ATTRIBUTES.text_default%type;
475: l_last_name WF_ACTIVITY_ATTRIBUTES.text_default%type;
476: l_middle_name WF_ACTIVITY_ATTRIBUTES.text_default%type;
477: l_suffix WF_ACTIVITY_ATTRIBUTES.text_default%type;
478: l_prefix WF_ACTIVITY_ATTRIBUTES.text_default%type;
479: l_requested_for_user_id WF_ACTIVITY_ATTRIBUTES.text_default%type;

Line 476: l_middle_name WF_ACTIVITY_ATTRIBUTES.text_default%type;

472: --l_context WF_ACTIVITY_ATTRIBUTES.text_default%type;
473: l_display_name varchar2 (100);
474: l_first_name WF_ACTIVITY_ATTRIBUTES.text_default%type;
475: l_last_name WF_ACTIVITY_ATTRIBUTES.text_default%type;
476: l_middle_name WF_ACTIVITY_ATTRIBUTES.text_default%type;
477: l_suffix WF_ACTIVITY_ATTRIBUTES.text_default%type;
478: l_prefix WF_ACTIVITY_ATTRIBUTES.text_default%type;
479: l_requested_for_user_id WF_ACTIVITY_ATTRIBUTES.text_default%type;
480: l_username WF_ACTIVITY_ATTRIBUTES.text_default%type;

Line 477: l_suffix WF_ACTIVITY_ATTRIBUTES.text_default%type;

473: l_display_name varchar2 (100);
474: l_first_name WF_ACTIVITY_ATTRIBUTES.text_default%type;
475: l_last_name WF_ACTIVITY_ATTRIBUTES.text_default%type;
476: l_middle_name WF_ACTIVITY_ATTRIBUTES.text_default%type;
477: l_suffix WF_ACTIVITY_ATTRIBUTES.text_default%type;
478: l_prefix WF_ACTIVITY_ATTRIBUTES.text_default%type;
479: l_requested_for_user_id WF_ACTIVITY_ATTRIBUTES.text_default%type;
480: l_username WF_ACTIVITY_ATTRIBUTES.text_default%type;
481: l_email_address WF_ACTIVITY_ATTRIBUTES.text_default%type;

Line 478: l_prefix WF_ACTIVITY_ATTRIBUTES.text_default%type;

474: l_first_name WF_ACTIVITY_ATTRIBUTES.text_default%type;
475: l_last_name WF_ACTIVITY_ATTRIBUTES.text_default%type;
476: l_middle_name WF_ACTIVITY_ATTRIBUTES.text_default%type;
477: l_suffix WF_ACTIVITY_ATTRIBUTES.text_default%type;
478: l_prefix WF_ACTIVITY_ATTRIBUTES.text_default%type;
479: l_requested_for_user_id WF_ACTIVITY_ATTRIBUTES.text_default%type;
480: l_username WF_ACTIVITY_ATTRIBUTES.text_default%type;
481: l_email_address WF_ACTIVITY_ATTRIBUTES.text_default%type;
482: l_primary_phone WF_ACTIVITY_ATTRIBUTES.text_default%type;

Line 479: l_requested_for_user_id WF_ACTIVITY_ATTRIBUTES.text_default%type;

475: l_last_name WF_ACTIVITY_ATTRIBUTES.text_default%type;
476: l_middle_name WF_ACTIVITY_ATTRIBUTES.text_default%type;
477: l_suffix WF_ACTIVITY_ATTRIBUTES.text_default%type;
478: l_prefix WF_ACTIVITY_ATTRIBUTES.text_default%type;
479: l_requested_for_user_id WF_ACTIVITY_ATTRIBUTES.text_default%type;
480: l_username WF_ACTIVITY_ATTRIBUTES.text_default%type;
481: l_email_address WF_ACTIVITY_ATTRIBUTES.text_default%type;
482: l_primary_phone WF_ACTIVITY_ATTRIBUTES.text_default%type;
483: l_phone_area_code WF_ACTIVITY_ATTRIBUTES.text_default%type;

Line 480: l_username WF_ACTIVITY_ATTRIBUTES.text_default%type;

476: l_middle_name WF_ACTIVITY_ATTRIBUTES.text_default%type;
477: l_suffix WF_ACTIVITY_ATTRIBUTES.text_default%type;
478: l_prefix WF_ACTIVITY_ATTRIBUTES.text_default%type;
479: l_requested_for_user_id WF_ACTIVITY_ATTRIBUTES.text_default%type;
480: l_username WF_ACTIVITY_ATTRIBUTES.text_default%type;
481: l_email_address WF_ACTIVITY_ATTRIBUTES.text_default%type;
482: l_primary_phone WF_ACTIVITY_ATTRIBUTES.text_default%type;
483: l_phone_area_code WF_ACTIVITY_ATTRIBUTES.text_default%type;
484: l_phone_country_code WF_ACTIVITY_ATTRIBUTES.text_default%type;

Line 481: l_email_address WF_ACTIVITY_ATTRIBUTES.text_default%type;

477: l_suffix WF_ACTIVITY_ATTRIBUTES.text_default%type;
478: l_prefix WF_ACTIVITY_ATTRIBUTES.text_default%type;
479: l_requested_for_user_id WF_ACTIVITY_ATTRIBUTES.text_default%type;
480: l_username WF_ACTIVITY_ATTRIBUTES.text_default%type;
481: l_email_address WF_ACTIVITY_ATTRIBUTES.text_default%type;
482: l_primary_phone WF_ACTIVITY_ATTRIBUTES.text_default%type;
483: l_phone_area_code WF_ACTIVITY_ATTRIBUTES.text_default%type;
484: l_phone_country_code WF_ACTIVITY_ATTRIBUTES.text_default%type;
485: l_justification WF_ACTIVITY_ATTRIBUTES.text_default%type;

Line 482: l_primary_phone WF_ACTIVITY_ATTRIBUTES.text_default%type;

478: l_prefix WF_ACTIVITY_ATTRIBUTES.text_default%type;
479: l_requested_for_user_id WF_ACTIVITY_ATTRIBUTES.text_default%type;
480: l_username WF_ACTIVITY_ATTRIBUTES.text_default%type;
481: l_email_address WF_ACTIVITY_ATTRIBUTES.text_default%type;
482: l_primary_phone WF_ACTIVITY_ATTRIBUTES.text_default%type;
483: l_phone_area_code WF_ACTIVITY_ATTRIBUTES.text_default%type;
484: l_phone_country_code WF_ACTIVITY_ATTRIBUTES.text_default%type;
485: l_justification WF_ACTIVITY_ATTRIBUTES.text_default%type;
486: l_reg_service_type WF_ACTIVITY_ATTRIBUTES.text_default%type;

Line 483: l_phone_area_code WF_ACTIVITY_ATTRIBUTES.text_default%type;

479: l_requested_for_user_id WF_ACTIVITY_ATTRIBUTES.text_default%type;
480: l_username WF_ACTIVITY_ATTRIBUTES.text_default%type;
481: l_email_address WF_ACTIVITY_ATTRIBUTES.text_default%type;
482: l_primary_phone WF_ACTIVITY_ATTRIBUTES.text_default%type;
483: l_phone_area_code WF_ACTIVITY_ATTRIBUTES.text_default%type;
484: l_phone_country_code WF_ACTIVITY_ATTRIBUTES.text_default%type;
485: l_justification WF_ACTIVITY_ATTRIBUTES.text_default%type;
486: l_reg_service_type WF_ACTIVITY_ATTRIBUTES.text_default%type;
487: l_mins WF_ACTIVITY_ATTRIBUTES.number_default%type;

Line 484: l_phone_country_code WF_ACTIVITY_ATTRIBUTES.text_default%type;

480: l_username WF_ACTIVITY_ATTRIBUTES.text_default%type;
481: l_email_address WF_ACTIVITY_ATTRIBUTES.text_default%type;
482: l_primary_phone WF_ACTIVITY_ATTRIBUTES.text_default%type;
483: l_phone_area_code WF_ACTIVITY_ATTRIBUTES.text_default%type;
484: l_phone_country_code WF_ACTIVITY_ATTRIBUTES.text_default%type;
485: l_justification WF_ACTIVITY_ATTRIBUTES.text_default%type;
486: l_reg_service_type WF_ACTIVITY_ATTRIBUTES.text_default%type;
487: l_mins WF_ACTIVITY_ATTRIBUTES.number_default%type;
488: l_days WF_ACTIVITY_ATTRIBUTES.number_default%type;

Line 485: l_justification WF_ACTIVITY_ATTRIBUTES.text_default%type;

481: l_email_address WF_ACTIVITY_ATTRIBUTES.text_default%type;
482: l_primary_phone WF_ACTIVITY_ATTRIBUTES.text_default%type;
483: l_phone_area_code WF_ACTIVITY_ATTRIBUTES.text_default%type;
484: l_phone_country_code WF_ACTIVITY_ATTRIBUTES.text_default%type;
485: l_justification WF_ACTIVITY_ATTRIBUTES.text_default%type;
486: l_reg_service_type WF_ACTIVITY_ATTRIBUTES.text_default%type;
487: l_mins WF_ACTIVITY_ATTRIBUTES.number_default%type;
488: l_days WF_ACTIVITY_ATTRIBUTES.number_default%type;
489: l_registration_data wf_event_t;

Line 486: l_reg_service_type WF_ACTIVITY_ATTRIBUTES.text_default%type;

482: l_primary_phone WF_ACTIVITY_ATTRIBUTES.text_default%type;
483: l_phone_area_code WF_ACTIVITY_ATTRIBUTES.text_default%type;
484: l_phone_country_code WF_ACTIVITY_ATTRIBUTES.text_default%type;
485: l_justification WF_ACTIVITY_ATTRIBUTES.text_default%type;
486: l_reg_service_type WF_ACTIVITY_ATTRIBUTES.text_default%type;
487: l_mins WF_ACTIVITY_ATTRIBUTES.number_default%type;
488: l_days WF_ACTIVITY_ATTRIBUTES.number_default%type;
489: l_registration_data wf_event_t;
490: l_person_party_id hz_parties.party_id%type;

Line 487: l_mins WF_ACTIVITY_ATTRIBUTES.number_default%type;

483: l_phone_area_code WF_ACTIVITY_ATTRIBUTES.text_default%type;
484: l_phone_country_code WF_ACTIVITY_ATTRIBUTES.text_default%type;
485: l_justification WF_ACTIVITY_ATTRIBUTES.text_default%type;
486: l_reg_service_type WF_ACTIVITY_ATTRIBUTES.text_default%type;
487: l_mins WF_ACTIVITY_ATTRIBUTES.number_default%type;
488: l_days WF_ACTIVITY_ATTRIBUTES.number_default%type;
489: l_registration_data wf_event_t;
490: l_person_party_id hz_parties.party_id%type;
491:

Line 488: l_days WF_ACTIVITY_ATTRIBUTES.number_default%type;

484: l_phone_country_code WF_ACTIVITY_ATTRIBUTES.text_default%type;
485: l_justification WF_ACTIVITY_ATTRIBUTES.text_default%type;
486: l_reg_service_type WF_ACTIVITY_ATTRIBUTES.text_default%type;
487: l_mins WF_ACTIVITY_ATTRIBUTES.number_default%type;
488: l_days WF_ACTIVITY_ATTRIBUTES.number_default%type;
489: l_registration_data wf_event_t;
490: l_person_party_id hz_parties.party_id%type;
491:
492: x_return_status varchar2 (10);

Line 736: l_ame_transaction_type_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

732: activity_id in number,
733: command in varchar2,
734: resultout out NOCOPY varchar2) IS
735:
736: l_ame_transaction_type_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
737: l_ame_application_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
738: l_reg_request_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
739: l_current_approver ame_util.approverRecord2;
740:

Line 737: l_ame_application_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

733: command in varchar2,
734: resultout out NOCOPY varchar2) IS
735:
736: l_ame_transaction_type_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
737: l_ame_application_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
738: l_reg_request_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
739: l_current_approver ame_util.approverRecord2;
740:
741: BEGIN

Line 738: l_reg_request_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

734: resultout out NOCOPY varchar2) IS
735:
736: l_ame_transaction_type_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
737: l_ame_application_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
738: l_reg_request_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
739: l_current_approver ame_util.approverRecord2;
740:
741: BEGIN
742:

Line 818: l_ame_transaction_type_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

814: activity_id in number,
815: command in varchar2,
816: resultout out NOCOPY varchar2) IS
817:
818: l_ame_transaction_type_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
819: l_ame_application_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
820: l_reg_request_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
821: l_rejection_reason WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
822: l_current_approver ame_util.approverRecord2;

Line 819: l_ame_application_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

815: command in varchar2,
816: resultout out NOCOPY varchar2) IS
817:
818: l_ame_transaction_type_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
819: l_ame_application_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
820: l_reg_request_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
821: l_rejection_reason WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
822: l_current_approver ame_util.approverRecord2;
823: l_event wf_event_t;

Line 820: l_reg_request_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

816: resultout out NOCOPY varchar2) IS
817:
818: l_ame_transaction_type_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
819: l_ame_application_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
820: l_reg_request_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
821: l_rejection_reason WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
822: l_current_approver ame_util.approverRecord2;
823: l_event wf_event_t;
824: l_status varchar2 (15);

Line 821: l_rejection_reason WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

817:
818: l_ame_transaction_type_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
819: l_ame_application_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
820: l_reg_request_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
821: l_rejection_reason WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
822: l_current_approver ame_util.approverRecord2;
823: l_event wf_event_t;
824: l_status varchar2 (15);
825: