APPS.BEN_LF_EVT_CLPS_RESTORE dependencies on FND_NEW_MESSAGES

Line 2864: l_resnd_cmnt_txt fnd_new_messages.message_text%type;

2860: --
2861: l_object_version_number number;
2862: l_effective_start_date date;
2863: l_effective_end_date date;
2864: l_resnd_cmnt_txt fnd_new_messages.message_text%type;
2865: --
2866: cursor c_per_cm is
2867: select pcd.*
2868: from ben_per_cm_f pcm,

Line 7455: l_resnd_cmnt_txt fnd_new_messages.message_text%type;

7451: l_inter_pil_ovn number;
7452: l_inter_pil_cnt number;
7453: l_inter_per_in_ler_id number;
7454: l_inter_pil_le_dt date;
7455: l_resnd_cmnt_txt fnd_new_messages.message_text%type;
7456: l_bckt_csd_lf_evt_ocrd_dt date;
7457: l_bckt_csd_per_in_ler_id number;
7458:
7459: --

Line 7914: l_resnd_cmnt_txt fnd_new_messages.message_text%type;

7910: l_proc varchar2(72) := g_package||'.p_lf_evt_clps_restore';
7911: l_chages_ocrd_flag varchar2(1);
7912: l_rslt_exist_flag varchar2(1);
7913: l_date date;
7914: l_resnd_cmnt_txt fnd_new_messages.message_text%type;
7915: l_dummy1 VARCHAR2(4000);
7916: l_dummy2 VARCHAR2(4000);
7917: l_schema VARCHAR2(10);
7918: --

Line 10080: l_resnd_cmnt_txt fnd_new_messages.message_text%type;

10076: l_chages_ocrd_flag varchar2(30) := 'N';
10077: l_rslt_exist_flag varchar2(30) := 'N';
10078: l_int_rslts_exist_flag varchar2(30) := 'N';
10079: l_date date;
10080: l_resnd_cmnt_txt fnd_new_messages.message_text%type;
10081: l_reinstate_cd varchar2(30);
10082: l_reinstate_ovrdn_cd varchar2(30);
10083: l_susp_flag boolean ;
10084: l_batch_flag boolean := FALSE ; ---99999 When called from benmngle batch it needs to be TRUE