APPS.PAY_IN_MED_WEB_ADI dependencies on FND_SESSIONS

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

1162: pay_in_utils.trace('l_business_group_id',TO_CHAR (l_business_group_id));
1163: END IF;
1164:
1165: BEGIN
1166: SELECT 1 INTO l_session FROM fnd_sessions WHERE SESSION_ID = USERENV('SESSIONID') AND ROWNUM=1;
1167: EXCEPTION
1168: WHEN NO_DATA_FOUND THEN
1169: INSERT INTO fnd_sessions(session_id,effective_date) VALUES (USERENV('SESSIONID'),P_ENTRY_DATE);
1170: END ;

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

1165: BEGIN
1166: SELECT 1 INTO l_session FROM fnd_sessions WHERE SESSION_ID = USERENV('SESSIONID') AND ROWNUM=1;
1167: EXCEPTION
1168: WHEN NO_DATA_FOUND THEN
1169: INSERT INTO fnd_sessions(session_id,effective_date) VALUES (USERENV('SESSIONID'),P_ENTRY_DATE);
1170: END ;
1171:
1172:
1173: IF ((p_element_entry_id IS NOT NULL))

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

1595: END IF ;
1596:
1597:
1598: BEGIN
1599: SELECT 1 INTO l_session FROM fnd_sessions WHERE SESSION_ID = USERENV('SESSIONID') AND ROWNUM=1;
1600: EXCEPTION
1601: WHEN NO_DATA_FOUND THEN
1602: INSERT INTO fnd_sessions(session_id,effective_date) VALUES (USERENV('SESSIONID'),p_start_date);
1603: END ;

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

1598: BEGIN
1599: SELECT 1 INTO l_session FROM fnd_sessions WHERE SESSION_ID = USERENV('SESSIONID') AND ROWNUM=1;
1600: EXCEPTION
1601: WHEN NO_DATA_FOUND THEN
1602: INSERT INTO fnd_sessions(session_id,effective_date) VALUES (USERENV('SESSIONID'),p_start_date);
1603: END ;
1604:
1605: l_business_group_id := get_bg_id();
1606: