APPS.PQH_COMMITMENT_PKG dependencies on FND_SESSIONS

Line 1294: * Insert row into fnd_sessions to allow use of global values

1290: hr_utility.set_location ('Entering: '||l_proc,05);
1291: --
1292: begin
1293: /*
1294: * Insert row into fnd_sessions to allow use of global values
1295: */
1296: insert into fnd_sessions (session_id, effective_date) values (userenv('sessionid'),trunc(sysdate));
1297: exception
1298: when others then null;

Line 1296: insert into fnd_sessions (session_id, effective_date) values (userenv('sessionid'),trunc(sysdate));

1292: begin
1293: /*
1294: * Insert row into fnd_sessions to allow use of global values
1295: */
1296: insert into fnd_sessions (session_id, effective_date) values (userenv('sessionid'),trunc(sysdate));
1297: exception
1298: when others then null;
1299: end;
1300: --

Line 3145: -- Get_Table_Value requires row in FND_SESSIONS. We must insert this

3141: hr_utility.set_location('work_schedule_total_hours', 7);
3142: RETURN v_total_hours;
3143: END IF;
3144: --
3145: -- Get_Table_Value requires row in FND_SESSIONS. We must insert this
3146: -- record if one doe not already exist.
3147: --
3148: SELECT DECODE(COUNT(session_id), 0, 'N', 'Y')
3149: INTO v_fnd_sess_row

Line 3150: FROM fnd_sessions

3146: -- record if one doe not already exist.
3147: --
3148: SELECT DECODE(COUNT(session_id), 0, 'N', 'Y')
3149: INTO v_fnd_sess_row
3150: FROM fnd_sessions
3151: WHERE session_id = userenv('sessionid');
3152: --
3153: IF v_fnd_sess_row = 'N' THEN
3154: insert into fnd_sessions (session_id, effective_date) values(userenv('sessionid'),trunc(sysdate));

Line 3154: insert into fnd_sessions (session_id, effective_date) values(userenv('sessionid'),trunc(sysdate));

3150: FROM fnd_sessions
3151: WHERE session_id = userenv('sessionid');
3152: --
3153: IF v_fnd_sess_row = 'N' THEN
3154: insert into fnd_sessions (session_id, effective_date) values(userenv('sessionid'),trunc(sysdate));
3155: END IF;
3156: --
3157: -- Track range dates:
3158: hr_utility.set_location('range start = '||to_char(v_range_start), 5);