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
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:
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:
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';
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: --
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;
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: --
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
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
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