APPS.PAY_IN_MED_WEB_ADI dependencies on FND_SESSIONS

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

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

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

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

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

1607: END IF ;
1608:
1609:
1610: BEGIN
1611: SELECT 1 INTO l_session FROM fnd_sessions WHERE SESSION_ID = USERENV('SESSIONID') AND ROWNUM=1;
1612: EXCEPTION
1613: WHEN NO_DATA_FOUND THEN
1614: INSERT INTO fnd_sessions(session_id,effective_date) VALUES (USERENV('SESSIONID'),p_start_date);
1615: END ;

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

1610: BEGIN
1611: SELECT 1 INTO l_session FROM fnd_sessions WHERE SESSION_ID = USERENV('SESSIONID') AND ROWNUM=1;
1612: EXCEPTION
1613: WHEN NO_DATA_FOUND THEN
1614: INSERT INTO fnd_sessions(session_id,effective_date) VALUES (USERENV('SESSIONID'),p_start_date);
1615: END ;
1616:
1617: l_business_group_id := get_bg_id();
1618: