APPS.PAY_IN_INDIA_BENEFITS dependencies on FND_SESSIONS

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

233: pay_in_utils.trace('l_business_group_id',TO_CHAR (l_business_group_id));
234: END IF;
235:
236: BEGIN
237: SELECT 1 INTO l_session FROM fnd_sessions WHERE SESSION_ID = USERENV('SESSIONID') AND ROWNUM=1;
238: EXCEPTION
239: WHEN NO_DATA_FOUND THEN
240: INSERT INTO fnd_sessions(session_id,effective_date) VALUES (USERENV('SESSIONID'),P_ENTRY_DATE);
241: END ;

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

236: BEGIN
237: SELECT 1 INTO l_session FROM fnd_sessions WHERE SESSION_ID = USERENV('SESSIONID') AND ROWNUM=1;
238: EXCEPTION
239: WHEN NO_DATA_FOUND THEN
240: INSERT INTO fnd_sessions(session_id,effective_date) VALUES (USERENV('SESSIONID'),P_ENTRY_DATE);
241: END ;
242:
243:
244: IF ((p_element_entry_id IS NOT NULL))

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

1866:
1867: END IF;
1868:
1869: BEGIN
1870: SELECT 1 INTO l_session FROM fnd_sessions WHERE SESSION_ID = USERENV('SESSIONID') AND ROWNUM=1;
1871: EXCEPTION
1872: WHEN NO_DATA_FOUND THEN
1873: INSERT INTO fnd_sessions(session_id,effective_date) VALUES (USERENV('SESSIONID'),p_start_date);
1874: END ;

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

1869: BEGIN
1870: SELECT 1 INTO l_session FROM fnd_sessions WHERE SESSION_ID = USERENV('SESSIONID') AND ROWNUM=1;
1871: EXCEPTION
1872: WHEN NO_DATA_FOUND THEN
1873: INSERT INTO fnd_sessions(session_id,effective_date) VALUES (USERENV('SESSIONID'),p_start_date);
1874: END ;
1875:
1876: l_business_group_id := pay_in_med_web_adi.get_bg_id();
1877: