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 IGC_CBC_JE_LINES

Line 71: p_actual_flag IN igc_cbc_je_lines.actual_flag%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
75: l_ret_status VARCHAR2(1) :=g_false;

Line 131: p_dccid IN igc_cbc_je_lines.code_combination_id%TYPE, -- Detail CCID

127: END Get_Period_Name;
128:
129: FUNCTION Get_FC_Balances(
130: p_mode IN VARCHAR2,
131: p_dccid IN igc_cbc_je_lines.code_combination_id%TYPE, -- Detail CCID
132: p_sob_id IN igc_cbc_je_lines.set_of_books_id%TYPE, -- Set of Books ID
133: p_budget_ver IN igc_cbc_je_lines.budget_version_id%TYPE, -- Budget ID
134: p_period_yr IN igc_cbc_je_lines.period_year%TYPE, -- Period year, ie 2000
135: p_period_nm IN igc_cbc_je_lines.period_num%TYPE, -- Period number

Line 132: p_sob_id IN igc_cbc_je_lines.set_of_books_id%TYPE, -- Set of Books ID

128:
129: FUNCTION Get_FC_Balances(
130: p_mode IN VARCHAR2,
131: p_dccid IN igc_cbc_je_lines.code_combination_id%TYPE, -- Detail CCID
132: p_sob_id IN igc_cbc_je_lines.set_of_books_id%TYPE, -- Set of Books ID
133: p_budget_ver IN igc_cbc_je_lines.budget_version_id%TYPE, -- Budget ID
134: p_period_yr IN igc_cbc_je_lines.period_year%TYPE, -- Period year, ie 2000
135: p_period_nm IN igc_cbc_je_lines.period_num%TYPE, -- Period number
136: p_quarter_nm IN igc_cbc_je_lines.quarter_num%TYPE, -- Quarter number (1-4)

Line 133: p_budget_ver IN igc_cbc_je_lines.budget_version_id%TYPE, -- Budget ID

129: FUNCTION Get_FC_Balances(
130: p_mode IN VARCHAR2,
131: p_dccid IN igc_cbc_je_lines.code_combination_id%TYPE, -- Detail CCID
132: p_sob_id IN igc_cbc_je_lines.set_of_books_id%TYPE, -- Set of Books ID
133: p_budget_ver IN igc_cbc_je_lines.budget_version_id%TYPE, -- Budget ID
134: p_period_yr IN igc_cbc_je_lines.period_year%TYPE, -- Period year, ie 2000
135: p_period_nm IN igc_cbc_je_lines.period_num%TYPE, -- Period number
136: p_quarter_nm IN igc_cbc_je_lines.quarter_num%TYPE, -- Quarter number (1-4)
137: p_batch_id IN igc_cbc_je_lines.cbc_je_batch_id%TYPE,

Line 134: p_period_yr IN igc_cbc_je_lines.period_year%TYPE, -- Period year, ie 2000

130: p_mode IN VARCHAR2,
131: p_dccid IN igc_cbc_je_lines.code_combination_id%TYPE, -- Detail CCID
132: p_sob_id IN igc_cbc_je_lines.set_of_books_id%TYPE, -- Set of Books ID
133: p_budget_ver IN igc_cbc_je_lines.budget_version_id%TYPE, -- Budget ID
134: p_period_yr IN igc_cbc_je_lines.period_year%TYPE, -- Period year, ie 2000
135: p_period_nm IN igc_cbc_je_lines.period_num%TYPE, -- Period number
136: p_quarter_nm IN igc_cbc_je_lines.quarter_num%TYPE, -- Quarter number (1-4)
137: p_batch_id IN igc_cbc_je_lines.cbc_je_batch_id%TYPE,
138: p_actual_flg IN igc_cbc_je_lines.actual_flag%TYPE, --- 'B' or 'E'

Line 135: p_period_nm IN igc_cbc_je_lines.period_num%TYPE, -- Period number

131: p_dccid IN igc_cbc_je_lines.code_combination_id%TYPE, -- Detail CCID
132: p_sob_id IN igc_cbc_je_lines.set_of_books_id%TYPE, -- Set of Books ID
133: p_budget_ver IN igc_cbc_je_lines.budget_version_id%TYPE, -- Budget ID
134: p_period_yr IN igc_cbc_je_lines.period_year%TYPE, -- Period year, ie 2000
135: p_period_nm IN igc_cbc_je_lines.period_num%TYPE, -- Period number
136: p_quarter_nm IN igc_cbc_je_lines.quarter_num%TYPE, -- Quarter number (1-4)
137: p_batch_id IN igc_cbc_je_lines.cbc_je_batch_id%TYPE,
138: p_actual_flg IN igc_cbc_je_lines.actual_flag%TYPE, --- 'B' or 'E'
139: p_enc_type_id IN igc_cbc_je_lines.encumbrance_type_id%TYPE, -- 1000 or 1082

Line 136: p_quarter_nm IN igc_cbc_je_lines.quarter_num%TYPE, -- Quarter number (1-4)

132: p_sob_id IN igc_cbc_je_lines.set_of_books_id%TYPE, -- Set of Books ID
133: p_budget_ver IN igc_cbc_je_lines.budget_version_id%TYPE, -- Budget ID
134: p_period_yr IN igc_cbc_je_lines.period_year%TYPE, -- Period year, ie 2000
135: p_period_nm IN igc_cbc_je_lines.period_num%TYPE, -- Period number
136: p_quarter_nm IN igc_cbc_je_lines.quarter_num%TYPE, -- Quarter number (1-4)
137: p_batch_id IN igc_cbc_je_lines.cbc_je_batch_id%TYPE,
138: p_actual_flg IN igc_cbc_je_lines.actual_flag%TYPE, --- 'B' or 'E'
139: p_enc_type_id IN igc_cbc_je_lines.encumbrance_type_id%TYPE, -- 1000 or 1082
140: p_line_num IN igc_cbc_je_lines.cbc_je_line_num%TYPE

Line 137: p_batch_id IN igc_cbc_je_lines.cbc_je_batch_id%TYPE,

133: p_budget_ver IN igc_cbc_je_lines.budget_version_id%TYPE, -- Budget ID
134: p_period_yr IN igc_cbc_je_lines.period_year%TYPE, -- Period year, ie 2000
135: p_period_nm IN igc_cbc_je_lines.period_num%TYPE, -- Period number
136: p_quarter_nm IN igc_cbc_je_lines.quarter_num%TYPE, -- Quarter number (1-4)
137: p_batch_id IN igc_cbc_je_lines.cbc_je_batch_id%TYPE,
138: p_actual_flg IN igc_cbc_je_lines.actual_flag%TYPE, --- 'B' or 'E'
139: p_enc_type_id IN igc_cbc_je_lines.encumbrance_type_id%TYPE, -- 1000 or 1082
140: p_line_num IN igc_cbc_je_lines.cbc_je_line_num%TYPE
141: )

Line 138: p_actual_flg IN igc_cbc_je_lines.actual_flag%TYPE, --- 'B' or 'E'

134: p_period_yr IN igc_cbc_je_lines.period_year%TYPE, -- Period year, ie 2000
135: p_period_nm IN igc_cbc_je_lines.period_num%TYPE, -- Period number
136: p_quarter_nm IN igc_cbc_je_lines.quarter_num%TYPE, -- Quarter number (1-4)
137: p_batch_id IN igc_cbc_je_lines.cbc_je_batch_id%TYPE,
138: p_actual_flg IN igc_cbc_je_lines.actual_flag%TYPE, --- 'B' or 'E'
139: p_enc_type_id IN igc_cbc_je_lines.encumbrance_type_id%TYPE, -- 1000 or 1082
140: p_line_num IN igc_cbc_je_lines.cbc_je_line_num%TYPE
141: )
142: RETURN NUMBER IS

Line 139: p_enc_type_id IN igc_cbc_je_lines.encumbrance_type_id%TYPE, -- 1000 or 1082

135: p_period_nm IN igc_cbc_je_lines.period_num%TYPE, -- Period number
136: p_quarter_nm IN igc_cbc_je_lines.quarter_num%TYPE, -- Quarter number (1-4)
137: p_batch_id IN igc_cbc_je_lines.cbc_je_batch_id%TYPE,
138: p_actual_flg IN igc_cbc_je_lines.actual_flag%TYPE, --- 'B' or 'E'
139: p_enc_type_id IN igc_cbc_je_lines.encumbrance_type_id%TYPE, -- 1000 or 1082
140: p_line_num IN igc_cbc_je_lines.cbc_je_line_num%TYPE
141: )
142: RETURN NUMBER IS
143:

Line 140: p_line_num IN igc_cbc_je_lines.cbc_je_line_num%TYPE

136: p_quarter_nm IN igc_cbc_je_lines.quarter_num%TYPE, -- Quarter number (1-4)
137: p_batch_id IN igc_cbc_je_lines.cbc_je_batch_id%TYPE,
138: p_actual_flg IN igc_cbc_je_lines.actual_flag%TYPE, --- 'B' or 'E'
139: p_enc_type_id IN igc_cbc_je_lines.encumbrance_type_id%TYPE, -- 1000 or 1082
140: p_line_num IN igc_cbc_je_lines.cbc_je_line_num%TYPE
141: )
142: RETURN NUMBER IS
143:
144: -- Local variables

Line 163: FROM igc_cbc_je_lines JE

159:
160: -- Total the debit balance of the budget from PSB
161: SELECT nvl(sum(entered_dr),0) - nvl(sum(entered_cr),0)
162: INTO l_budget_bal
163: FROM igc_cbc_je_lines JE
164: WHERE JE.actual_flag = 'B' -- 'B' for Budget
165: and JE.code_combination_id = p_dccid
166: and JE.period_year = p_period_yr
167: and JE.set_of_books_id = p_sob_id

Line 183: FROM igc_cbc_je_lines JE

179:
180: -- Total the debit balance of the budget from PSB
181: SELECT nvl(sum(entered_dr),0) - nvl(sum(entered_cr),0)
182: INTO l_budget_bal
183: FROM igc_cbc_je_lines JE
184: WHERE JE.actual_flag = 'B' -- 'B' for Budget
185: and JE.code_combination_id = p_dccid
186: and JE.period_year = p_period_yr
187: and JE.set_of_books_id = p_sob_id

Line 203: FROM igc_cbc_je_lines JE

199:
200: -- Total the debit balance of the budget from PSB
201: SELECT nvl(sum(entered_dr),0) - nvl(sum(entered_cr),0)
202: INTO l_budget_bal
203: FROM igc_cbc_je_lines JE
204: WHERE JE.actual_flag = 'B' -- 'B' for Budget
205: and JE.code_combination_id = p_dccid
206: and JE.period_year = p_period_yr
207: and JE.set_of_books_id = p_sob_id

Line 223: FROM igc_cbc_je_lines JE

219:
220: -- Total the debit balance from the provisional contract commitments
221: SELECT nvl(sum(entered_dr),0) - nvl(sum(entered_cr),0)
222: INTO l_commit_bal
223: FROM igc_cbc_je_lines JE
224: WHERE JE.actual_flag = 'E'
225: and JE.code_combination_id = p_dccid
226: and JE.period_year = p_period_yr
227: and JE.encumbrance_type_id = p_enc_type_id

Line 242: FROM igc_cbc_je_lines JE

238:
239: -- Total the debit balance from the provisional contract commitments
240: SELECT nvl(sum(entered_dr),0) - nvl(sum(entered_cr),0)
241: INTO l_commit_bal
242: FROM igc_cbc_je_lines JE
243: WHERE JE.actual_flag = 'E'
244: and JE.code_combination_id = p_dccid
245: and JE.period_year = p_period_yr
246: and JE.encumbrance_type_id = p_enc_type_id

Line 262: FROM igc_cbc_je_lines JE

258:
259: -- Total the debit balance from the provisional contract commitments
260: SELECT nvl(sum(entered_dr),0) - nvl(sum(entered_cr),0)
261: INTO l_commit_bal
262: FROM igc_cbc_je_lines JE
263: WHERE JE.actual_flag = 'E'
264: and JE.code_combination_id = p_dccid
265: and JE.period_year = p_period_yr
266: and JE.encumbrance_type_id = p_enc_type_id