APPS.GL_BALANCES_PKG dependencies on GL_BALANCES

Line 1: PACKAGE BODY GL_BALANCES_PKG AS

1: PACKAGE BODY GL_BALANCES_PKG AS
2: /* $Header: gliblncb.pls 120.4 2005/05/05 01:02:55 kvora ship $ */
3:
4:
5: --

Line 20: UPDATE GL_BALANCES bal

16: x_period_name VARCHAR2,
17: x_usage_code VARCHAR2) IS
18: BEGIN
19:
20: UPDATE GL_BALANCES bal
21: SET bal.TRANSLATED_FLAG = 'N',
22: bal.LAST_UPDATE_DATE = SYSDATE,
23: bal.LAST_UPDATED_BY = x_last_updated_by
24: WHERE bal.TRANSLATED_FLAG = 'Y'

Line 49: 'GL_BALANCES_PKG.set_translated_flag');

45: RAISE;
46: WHEN OTHERS THEN
47: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
48: fnd_message.set_token('PROCEDURE',
49: 'GL_BALANCES_PKG.set_translated_flag');
50: RAISE;
51:
52: END set_translated_flag;
53:

Line 65: from GL_BALANCES GLB, GL_LEDGERS GLA,

61: BEGIN
62:
63: select SUM(NVL(PERIOD_NET_DR,0)), SUM(NVL(PERIOD_NET_CR,0))
64: into P_PERIOD_NET_DR, P_PERIOD_NET_CR
65: from GL_BALANCES GLB, GL_LEDGERS GLA,
66: GL_PERIOD_STATUSES GLPS,
67: GL_PERIOD_STATUSES GLPSS, GL_PERIOD_STATUSES GLPSE
68: where GLA.LEDGER_ID = P_LEDGER_ID
69: and GLB.LEDGER_ID = P_LEDGER_ID

Line 88: END GL_BALANCES_PKG;

84: and (GLPSE.PERIOD_YEAR * 10000 + GLPSE.PERIOD_NUM);
85:
86: END gl_get_period_range_activity;
87:
88: END GL_BALANCES_PKG;