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.IGC_CBC_INQUIRY_PKG dependencies on GL_PERIODS

Line 4: g_period_name gl_periods.period_name%TYPE;

1: PACKAGE BODY IGC_CBC_INQUIRY_PKG AS
2: /* $Header: IGCINQRB.pls 120.2.12000000.1 2007/08/20 12:15:23 mbremkum ship $ */
3:
4: g_period_name gl_periods.period_name%TYPE;
5: g_period_year gl_periods.period_year%TYPE;
6: g_quarter_num gl_periods.quarter_num%TYPE;
7: g_period_num gl_periods.period_num%TYPE;
8: g_gl_budget_version_id gl_budget_versions.budget_version_id%TYPE;

Line 5: g_period_year gl_periods.period_year%TYPE;

1: PACKAGE BODY IGC_CBC_INQUIRY_PKG AS
2: /* $Header: IGCINQRB.pls 120.2.12000000.1 2007/08/20 12:15:23 mbremkum ship $ */
3:
4: g_period_name gl_periods.period_name%TYPE;
5: g_period_year gl_periods.period_year%TYPE;
6: g_quarter_num gl_periods.quarter_num%TYPE;
7: g_period_num gl_periods.period_num%TYPE;
8: g_gl_budget_version_id gl_budget_versions.budget_version_id%TYPE;
9: g_true VARCHAR2(1);

Line 6: g_quarter_num gl_periods.quarter_num%TYPE;

2: /* $Header: IGCINQRB.pls 120.2.12000000.1 2007/08/20 12:15:23 mbremkum ship $ */
3:
4: g_period_name gl_periods.period_name%TYPE;
5: g_period_year gl_periods.period_year%TYPE;
6: g_quarter_num gl_periods.quarter_num%TYPE;
7: g_period_num gl_periods.period_num%TYPE;
8: g_gl_budget_version_id gl_budget_versions.budget_version_id%TYPE;
9: g_true VARCHAR2(1);
10: g_false VARCHAR2(1);

Line 7: g_period_num gl_periods.period_num%TYPE;

3:
4: g_period_name gl_periods.period_name%TYPE;
5: g_period_year gl_periods.period_year%TYPE;
6: g_quarter_num gl_periods.quarter_num%TYPE;
7: g_period_num gl_periods.period_num%TYPE;
8: g_gl_budget_version_id gl_budget_versions.budget_version_id%TYPE;
9: g_true VARCHAR2(1);
10: g_false VARCHAR2(1);
11:

Line 22: p_period_cutoff IN gl_periods.period_name%TYPE,

18:
19: PROCEDURE Initialize
20: (
21: p_amount_type IN VARCHAR2,
22: p_period_cutoff IN gl_periods.period_name%TYPE,
23: p_set_of_books_id IN gl_period_statuses.set_of_books_id%TYPE,
24: p_gl_budget_version_id IN gl_budget_versions.budget_version_id%TYPE
25: ) IS
26:

Line 29: CURSOR c_gl_periods IS

25: ) IS
26:
27: l_gl_application_id fnd_application.application_id%TYPE;
28:
29: CURSOR c_gl_periods IS
30: SELECT period_name,
31: period_num,
32: quarter_num,
33: period_year

Line 49: OPEN c_gl_periods;

45: INTO l_gl_application_id
46: FROM fnd_application
47: WHERE application_short_name = 'SQLGL';
48:
49: OPEN c_gl_periods;
50: FETCH c_gl_periods INTO g_period_name,g_period_num,g_quarter_num,g_period_year;
51:
52: IF c_gl_periods%NOTFOUND THEN
53: CLOSE c_gl_periods;

Line 50: FETCH c_gl_periods INTO g_period_name,g_period_num,g_quarter_num,g_period_year;

46: FROM fnd_application
47: WHERE application_short_name = 'SQLGL';
48:
49: OPEN c_gl_periods;
50: FETCH c_gl_periods INTO g_period_name,g_period_num,g_quarter_num,g_period_year;
51:
52: IF c_gl_periods%NOTFOUND THEN
53: CLOSE c_gl_periods;
54: raise NO_DATA_FOUND;

Line 52: IF c_gl_periods%NOTFOUND THEN

48:
49: OPEN c_gl_periods;
50: FETCH c_gl_periods INTO g_period_name,g_period_num,g_quarter_num,g_period_year;
51:
52: IF c_gl_periods%NOTFOUND THEN
53: CLOSE c_gl_periods;
54: raise NO_DATA_FOUND;
55: END IF;
56:

Line 53: CLOSE c_gl_periods;

49: OPEN c_gl_periods;
50: FETCH c_gl_periods INTO g_period_name,g_period_num,g_quarter_num,g_period_year;
51:
52: IF c_gl_periods%NOTFOUND THEN
53: CLOSE c_gl_periods;
54: raise NO_DATA_FOUND;
55: END IF;
56:
57: CLOSE c_gl_periods;

Line 57: CLOSE c_gl_periods;

53: CLOSE c_gl_periods;
54: raise NO_DATA_FOUND;
55: END IF;
56:
57: CLOSE c_gl_periods;
58: g_amount_type:=p_amount_type;
59: g_gl_budget_version_id:=p_gl_budget_version_id;
60: g_true :='T';
61: g_false :='F';

Line 67: (p_period_name IN gl_periods.period_name%TYPE,

63: END Initialize;
64:
65:
66: FUNCTION Check_Amount_Type
67: (p_period_name IN gl_periods.period_name%TYPE,
68: p_period_year IN gl_periods.period_year%TYPE,
69: p_quarter_num IN gl_periods.quarter_num%TYPE,
70: p_period_num IN gl_periods.period_num%TYPE,
71: p_actual_flag IN igc_cbc_je_lines.actual_flag%TYPE,

Line 68: p_period_year IN gl_periods.period_year%TYPE,

64:
65:
66: FUNCTION Check_Amount_Type
67: (p_period_name IN gl_periods.period_name%TYPE,
68: p_period_year IN gl_periods.period_year%TYPE,
69: p_quarter_num IN gl_periods.quarter_num%TYPE,
70: p_period_num IN gl_periods.period_num%TYPE,
71: p_actual_flag IN igc_cbc_je_lines.actual_flag%TYPE,
72: p_gl_budget_version_id IN gl_budget_versions.budget_version_id%TYPE

Line 69: p_quarter_num IN gl_periods.quarter_num%TYPE,

65:
66: FUNCTION Check_Amount_Type
67: (p_period_name IN gl_periods.period_name%TYPE,
68: p_period_year IN gl_periods.period_year%TYPE,
69: p_quarter_num IN gl_periods.quarter_num%TYPE,
70: p_period_num IN gl_periods.period_num%TYPE,
71: p_actual_flag IN igc_cbc_je_lines.actual_flag%TYPE,
72: p_gl_budget_version_id IN gl_budget_versions.budget_version_id%TYPE
73: ) RETURN VARCHAR2

Line 70: p_period_num IN gl_periods.period_num%TYPE,

66: FUNCTION Check_Amount_Type
67: (p_period_name IN gl_periods.period_name%TYPE,
68: p_period_year IN gl_periods.period_year%TYPE,
69: p_quarter_num IN gl_periods.quarter_num%TYPE,
70: p_period_num IN gl_periods.period_num%TYPE,
71: p_actual_flag IN igc_cbc_je_lines.actual_flag%TYPE,
72: p_gl_budget_version_id IN gl_budget_versions.budget_version_id%TYPE
73: ) RETURN VARCHAR2
74: IS