APPS.PAY_AE_SI_REPORTS dependencies on FND_SESSIONS

Line 441: INSERT INTO fnd_sessions (session_id, effective_date)

437:
438: l_input_date := '01-'||p_effective_month||'-'||p_effective_year;
439: l_effective_date := last_day(to_date(l_input_date,'DD-MM-YYYY'));
440:
441: INSERT INTO fnd_sessions (session_id, effective_date)
442: VALUES (userenv('sessionid'), l_effective_date);
443:
444: -- To clear the PL/SQL Table values.
445: t_store_def_bal.DELETE;

Line 1489: INSERT INTO fnd_sessions (session_id, effective_date)

1485: set_currency_mask(p_business_group_id);
1486: l_input_date := '01-'||p_effective_month||'-'||p_effective_year;
1487: l_effective_date := last_day(to_date(l_input_date,'DD-MM-YYYY'));
1488:
1489: INSERT INTO fnd_sessions (session_id, effective_date)
1490: VALUES (userenv('sessionid'), l_effective_date);
1491:
1492: -- To clear the PL/SQL Table values.
1493: vXMLTable.DELETE;

Line 2244: INSERT INTO fnd_sessions (session_id, effective_date)

2240: BEGIN
2241: set_currency_mask(p_business_group_id);
2242: l_input_date := '01-'||p_effective_month||'-'||p_effective_year;
2243: l_effective_date := last_day(to_date(l_input_date,'DD-MM-YYYY'));
2244: INSERT INTO fnd_sessions (session_id, effective_date)
2245: VALUES (userenv('sessionid'), l_effective_date);
2246: hr_utility.set_location('Entering FORM6 ',10);
2247:
2248: /* Fetch Local Nationality */

Line 2914: INSERT INTO fnd_sessions (session_id, effective_date)

2910: BEGIN
2911: set_currency_mask(p_business_group_id);
2912: l_input_date := '01-'||p_effective_month||'-'||p_effective_year;
2913: l_effective_date := last_day(to_date(l_input_date,'DD-MM-YYYY'));
2914: INSERT INTO fnd_sessions (session_id, effective_date)
2915: VALUES (userenv('sessionid'), l_effective_date);
2916: hr_utility.set_location('Entering FORM6 ',10);
2917:
2918: /* Fetch Local Nationality */

Line 3983: INSERT INTO fnd_sessions (session_id, effective_date)

3979: BEGIN
3980: set_currency_mask(p_business_group_id);
3981: l_input_date := '01-'||p_effective_month||'-'||p_effective_year;
3982: l_effective_date := last_day(to_date(l_input_date,'DD-MM-YYYY'));
3983: INSERT INTO fnd_sessions (session_id, effective_date)
3984: VALUES (userenv('sessionid'), l_effective_date);
3985: hr_utility.set_location('Entering FORM6 ',10);
3986:
3987: /* Fetch Local Nationality */

Line 4764: INSERT INTO fnd_sessions (session_id, effective_date)

4760:
4761: set_currency_mask(p_business_group_id);
4762: l_input_date := '01-'||p_effective_month||'-'||p_effective_year;
4763: l_effective_date := last_day(to_date(l_input_date,'DD-MM-YYYY'));
4764: INSERT INTO fnd_sessions (session_id, effective_date)
4765: VALUES (userenv('sessionid'), l_effective_date);
4766: hr_utility.set_location('Entering Monthly Contribution Federal',10);
4767:
4768: /* Fetch Local Nationality */