APPS.PAY_PYAUPYT_XMLP_PKG dependencies on FND_SESSIONS

Line 72: /* Bug 10069164 - Added cursor in order to check existence of record in FND_SESSIONS table. */

68: WHERE HOI.ORGANIZATION_ID = P_LEGAL_EMPLOYER_LP
69: AND HOI.ORG_INFORMATION2 = P_TAX_STATE_LP
70: AND HOI.ORG_INFORMATION_CONTEXT = 'AU_PAYROLL_TAX_DGE';
71:
72: /* Bug 10069164 - Added cursor in order to check existence of record in FND_SESSIONS table. */
73: CURSOR C_SESSION IS
74: SELECT 'X'
75: FROM FND_SESSIONS
76: WHERE SESSION_ID = USERENV('SESSIONID');

Line 75: FROM FND_SESSIONS

71:
72: /* Bug 10069164 - Added cursor in order to check existence of record in FND_SESSIONS table. */
73: CURSOR C_SESSION IS
74: SELECT 'X'
75: FROM FND_SESSIONS
76: WHERE SESSION_ID = USERENV('SESSIONID');
77:
78: L_SESSION_FLAG VARCHAR2(1);
79: BEGIN

Line 167: /* Bug 10069164 - Added code to check existence of record in FND_SESSIONS table in order to

163: CLOSE C_DGE;
164: ELSE
165: CP_DGE := NULL;
166: END IF;
167: /* Bug 10069164 - Added code to check existence of record in FND_SESSIONS table in order to
168: access the Global values in pay_au_paytax_pkg.get_tax function */
169: OPEN C_SESSION;
170: FETCH C_SESSION INTO L_SESSION_FLAG;
171: IF C_SESSION%NOTFOUND THEN

Line 172: INSERT INTO FND_SESSIONS (SESSION_ID, EFFECTIVE_DATE) VALUES (USERENV('SESSIONID'),TRUNC(P_START_DATE));

168: access the Global values in pay_au_paytax_pkg.get_tax function */
169: OPEN C_SESSION;
170: FETCH C_SESSION INTO L_SESSION_FLAG;
171: IF C_SESSION%NOTFOUND THEN
172: INSERT INTO FND_SESSIONS (SESSION_ID, EFFECTIVE_DATE) VALUES (USERENV('SESSIONID'),TRUNC(P_START_DATE));
173: END IF;
174: CLOSE C_SESSION;
175:
176: RETURN (TRUE);