DBA Data[Home] [Help]

APPS.HR_JPBP_API dependencies on PER_ANALYSIS_CRITERIA

Line 14: p_school_id in out nocopy per_analysis_criteria.segment2%TYPE,

10: -- |----------------------------------------|
11: -- ----------------------------------------------------------------------------
12:
13: procedure chk_school_id_school_name_comb(
14: p_school_id in out nocopy per_analysis_criteria.segment2%TYPE,
15: p_school_name in out nocopy per_analysis_criteria.segment3%TYPE,
16: p_school_name_kana in out nocopy per_analysis_criteria.segment4%TYPE,
17: p_major in out nocopy per_analysis_criteria.segment5%TYPE,
18: p_major_kana in out nocopy per_analysis_criteria.segment6%TYPE) is

Line 15: p_school_name in out nocopy per_analysis_criteria.segment3%TYPE,

11: -- ----------------------------------------------------------------------------
12:
13: procedure chk_school_id_school_name_comb(
14: p_school_id in out nocopy per_analysis_criteria.segment2%TYPE,
15: p_school_name in out nocopy per_analysis_criteria.segment3%TYPE,
16: p_school_name_kana in out nocopy per_analysis_criteria.segment4%TYPE,
17: p_major in out nocopy per_analysis_criteria.segment5%TYPE,
18: p_major_kana in out nocopy per_analysis_criteria.segment6%TYPE) is
19:

Line 16: p_school_name_kana in out nocopy per_analysis_criteria.segment4%TYPE,

12:
13: procedure chk_school_id_school_name_comb(
14: p_school_id in out nocopy per_analysis_criteria.segment2%TYPE,
15: p_school_name in out nocopy per_analysis_criteria.segment3%TYPE,
16: p_school_name_kana in out nocopy per_analysis_criteria.segment4%TYPE,
17: p_major in out nocopy per_analysis_criteria.segment5%TYPE,
18: p_major_kana in out nocopy per_analysis_criteria.segment6%TYPE) is
19:
20:

Line 17: p_major in out nocopy per_analysis_criteria.segment5%TYPE,

13: procedure chk_school_id_school_name_comb(
14: p_school_id in out nocopy per_analysis_criteria.segment2%TYPE,
15: p_school_name in out nocopy per_analysis_criteria.segment3%TYPE,
16: p_school_name_kana in out nocopy per_analysis_criteria.segment4%TYPE,
17: p_major in out nocopy per_analysis_criteria.segment5%TYPE,
18: p_major_kana in out nocopy per_analysis_criteria.segment6%TYPE) is
19:
20:
21: l_proc varchar2(72) := g_package||'chk_school_id_name_comb';

Line 18: p_major_kana in out nocopy per_analysis_criteria.segment6%TYPE) is

14: p_school_id in out nocopy per_analysis_criteria.segment2%TYPE,
15: p_school_name in out nocopy per_analysis_criteria.segment3%TYPE,
16: p_school_name_kana in out nocopy per_analysis_criteria.segment4%TYPE,
17: p_major in out nocopy per_analysis_criteria.segment5%TYPE,
18: p_major_kana in out nocopy per_analysis_criteria.segment6%TYPE) is
19:
20:
21: l_proc varchar2(72) := g_package||'chk_school_id_name_comb';
22: --

Line 192: l_segment2 per_analysis_criteria.segment2%TYPE := p_segment2;

188: l_proc varchar2(72) := g_package||'create_jp_educ_sit';
189: l_exists varchar2(2);
190: l_id_flex_num fnd_id_flex_structures.id_flex_num%TYPE := 1;
191: l_legislation_code per_business_groups.legislation_code%TYPE;
192: l_segment2 per_analysis_criteria.segment2%TYPE := p_segment2;
193: l_segment3 per_analysis_criteria.segment3%TYPE := p_segment3;
194: l_segment4 per_analysis_criteria.segment4%TYPE := p_segment4;
195: l_segment5 per_analysis_criteria.segment5%TYPE := p_segment5;
196: l_segment6 per_analysis_criteria.segment6%TYPE := p_segment6;

Line 193: l_segment3 per_analysis_criteria.segment3%TYPE := p_segment3;

189: l_exists varchar2(2);
190: l_id_flex_num fnd_id_flex_structures.id_flex_num%TYPE := 1;
191: l_legislation_code per_business_groups.legislation_code%TYPE;
192: l_segment2 per_analysis_criteria.segment2%TYPE := p_segment2;
193: l_segment3 per_analysis_criteria.segment3%TYPE := p_segment3;
194: l_segment4 per_analysis_criteria.segment4%TYPE := p_segment4;
195: l_segment5 per_analysis_criteria.segment5%TYPE := p_segment5;
196: l_segment6 per_analysis_criteria.segment6%TYPE := p_segment6;
197: --

Line 194: l_segment4 per_analysis_criteria.segment4%TYPE := p_segment4;

190: l_id_flex_num fnd_id_flex_structures.id_flex_num%TYPE := 1;
191: l_legislation_code per_business_groups.legislation_code%TYPE;
192: l_segment2 per_analysis_criteria.segment2%TYPE := p_segment2;
193: l_segment3 per_analysis_criteria.segment3%TYPE := p_segment3;
194: l_segment4 per_analysis_criteria.segment4%TYPE := p_segment4;
195: l_segment5 per_analysis_criteria.segment5%TYPE := p_segment5;
196: l_segment6 per_analysis_criteria.segment6%TYPE := p_segment6;
197: --
198: cursor csr_bg is

Line 195: l_segment5 per_analysis_criteria.segment5%TYPE := p_segment5;

191: l_legislation_code per_business_groups.legislation_code%TYPE;
192: l_segment2 per_analysis_criteria.segment2%TYPE := p_segment2;
193: l_segment3 per_analysis_criteria.segment3%TYPE := p_segment3;
194: l_segment4 per_analysis_criteria.segment4%TYPE := p_segment4;
195: l_segment5 per_analysis_criteria.segment5%TYPE := p_segment5;
196: l_segment6 per_analysis_criteria.segment6%TYPE := p_segment6;
197: --
198: cursor csr_bg is
199: select legislation_code

Line 196: l_segment6 per_analysis_criteria.segment6%TYPE := p_segment6;

192: l_segment2 per_analysis_criteria.segment2%TYPE := p_segment2;
193: l_segment3 per_analysis_criteria.segment3%TYPE := p_segment3;
194: l_segment4 per_analysis_criteria.segment4%TYPE := p_segment4;
195: l_segment5 per_analysis_criteria.segment5%TYPE := p_segment5;
196: l_segment6 per_analysis_criteria.segment6%TYPE := p_segment6;
197: --
198: cursor csr_bg is
199: select legislation_code
200: from per_business_groups pbg