eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_DEPOSITS_PRCSS dependencies on IGS_LOOKUP_VALUES

Line 46: g_cleared CONSTANT igs_lookup_values.lookup_code%TYPE := 'CLEARED';

42: | Added logic for reversal of Deposit |
43: | related transactions |
44: *=======================================================================*/
45:
46: g_cleared CONSTANT igs_lookup_values.lookup_code%TYPE := 'CLEARED';
47: g_forfeited CONSTANT igs_lookup_values.lookup_code%TYPE := 'FORFEITED';
48: g_transferred CONSTANT igs_lookup_values.lookup_code%TYPE := 'TRANSFERRED';
49: g_reversed CONSTANT igs_lookup_values.lookup_code%TYPE := 'REVERSED';
50: g_deposit CONSTANT igs_lookup_values.lookup_code%TYPE := 'DEPOSIT';

Line 47: g_forfeited CONSTANT igs_lookup_values.lookup_code%TYPE := 'FORFEITED';

43: | related transactions |
44: *=======================================================================*/
45:
46: g_cleared CONSTANT igs_lookup_values.lookup_code%TYPE := 'CLEARED';
47: g_forfeited CONSTANT igs_lookup_values.lookup_code%TYPE := 'FORFEITED';
48: g_transferred CONSTANT igs_lookup_values.lookup_code%TYPE := 'TRANSFERRED';
49: g_reversed CONSTANT igs_lookup_values.lookup_code%TYPE := 'REVERSED';
50: g_deposit CONSTANT igs_lookup_values.lookup_code%TYPE := 'DEPOSIT';
51:

Line 48: g_transferred CONSTANT igs_lookup_values.lookup_code%TYPE := 'TRANSFERRED';

44: *=======================================================================*/
45:
46: g_cleared CONSTANT igs_lookup_values.lookup_code%TYPE := 'CLEARED';
47: g_forfeited CONSTANT igs_lookup_values.lookup_code%TYPE := 'FORFEITED';
48: g_transferred CONSTANT igs_lookup_values.lookup_code%TYPE := 'TRANSFERRED';
49: g_reversed CONSTANT igs_lookup_values.lookup_code%TYPE := 'REVERSED';
50: g_deposit CONSTANT igs_lookup_values.lookup_code%TYPE := 'DEPOSIT';
51:
52:

Line 49: g_reversed CONSTANT igs_lookup_values.lookup_code%TYPE := 'REVERSED';

45:
46: g_cleared CONSTANT igs_lookup_values.lookup_code%TYPE := 'CLEARED';
47: g_forfeited CONSTANT igs_lookup_values.lookup_code%TYPE := 'FORFEITED';
48: g_transferred CONSTANT igs_lookup_values.lookup_code%TYPE := 'TRANSFERRED';
49: g_reversed CONSTANT igs_lookup_values.lookup_code%TYPE := 'REVERSED';
50: g_deposit CONSTANT igs_lookup_values.lookup_code%TYPE := 'DEPOSIT';
51:
52:
53: PROCEDURE forfeit_deposit( p_n_credit_id IN NUMBER,

Line 50: g_deposit CONSTANT igs_lookup_values.lookup_code%TYPE := 'DEPOSIT';

46: g_cleared CONSTANT igs_lookup_values.lookup_code%TYPE := 'CLEARED';
47: g_forfeited CONSTANT igs_lookup_values.lookup_code%TYPE := 'FORFEITED';
48: g_transferred CONSTANT igs_lookup_values.lookup_code%TYPE := 'TRANSFERRED';
49: g_reversed CONSTANT igs_lookup_values.lookup_code%TYPE := 'REVERSED';
50: g_deposit CONSTANT igs_lookup_values.lookup_code%TYPE := 'DEPOSIT';
51:
52:
53: PROCEDURE forfeit_deposit( p_n_credit_id IN NUMBER,
54: p_d_gl_date IN DATE,

Line 256: CURSOR cur_lookup_code (cp_reversal_code IN igs_lookup_values.lookup_code%TYPE) IS

252: --schodava 11-Jun-03 Enh # 2831587. Modified the Credits table update_row call
253: --schodava 4-Dec-2002 Enh # 2584741 - Deposits Build
254: -------------------------------------------------------------------
255:
256: CURSOR cur_lookup_code (cp_reversal_code IN igs_lookup_values.lookup_code%TYPE) IS
257: SELECT 'X'
258: FROM igs_lookup_values
259: WHERE lookup_type = 'IGS_FI_REVERSAL_REASON'
260: AND lookup_code = cp_reversal_code

Line 258: FROM igs_lookup_values

254: -------------------------------------------------------------------
255:
256: CURSOR cur_lookup_code (cp_reversal_code IN igs_lookup_values.lookup_code%TYPE) IS
257: SELECT 'X'
258: FROM igs_lookup_values
259: WHERE lookup_type = 'IGS_FI_REVERSAL_REASON'
260: AND lookup_code = cp_reversal_code
261: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active,SYSDATE)) AND TRUNC(NVL(end_date_active, SYSDATE))
262: AND NVL(enabled_flag,'N') = 'Y';