APPS.BEN_LF_EVT_CLPS_RESTORE dependencies on FND_NEW_MESSAGES

Line 2634: l_resnd_cmnt_txt fnd_new_messages.message_text%type;

2630: --
2631: l_object_version_number number;
2632: l_effective_start_date date;
2633: l_effective_end_date date;
2634: l_resnd_cmnt_txt fnd_new_messages.message_text%type;
2635: --
2636: cursor c_per_cm is
2637: select pcd.*
2638: from ben_per_cm_f pcm,

Line 7061: l_resnd_cmnt_txt fnd_new_messages.message_text%type;

7057: l_inter_pil_ovn number;
7058: l_inter_pil_cnt number;
7059: l_inter_per_in_ler_id number;
7060: l_inter_pil_le_dt date;
7061: l_resnd_cmnt_txt fnd_new_messages.message_text%type;
7062: l_bckt_csd_lf_evt_ocrd_dt date;
7063: l_bckt_csd_per_in_ler_id number;
7064:
7065: --

Line 7520: l_resnd_cmnt_txt fnd_new_messages.message_text%type;

7516: l_proc varchar2(72) := g_package||'.p_lf_evt_clps_restore';
7517: l_chages_ocrd_flag varchar2(1);
7518: l_rslt_exist_flag varchar2(1);
7519: l_date date;
7520: l_resnd_cmnt_txt fnd_new_messages.message_text%type;
7521: l_dummy1 VARCHAR2(4000);
7522: l_dummy2 VARCHAR2(4000);
7523: l_schema VARCHAR2(10);
7524: --

Line 9158: l_resnd_cmnt_txt fnd_new_messages.message_text%type;

9154: l_chages_ocrd_flag varchar2(30) := 'N';
9155: l_rslt_exist_flag varchar2(30) := 'N';
9156: l_int_rslts_exist_flag varchar2(30) := 'N';
9157: l_date date;
9158: l_resnd_cmnt_txt fnd_new_messages.message_text%type;
9159: l_reinstate_cd varchar2(30);
9160: l_reinstate_ovrdn_cd varchar2(30);
9161: l_susp_flag boolean ;
9162: l_batch_flag boolean := FALSE ; ---99999 When called from benmngle batch it needs to be TRUE