APPS.PY_NO_TAX_CARD dependencies on FND_SESSIONS

Line 121: FROM fnd_sessions

117:
118: CURSOR csr_check_fnd_session
119: IS
120: SELECT session_id
121: FROM fnd_sessions
122: WHERE session_id = userenv('sessionid')
123: AND effective_date = p_effective_date;
124:
125: LR_CHECK_FND_SESSION CSR_CHECK_FND_SESSION%ROWTYPE;

Line 131: --Insert row into fnd_Sessions table.

127: BEGIN
128: if g_debug then
129: hr_utility.set_location('Entering:'|| l_proc, 1);
130: end if;
131: --Insert row into fnd_Sessions table.
132: /*INSERT INTO fnd_sessions(session_id,effective_date)
133: VALUES(userenv('sessionid'), p_effective_date);*/
134: --Insert row into fnd_Sessions table.
135: --Pgopal - Moved into a cursor

Line 132: /*INSERT INTO fnd_sessions(session_id,effective_date)

128: if g_debug then
129: hr_utility.set_location('Entering:'|| l_proc, 1);
130: end if;
131: --Insert row into fnd_Sessions table.
132: /*INSERT INTO fnd_sessions(session_id,effective_date)
133: VALUES(userenv('sessionid'), p_effective_date);*/
134: --Insert row into fnd_Sessions table.
135: --Pgopal - Moved into a cursor
136: OPEN csr_check_fnd_session;

Line 134: --Insert row into fnd_Sessions table.

130: end if;
131: --Insert row into fnd_Sessions table.
132: /*INSERT INTO fnd_sessions(session_id,effective_date)
133: VALUES(userenv('sessionid'), p_effective_date);*/
134: --Insert row into fnd_Sessions table.
135: --Pgopal - Moved into a cursor
136: OPEN csr_check_fnd_session;
137: FETCH csr_check_fnd_session INTO lr_check_fnd_session;
138: IF csr_check_fnd_session%NOTFOUND

Line 140: INSERT INTO fnd_sessions(session_id, effective_date) VALUES(userenv('sessionid'), p_effective_date);

136: OPEN csr_check_fnd_session;
137: FETCH csr_check_fnd_session INTO lr_check_fnd_session;
138: IF csr_check_fnd_session%NOTFOUND
139: THEN
140: INSERT INTO fnd_sessions(session_id, effective_date) VALUES(userenv('sessionid'), p_effective_date);
141: END IF;
142: CLOSE csr_check_fnd_session;
143:
144:

Line 331: FROM fnd_sessions

327:
328: CURSOR csr_check_fnd_session
329: IS
330: SELECT session_id
331: FROM fnd_sessions
332: WHERE session_id = userenv('sessionid')
333: AND effective_date = p_effective_date;
334:
335: lr_check_fnd_session csr_check_fnd_session%ROWTYPE;

Line 340: --pgopal - Insert row into fnd_Sessions table.

336: BEGIN
337: if g_debug then
338: hr_utility.set_location('Entering:'|| l_proc, 1);
339: end if;
340: --pgopal - Insert row into fnd_Sessions table.
341: OPEN csr_check_fnd_session;
342: FETCH csr_check_fnd_session INTO lr_check_fnd_session;
343: IF csr_check_fnd_session%NOTFOUND
344: THEN

Line 345: INSERT INTO fnd_sessions(session_id, effective_date) VALUES(userenv('sessionid'), p_effective_date);

341: OPEN csr_check_fnd_session;
342: FETCH csr_check_fnd_session INTO lr_check_fnd_session;
343: IF csr_check_fnd_session%NOTFOUND
344: THEN
345: INSERT INTO fnd_sessions(session_id, effective_date) VALUES(userenv('sessionid'), p_effective_date);
346: END IF;
347: CLOSE csr_check_fnd_session;
348:
349: --l_start_date := sysdate;