APPS.PAY_KW_MONTHLY_REPORTS dependencies on FND_SESSIONS

Line 163: INSERT INTO fnd_sessions (session_id, effective_date)

159: set_currency_mask(p_business_group_id);
160: l_input_date := '01-'||p_effective_month||'-'||p_effective_year;
161: l_effective_date := last_day(to_date(l_input_date,'DD-MM-YYYY'));
162: /*l_eff_term_date := to_date('28-'||to_char(l_effective_date,'MM-YYYY'),'DD-MM-YYYY');*/
163: INSERT INTO fnd_sessions (session_id, effective_date)
164: VALUES (userenv('sessionid'), l_effective_date);
165:
166: l_local_nationality := NULL;
167: BEGIN

Line 849: INSERT INTO fnd_sessions (session_id, effective_date)

845: l_fm_asi_value := NULL;
846: l_input_date := '01-'||p_effective_month||'-'||p_effective_year;
847: l_effective_date := last_day(to_date(l_input_date,'DD-MM-YYYY'));
848: /*l_eff_term_date := to_date('28-'||to_char(l_effective_date,'MM-YYYY'),'DD-MM-YYYY');*/
849: INSERT INTO fnd_sessions (session_id, effective_date)
850: VALUES (userenv('sessionid'), l_effective_date);
851:
852: l_user_format := NVL(FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G');
853: l_local_nationality := NULL;

Line 1354: INSERT INTO fnd_sessions (session_id, effective_date)

1350:
1351: l_input_date := '01-'||p_effective_month||'-'||p_effective_year;
1352: l_effective_date := last_day(to_date(l_input_date,'DD-MM-YYYY'));
1353: /*l_eff_term_date := to_date('28-'||to_char(l_effective_date,'MM-YYYY'),'DD-MM-YYYY');*/
1354: INSERT INTO fnd_sessions (session_id, effective_date)
1355: VALUES (userenv('sessionid'), l_effective_date);
1356:
1357: l_user_format := NVL(FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G');
1358: l_local_nationality := NULL;

Line 2011: INSERT INTO fnd_sessions (session_id, effective_date)

2007:
2008: hr_utility.set_location('l_input_date '|| l_input_date,20);
2009: hr_utility.set_location('l_effective_date'|| l_effective_date,30);
2010:
2011: INSERT INTO fnd_sessions (session_id, effective_date)
2012: VALUES (userenv('sessionid'), l_effective_date);
2013:
2014: l_user_format := NVL(FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G');
2015: l_local_nationality := NULL;