APPS.PAY_IN_INDIA_BENEFITS dependencies on FND_SESSIONS

Line 245: SELECT 1 INTO l_session FROM fnd_sessions WHERE SESSION_ID = USERENV('SESSIONID') AND ROWNUM=1;

241: pay_in_utils.trace('l_business_group_id',TO_CHAR (l_business_group_id));
242: END IF;
243:
244: BEGIN
245: SELECT 1 INTO l_session FROM fnd_sessions WHERE SESSION_ID = USERENV('SESSIONID') AND ROWNUM=1;
246: EXCEPTION
247: WHEN NO_DATA_FOUND THEN
248: INSERT INTO fnd_sessions(session_id,effective_date) VALUES (USERENV('SESSIONID'),P_ENTRY_DATE);
249: END ;

Line 248: INSERT INTO fnd_sessions(session_id,effective_date) VALUES (USERENV('SESSIONID'),P_ENTRY_DATE);

244: BEGIN
245: SELECT 1 INTO l_session FROM fnd_sessions WHERE SESSION_ID = USERENV('SESSIONID') AND ROWNUM=1;
246: EXCEPTION
247: WHEN NO_DATA_FOUND THEN
248: INSERT INTO fnd_sessions(session_id,effective_date) VALUES (USERENV('SESSIONID'),P_ENTRY_DATE);
249: END ;
250:
251:
252: IF ((p_element_entry_id IS NOT NULL))

Line 1944: SELECT 1 INTO l_session FROM fnd_sessions WHERE SESSION_ID = USERENV('SESSIONID') AND ROWNUM=1;

1940:
1941: END IF;
1942:
1943: BEGIN
1944: SELECT 1 INTO l_session FROM fnd_sessions WHERE SESSION_ID = USERENV('SESSIONID') AND ROWNUM=1;
1945: EXCEPTION
1946: WHEN NO_DATA_FOUND THEN
1947: INSERT INTO fnd_sessions(session_id,effective_date) VALUES (USERENV('SESSIONID'),p_start_date);
1948: END ;

Line 1947: INSERT INTO fnd_sessions(session_id,effective_date) VALUES (USERENV('SESSIONID'),p_start_date);

1943: BEGIN
1944: SELECT 1 INTO l_session FROM fnd_sessions WHERE SESSION_ID = USERENV('SESSIONID') AND ROWNUM=1;
1945: EXCEPTION
1946: WHEN NO_DATA_FOUND THEN
1947: INSERT INTO fnd_sessions(session_id,effective_date) VALUES (USERENV('SESSIONID'),p_start_date);
1948: END ;
1949:
1950: l_business_group_id := pay_in_med_web_adi.get_bg_id();
1951: