DBA Data[Home] [Help]

APPS.IGC_CBC_INQUIRY_PKG dependencies on IGC_CBC_JE_LINES

Line 17: p_actual_flag IN igc_cbc_je_lines.actual_flag%TYPE,

13: (p_period_name IN gl_periods.period_name%TYPE,
14: p_period_year IN gl_periods.period_year%TYPE,
15: p_quarter_num IN gl_periods.quarter_num%TYPE,
16: p_period_num IN gl_periods.period_num%TYPE,
17: p_actual_flag IN igc_cbc_je_lines.actual_flag%TYPE,
18: p_gl_budget_version_id IN gl_budget_versions.budget_version_id%TYPE
19: ) RETURN VARCHAR2 ;
20:
21: PRAGMA RESTRICT_REFERENCES(Check_Amount_Type,RNDS,WNDS,WNPS);

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

30: PRAGMA RESTRICT_REFERENCES(Get_Period_Name,RNDS,WNDS,WNPS);
31:
32: FUNCTION Get_FC_Balances(
33: p_mode IN VARCHAR2,
34: p_dccid IN igc_cbc_je_lines.code_combination_id%TYPE, -- Detail CCID
35: p_sob_id IN igc_cbc_je_lines.set_of_books_id%TYPE, -- Set of Books ID
36: p_budget_ver IN igc_cbc_je_lines.budget_version_id%TYPE, -- Budget ID
37: p_period_yr IN igc_cbc_je_lines.period_year%TYPE, -- Period year, ie 2000
38: p_period_nm IN igc_cbc_je_lines.period_num%TYPE, -- Period number

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

31:
32: FUNCTION Get_FC_Balances(
33: p_mode IN VARCHAR2,
34: p_dccid IN igc_cbc_je_lines.code_combination_id%TYPE, -- Detail CCID
35: p_sob_id IN igc_cbc_je_lines.set_of_books_id%TYPE, -- Set of Books ID
36: p_budget_ver IN igc_cbc_je_lines.budget_version_id%TYPE, -- Budget ID
37: p_period_yr IN igc_cbc_je_lines.period_year%TYPE, -- Period year, ie 2000
38: p_period_nm IN igc_cbc_je_lines.period_num%TYPE, -- Period number
39: p_quarter_nm IN igc_cbc_je_lines.quarter_num%TYPE, -- Quarter number (1-4)

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

32: FUNCTION Get_FC_Balances(
33: p_mode IN VARCHAR2,
34: p_dccid IN igc_cbc_je_lines.code_combination_id%TYPE, -- Detail CCID
35: p_sob_id IN igc_cbc_je_lines.set_of_books_id%TYPE, -- Set of Books ID
36: p_budget_ver IN igc_cbc_je_lines.budget_version_id%TYPE, -- Budget ID
37: p_period_yr IN igc_cbc_je_lines.period_year%TYPE, -- Period year, ie 2000
38: p_period_nm IN igc_cbc_je_lines.period_num%TYPE, -- Period number
39: p_quarter_nm IN igc_cbc_je_lines.quarter_num%TYPE, -- Quarter number (1-4)
40: p_batch_id IN igc_cbc_je_lines.cbc_je_batch_id%TYPE,

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

33: p_mode IN VARCHAR2,
34: p_dccid IN igc_cbc_je_lines.code_combination_id%TYPE, -- Detail CCID
35: p_sob_id IN igc_cbc_je_lines.set_of_books_id%TYPE, -- Set of Books ID
36: p_budget_ver IN igc_cbc_je_lines.budget_version_id%TYPE, -- Budget ID
37: p_period_yr IN igc_cbc_je_lines.period_year%TYPE, -- Period year, ie 2000
38: p_period_nm IN igc_cbc_je_lines.period_num%TYPE, -- Period number
39: p_quarter_nm IN igc_cbc_je_lines.quarter_num%TYPE, -- Quarter number (1-4)
40: p_batch_id IN igc_cbc_je_lines.cbc_je_batch_id%TYPE,
41: p_actual_flg IN igc_cbc_je_lines.actual_flag%TYPE, --- 'B' or 'E'

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

34: p_dccid IN igc_cbc_je_lines.code_combination_id%TYPE, -- Detail CCID
35: p_sob_id IN igc_cbc_je_lines.set_of_books_id%TYPE, -- Set of Books ID
36: p_budget_ver IN igc_cbc_je_lines.budget_version_id%TYPE, -- Budget ID
37: p_period_yr IN igc_cbc_je_lines.period_year%TYPE, -- Period year, ie 2000
38: p_period_nm IN igc_cbc_je_lines.period_num%TYPE, -- Period number
39: p_quarter_nm IN igc_cbc_je_lines.quarter_num%TYPE, -- Quarter number (1-4)
40: p_batch_id IN igc_cbc_je_lines.cbc_je_batch_id%TYPE,
41: p_actual_flg IN igc_cbc_je_lines.actual_flag%TYPE, --- 'B' or 'E'
42: p_enc_type_id IN igc_cbc_je_lines.encumbrance_type_id%TYPE, -- 1000 or 1082

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

35: p_sob_id IN igc_cbc_je_lines.set_of_books_id%TYPE, -- Set of Books ID
36: p_budget_ver IN igc_cbc_je_lines.budget_version_id%TYPE, -- Budget ID
37: p_period_yr IN igc_cbc_je_lines.period_year%TYPE, -- Period year, ie 2000
38: p_period_nm IN igc_cbc_je_lines.period_num%TYPE, -- Period number
39: p_quarter_nm IN igc_cbc_je_lines.quarter_num%TYPE, -- Quarter number (1-4)
40: p_batch_id IN igc_cbc_je_lines.cbc_je_batch_id%TYPE,
41: p_actual_flg IN igc_cbc_je_lines.actual_flag%TYPE, --- 'B' or 'E'
42: p_enc_type_id IN igc_cbc_je_lines.encumbrance_type_id%TYPE, -- 1000 or 1082
43: p_line_num IN igc_cbc_je_lines.cbc_je_line_num%TYPE

Line 40: p_batch_id IN igc_cbc_je_lines.cbc_je_batch_id%TYPE,

36: p_budget_ver IN igc_cbc_je_lines.budget_version_id%TYPE, -- Budget ID
37: p_period_yr IN igc_cbc_je_lines.period_year%TYPE, -- Period year, ie 2000
38: p_period_nm IN igc_cbc_je_lines.period_num%TYPE, -- Period number
39: p_quarter_nm IN igc_cbc_je_lines.quarter_num%TYPE, -- Quarter number (1-4)
40: p_batch_id IN igc_cbc_je_lines.cbc_je_batch_id%TYPE,
41: p_actual_flg IN igc_cbc_je_lines.actual_flag%TYPE, --- 'B' or 'E'
42: p_enc_type_id IN igc_cbc_je_lines.encumbrance_type_id%TYPE, -- 1000 or 1082
43: p_line_num IN igc_cbc_je_lines.cbc_je_line_num%TYPE
44: )

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

37: p_period_yr IN igc_cbc_je_lines.period_year%TYPE, -- Period year, ie 2000
38: p_period_nm IN igc_cbc_je_lines.period_num%TYPE, -- Period number
39: p_quarter_nm IN igc_cbc_je_lines.quarter_num%TYPE, -- Quarter number (1-4)
40: p_batch_id IN igc_cbc_je_lines.cbc_je_batch_id%TYPE,
41: p_actual_flg IN igc_cbc_je_lines.actual_flag%TYPE, --- 'B' or 'E'
42: p_enc_type_id IN igc_cbc_je_lines.encumbrance_type_id%TYPE, -- 1000 or 1082
43: p_line_num IN igc_cbc_je_lines.cbc_je_line_num%TYPE
44: )
45: RETURN NUMBER;

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

38: p_period_nm IN igc_cbc_je_lines.period_num%TYPE, -- Period number
39: p_quarter_nm IN igc_cbc_je_lines.quarter_num%TYPE, -- Quarter number (1-4)
40: p_batch_id IN igc_cbc_je_lines.cbc_je_batch_id%TYPE,
41: p_actual_flg IN igc_cbc_je_lines.actual_flag%TYPE, --- 'B' or 'E'
42: p_enc_type_id IN igc_cbc_je_lines.encumbrance_type_id%TYPE, -- 1000 or 1082
43: p_line_num IN igc_cbc_je_lines.cbc_je_line_num%TYPE
44: )
45: RETURN NUMBER;
46: PRAGMA RESTRICT_REFERENCES(Get_FC_Balances,WNDS,WNPS,RNPS);

Line 43: p_line_num IN igc_cbc_je_lines.cbc_je_line_num%TYPE

39: p_quarter_nm IN igc_cbc_je_lines.quarter_num%TYPE, -- Quarter number (1-4)
40: p_batch_id IN igc_cbc_je_lines.cbc_je_batch_id%TYPE,
41: p_actual_flg IN igc_cbc_je_lines.actual_flag%TYPE, --- 'B' or 'E'
42: p_enc_type_id IN igc_cbc_je_lines.encumbrance_type_id%TYPE, -- 1000 or 1082
43: p_line_num IN igc_cbc_je_lines.cbc_je_line_num%TYPE
44: )
45: RETURN NUMBER;
46: PRAGMA RESTRICT_REFERENCES(Get_FC_Balances,WNDS,WNPS,RNPS);
47: