APPS.HR_BIS_ALERTS dependencies on FND_NEW_MESSAGES

Line 1294: l_subject fnd_new_messages.message_text%TYPE;

1290:
1291: l_bmt_name hr_lookups.meaning%TYPE;
1292: l_dummy VARCHAR2(2000);
1293: l_freq_code VARCHAR2(4);
1294: l_subject fnd_new_messages.message_text%TYPE;
1295: l_message VARCHAR2(2000);
1296: l_org_name per_organization_units.name%TYPE;
1297: l_period_name VARCHAR2(50);
1298: l_param VARCHAR2(2000);

Line 1736: l_subject fnd_new_messages.message_text%TYPE;

1732: ,p_actual IN NUMBER
1733: ,p_target_rec IN hri_target_rec_type)
1734: IS
1735:
1736: l_subject fnd_new_messages.message_text%TYPE;
1737: l_message VARCHAR2(2000);
1738: l_freq_code VARCHAR2(4);
1739: l_dummy VARCHAR2(2000);
1740: l_start_date date;

Line 2378: l_subject fnd_new_messages.message_text%TYPE;

2374: ,p_actual IN NUMBER
2375: ,p_target_rec hri_target_rec_type)
2376: IS
2377:
2378: l_subject fnd_new_messages.message_text%TYPE;
2379: l_message VARCHAR2(2000);
2380: l_freq_code VARCHAR2(4);
2381: l_dummy VARCHAR2(2000);
2382: l_param VARCHAR2(2000);

Line 2884: l_subject fnd_new_messages.message_text%TYPE;

2880: ,p_actual IN NUMBER
2881: ,p_target_rec IN hri_target_rec_type)
2882: IS
2883:
2884: l_subject fnd_new_messages.message_text%TYPE;
2885: l_message VARCHAR2(2000);
2886: l_freq_code VARCHAR2(4);
2887: l_periods NUMBER;
2888: l_dummy VARCHAR2(2000);