36: --
37: -- {End Of Comments}
38: -- ----------------------------------------------------------------------------
39: procedure chk_gb_segment1
40: (p_segment1 in pay_external_accounts.segment1%type) is
41: --
42: cursor hlsel is
43: select null
44: from hr_lookups
113: --
114: -- {End Of Comments}
115: -- ----------------------------------------------------------------------------
116: procedure chk_gb_segment2
117: (p_segment2 in pay_external_accounts.segment2%type) is
118: --
119: l_proc varchar2(72) := g_package||'chk_gb_segment2';
120: --
121: begin
164: --
165: -- {End Of Comments}
166: -- ----------------------------------------------------------------------------
167: procedure chk_gb_segment3
168: (p_segment3 in pay_external_accounts.segment3%type) is
169: --
170: l_proc varchar2(72) := g_package||'chk_gb_segment3';
171: l_segment3 pay_external_accounts.segment3%type;
172: --
167: procedure chk_gb_segment3
168: (p_segment3 in pay_external_accounts.segment3%type) is
169: --
170: l_proc varchar2(72) := g_package||'chk_gb_segment3';
171: l_segment3 pay_external_accounts.segment3%type;
172: --
173: begin
174: hr_utility.set_location('Entering:'||l_proc, 5);
175: --
244: --
245: -- {End Of Comments}
246: -- ----------------------------------------------------------------------------
247: procedure chk_gb_segment4
248: (p_segment4 in pay_external_accounts.segment4%type) is
249: --
250: l_proc varchar2(72) := g_package||'chk_gb_segment4';
251: l_segment4 pay_external_accounts.segment4%type;
252: --
247: procedure chk_gb_segment4
248: (p_segment4 in pay_external_accounts.segment4%type) is
249: --
250: l_proc varchar2(72) := g_package||'chk_gb_segment4';
251: l_segment4 pay_external_accounts.segment4%type;
252: --
253: begin
254: hr_utility.set_location('Entering:'||l_proc, 5);
255: --
319: --
320: -- {End Of Comments}
321: -- ----------------------------------------------------------------------------
322: procedure chk_gb_segment5
323: (p_segment5 in pay_external_accounts.segment5%type) is
324: --
325: l_proc varchar2(72) := g_package||'chk_gb_segment5';
326: --
327: begin
385: --
386: -- {End Of Comments}
387: -- ----------------------------------------------------------------------------
388: procedure chk_gb_segment6
389: (p_segment6 in pay_external_accounts.segment6%type) is
390: --
391: l_proc varchar2(72) := g_package||'chk_gb_segment6';
392: l_segment6 pay_external_accounts.segment6%type;
393: --
388: procedure chk_gb_segment6
389: (p_segment6 in pay_external_accounts.segment6%type) is
390: --
391: l_proc varchar2(72) := g_package||'chk_gb_segment6';
392: l_segment6 pay_external_accounts.segment6%type;
393: --
394: begin
395: hr_utility.set_location('Entering:'||l_proc, 5);
396: if p_segment6 is not null then
453: --
454: -- {End Of Comments}
455: -- ----------------------------------------------------------------------------
456: procedure chk_gb_segment7
457: (p_segment7 in pay_external_accounts.segment7%type) is
458: --
459: l_proc varchar2(72) := g_package||'chk_gb_segment7';
460: --
461: begin
513: --
514: -- {End Of Comments}
515: -- ----------------------------------------------------------------------------
516: procedure chk_gb_segment8
517: (p_segment8 in pay_external_accounts.segment8%type) is
518: --
519: l_proc varchar2(72) := g_package||'chk_gb_segment8';
520: l_exists varchar2(80);
521: --
582: --
583: -- {End Of Comments}
584: -- ----------------------------------------------------------------------------
585: procedure chk_gb_segment9_30
586: (p_segment9 in pay_external_accounts.segment9%type,
587: p_segment10 in pay_external_accounts.segment10%type,
588: p_segment11 in pay_external_accounts.segment11%type,
589: p_segment12 in pay_external_accounts.segment12%type,
590: p_segment13 in pay_external_accounts.segment13%type,
583: -- {End Of Comments}
584: -- ----------------------------------------------------------------------------
585: procedure chk_gb_segment9_30
586: (p_segment9 in pay_external_accounts.segment9%type,
587: p_segment10 in pay_external_accounts.segment10%type,
588: p_segment11 in pay_external_accounts.segment11%type,
589: p_segment12 in pay_external_accounts.segment12%type,
590: p_segment13 in pay_external_accounts.segment13%type,
591: p_segment14 in pay_external_accounts.segment14%type,
584: -- ----------------------------------------------------------------------------
585: procedure chk_gb_segment9_30
586: (p_segment9 in pay_external_accounts.segment9%type,
587: p_segment10 in pay_external_accounts.segment10%type,
588: p_segment11 in pay_external_accounts.segment11%type,
589: p_segment12 in pay_external_accounts.segment12%type,
590: p_segment13 in pay_external_accounts.segment13%type,
591: p_segment14 in pay_external_accounts.segment14%type,
592: p_segment15 in pay_external_accounts.segment15%type,
585: procedure chk_gb_segment9_30
586: (p_segment9 in pay_external_accounts.segment9%type,
587: p_segment10 in pay_external_accounts.segment10%type,
588: p_segment11 in pay_external_accounts.segment11%type,
589: p_segment12 in pay_external_accounts.segment12%type,
590: p_segment13 in pay_external_accounts.segment13%type,
591: p_segment14 in pay_external_accounts.segment14%type,
592: p_segment15 in pay_external_accounts.segment15%type,
593: p_segment16 in pay_external_accounts.segment16%type,
586: (p_segment9 in pay_external_accounts.segment9%type,
587: p_segment10 in pay_external_accounts.segment10%type,
588: p_segment11 in pay_external_accounts.segment11%type,
589: p_segment12 in pay_external_accounts.segment12%type,
590: p_segment13 in pay_external_accounts.segment13%type,
591: p_segment14 in pay_external_accounts.segment14%type,
592: p_segment15 in pay_external_accounts.segment15%type,
593: p_segment16 in pay_external_accounts.segment16%type,
594: p_segment17 in pay_external_accounts.segment17%type,
587: p_segment10 in pay_external_accounts.segment10%type,
588: p_segment11 in pay_external_accounts.segment11%type,
589: p_segment12 in pay_external_accounts.segment12%type,
590: p_segment13 in pay_external_accounts.segment13%type,
591: p_segment14 in pay_external_accounts.segment14%type,
592: p_segment15 in pay_external_accounts.segment15%type,
593: p_segment16 in pay_external_accounts.segment16%type,
594: p_segment17 in pay_external_accounts.segment17%type,
595: p_segment18 in pay_external_accounts.segment18%type,
588: p_segment11 in pay_external_accounts.segment11%type,
589: p_segment12 in pay_external_accounts.segment12%type,
590: p_segment13 in pay_external_accounts.segment13%type,
591: p_segment14 in pay_external_accounts.segment14%type,
592: p_segment15 in pay_external_accounts.segment15%type,
593: p_segment16 in pay_external_accounts.segment16%type,
594: p_segment17 in pay_external_accounts.segment17%type,
595: p_segment18 in pay_external_accounts.segment18%type,
596: p_segment19 in pay_external_accounts.segment19%type,
589: p_segment12 in pay_external_accounts.segment12%type,
590: p_segment13 in pay_external_accounts.segment13%type,
591: p_segment14 in pay_external_accounts.segment14%type,
592: p_segment15 in pay_external_accounts.segment15%type,
593: p_segment16 in pay_external_accounts.segment16%type,
594: p_segment17 in pay_external_accounts.segment17%type,
595: p_segment18 in pay_external_accounts.segment18%type,
596: p_segment19 in pay_external_accounts.segment19%type,
597: p_segment20 in pay_external_accounts.segment20%type,
590: p_segment13 in pay_external_accounts.segment13%type,
591: p_segment14 in pay_external_accounts.segment14%type,
592: p_segment15 in pay_external_accounts.segment15%type,
593: p_segment16 in pay_external_accounts.segment16%type,
594: p_segment17 in pay_external_accounts.segment17%type,
595: p_segment18 in pay_external_accounts.segment18%type,
596: p_segment19 in pay_external_accounts.segment19%type,
597: p_segment20 in pay_external_accounts.segment20%type,
598: p_segment21 in pay_external_accounts.segment21%type,
591: p_segment14 in pay_external_accounts.segment14%type,
592: p_segment15 in pay_external_accounts.segment15%type,
593: p_segment16 in pay_external_accounts.segment16%type,
594: p_segment17 in pay_external_accounts.segment17%type,
595: p_segment18 in pay_external_accounts.segment18%type,
596: p_segment19 in pay_external_accounts.segment19%type,
597: p_segment20 in pay_external_accounts.segment20%type,
598: p_segment21 in pay_external_accounts.segment21%type,
599: p_segment22 in pay_external_accounts.segment22%type,
592: p_segment15 in pay_external_accounts.segment15%type,
593: p_segment16 in pay_external_accounts.segment16%type,
594: p_segment17 in pay_external_accounts.segment17%type,
595: p_segment18 in pay_external_accounts.segment18%type,
596: p_segment19 in pay_external_accounts.segment19%type,
597: p_segment20 in pay_external_accounts.segment20%type,
598: p_segment21 in pay_external_accounts.segment21%type,
599: p_segment22 in pay_external_accounts.segment22%type,
600: p_segment23 in pay_external_accounts.segment23%type,
593: p_segment16 in pay_external_accounts.segment16%type,
594: p_segment17 in pay_external_accounts.segment17%type,
595: p_segment18 in pay_external_accounts.segment18%type,
596: p_segment19 in pay_external_accounts.segment19%type,
597: p_segment20 in pay_external_accounts.segment20%type,
598: p_segment21 in pay_external_accounts.segment21%type,
599: p_segment22 in pay_external_accounts.segment22%type,
600: p_segment23 in pay_external_accounts.segment23%type,
601: p_segment24 in pay_external_accounts.segment24%type,
594: p_segment17 in pay_external_accounts.segment17%type,
595: p_segment18 in pay_external_accounts.segment18%type,
596: p_segment19 in pay_external_accounts.segment19%type,
597: p_segment20 in pay_external_accounts.segment20%type,
598: p_segment21 in pay_external_accounts.segment21%type,
599: p_segment22 in pay_external_accounts.segment22%type,
600: p_segment23 in pay_external_accounts.segment23%type,
601: p_segment24 in pay_external_accounts.segment24%type,
602: p_segment25 in pay_external_accounts.segment25%type,
595: p_segment18 in pay_external_accounts.segment18%type,
596: p_segment19 in pay_external_accounts.segment19%type,
597: p_segment20 in pay_external_accounts.segment20%type,
598: p_segment21 in pay_external_accounts.segment21%type,
599: p_segment22 in pay_external_accounts.segment22%type,
600: p_segment23 in pay_external_accounts.segment23%type,
601: p_segment24 in pay_external_accounts.segment24%type,
602: p_segment25 in pay_external_accounts.segment25%type,
603: p_segment26 in pay_external_accounts.segment26%type,
596: p_segment19 in pay_external_accounts.segment19%type,
597: p_segment20 in pay_external_accounts.segment20%type,
598: p_segment21 in pay_external_accounts.segment21%type,
599: p_segment22 in pay_external_accounts.segment22%type,
600: p_segment23 in pay_external_accounts.segment23%type,
601: p_segment24 in pay_external_accounts.segment24%type,
602: p_segment25 in pay_external_accounts.segment25%type,
603: p_segment26 in pay_external_accounts.segment26%type,
604: p_segment27 in pay_external_accounts.segment27%type,
597: p_segment20 in pay_external_accounts.segment20%type,
598: p_segment21 in pay_external_accounts.segment21%type,
599: p_segment22 in pay_external_accounts.segment22%type,
600: p_segment23 in pay_external_accounts.segment23%type,
601: p_segment24 in pay_external_accounts.segment24%type,
602: p_segment25 in pay_external_accounts.segment25%type,
603: p_segment26 in pay_external_accounts.segment26%type,
604: p_segment27 in pay_external_accounts.segment27%type,
605: p_segment28 in pay_external_accounts.segment28%type,
598: p_segment21 in pay_external_accounts.segment21%type,
599: p_segment22 in pay_external_accounts.segment22%type,
600: p_segment23 in pay_external_accounts.segment23%type,
601: p_segment24 in pay_external_accounts.segment24%type,
602: p_segment25 in pay_external_accounts.segment25%type,
603: p_segment26 in pay_external_accounts.segment26%type,
604: p_segment27 in pay_external_accounts.segment27%type,
605: p_segment28 in pay_external_accounts.segment28%type,
606: p_segment29 in pay_external_accounts.segment29%type,
599: p_segment22 in pay_external_accounts.segment22%type,
600: p_segment23 in pay_external_accounts.segment23%type,
601: p_segment24 in pay_external_accounts.segment24%type,
602: p_segment25 in pay_external_accounts.segment25%type,
603: p_segment26 in pay_external_accounts.segment26%type,
604: p_segment27 in pay_external_accounts.segment27%type,
605: p_segment28 in pay_external_accounts.segment28%type,
606: p_segment29 in pay_external_accounts.segment29%type,
607: p_segment30 in pay_external_accounts.segment30%type) is
600: p_segment23 in pay_external_accounts.segment23%type,
601: p_segment24 in pay_external_accounts.segment24%type,
602: p_segment25 in pay_external_accounts.segment25%type,
603: p_segment26 in pay_external_accounts.segment26%type,
604: p_segment27 in pay_external_accounts.segment27%type,
605: p_segment28 in pay_external_accounts.segment28%type,
606: p_segment29 in pay_external_accounts.segment29%type,
607: p_segment30 in pay_external_accounts.segment30%type) is
608: --
601: p_segment24 in pay_external_accounts.segment24%type,
602: p_segment25 in pay_external_accounts.segment25%type,
603: p_segment26 in pay_external_accounts.segment26%type,
604: p_segment27 in pay_external_accounts.segment27%type,
605: p_segment28 in pay_external_accounts.segment28%type,
606: p_segment29 in pay_external_accounts.segment29%type,
607: p_segment30 in pay_external_accounts.segment30%type) is
608: --
609: l_proc varchar2(72) := g_package||'chk_gb_segment9_30';
602: p_segment25 in pay_external_accounts.segment25%type,
603: p_segment26 in pay_external_accounts.segment26%type,
604: p_segment27 in pay_external_accounts.segment27%type,
605: p_segment28 in pay_external_accounts.segment28%type,
606: p_segment29 in pay_external_accounts.segment29%type,
607: p_segment30 in pay_external_accounts.segment30%type) is
608: --
609: l_proc varchar2(72) := g_package||'chk_gb_segment9_30';
610: l_err exception; -- local error exception
603: p_segment26 in pay_external_accounts.segment26%type,
604: p_segment27 in pay_external_accounts.segment27%type,
605: p_segment28 in pay_external_accounts.segment28%type,
606: p_segment29 in pay_external_accounts.segment29%type,
607: p_segment30 in pay_external_accounts.segment30%type) is
608: --
609: l_proc varchar2(72) := g_package||'chk_gb_segment9_30';
610: l_err exception; -- local error exception
611: l_n number; -- arg in error number (9..30)
608: --
609: l_proc varchar2(72) := g_package||'chk_gb_segment9_30';
610: l_err exception; -- local error exception
611: l_n number; -- arg in error number (9..30)
612: l_v pay_external_accounts.segment8%type; -- arg in error value (9..30)
613: --
614: begin
615: hr_utility.set_location('Entering:'||l_proc, 5);
616: --
675: --
676: -- {End Of Comments}
677: -- ----------------------------------------------------------------------------
678: procedure chk_us_segment1
679: (p_segment1 in pay_external_accounts.segment1%type) is
680: --
681: l_proc varchar2(72) := g_package||'chk_us_segment1';
682: l_dummy number;
683: --
735: --
736: -- {End Of Comments}
737: -- ----------------------------------------------------------------------------
738: procedure chk_us_segment2
739: (p_segment2 in pay_external_accounts.segment2%type) is
740: --
741: cursor fnd_com_look is
742: select null
743: from fnd_common_lookups
814: --
815: -- {End Of Comments}
816: -- ----------------------------------------------------------------------------
817: procedure chk_us_segment3
818: (p_segment3 in pay_external_accounts.segment3%type) is
819: --
820: l_proc varchar2(72) := g_package||'chk_us_segment3';
821: l_dummy number;
822: --
873: --
874: -- {End Of Comments}
875: -- ----------------------------------------------------------------------------
876: procedure chk_us_segment4
877: (p_segment4 in pay_external_accounts.segment4%type) is
878: --
879: l_segment4 pay_external_accounts.segment4%type;
880: l_proc varchar2(72) := g_package||'chk_us_segment4';
881: l_dummy number;
875: -- ----------------------------------------------------------------------------
876: procedure chk_us_segment4
877: (p_segment4 in pay_external_accounts.segment4%type) is
878: --
879: l_segment4 pay_external_accounts.segment4%type;
880: l_proc varchar2(72) := g_package||'chk_us_segment4';
881: l_dummy number;
882: --
883: begin
942: --
943: -- {End Of Comments}
944: -- ----------------------------------------------------------------------------
945: procedure chk_us_segment5
946: (p_segment5 in pay_external_accounts.segment5%type) is
947: --
948: l_proc varchar2(72) := g_package||'chk_us_segment5';
949: l_dummy number;
950: --
1000: --
1001: -- {End Of Comments}
1002: -- ----------------------------------------------------------------------------
1003: procedure chk_us_segment6
1004: (p_segment6 in pay_external_accounts.segment6%type) is
1005: --
1006: l_proc varchar2(72) := g_package||'chk_us_segment6';
1007: l_dummy number;
1008: --
1056: --
1057: -- {End Of Comments}
1058: -- ----------------------------------------------------------------------------
1059: procedure chk_us_segment7_30
1060: (p_segment7 in pay_external_accounts.segment7%type,
1061: p_segment8 in pay_external_accounts.segment8%type,
1062: p_segment9 in pay_external_accounts.segment9%type,
1063: p_segment10 in pay_external_accounts.segment10%type,
1064: p_segment11 in pay_external_accounts.segment11%type,
1057: -- {End Of Comments}
1058: -- ----------------------------------------------------------------------------
1059: procedure chk_us_segment7_30
1060: (p_segment7 in pay_external_accounts.segment7%type,
1061: p_segment8 in pay_external_accounts.segment8%type,
1062: p_segment9 in pay_external_accounts.segment9%type,
1063: p_segment10 in pay_external_accounts.segment10%type,
1064: p_segment11 in pay_external_accounts.segment11%type,
1065: p_segment12 in pay_external_accounts.segment12%type,
1058: -- ----------------------------------------------------------------------------
1059: procedure chk_us_segment7_30
1060: (p_segment7 in pay_external_accounts.segment7%type,
1061: p_segment8 in pay_external_accounts.segment8%type,
1062: p_segment9 in pay_external_accounts.segment9%type,
1063: p_segment10 in pay_external_accounts.segment10%type,
1064: p_segment11 in pay_external_accounts.segment11%type,
1065: p_segment12 in pay_external_accounts.segment12%type,
1066: p_segment13 in pay_external_accounts.segment13%type,
1059: procedure chk_us_segment7_30
1060: (p_segment7 in pay_external_accounts.segment7%type,
1061: p_segment8 in pay_external_accounts.segment8%type,
1062: p_segment9 in pay_external_accounts.segment9%type,
1063: p_segment10 in pay_external_accounts.segment10%type,
1064: p_segment11 in pay_external_accounts.segment11%type,
1065: p_segment12 in pay_external_accounts.segment12%type,
1066: p_segment13 in pay_external_accounts.segment13%type,
1067: p_segment14 in pay_external_accounts.segment14%type,
1060: (p_segment7 in pay_external_accounts.segment7%type,
1061: p_segment8 in pay_external_accounts.segment8%type,
1062: p_segment9 in pay_external_accounts.segment9%type,
1063: p_segment10 in pay_external_accounts.segment10%type,
1064: p_segment11 in pay_external_accounts.segment11%type,
1065: p_segment12 in pay_external_accounts.segment12%type,
1066: p_segment13 in pay_external_accounts.segment13%type,
1067: p_segment14 in pay_external_accounts.segment14%type,
1068: p_segment15 in pay_external_accounts.segment15%type,
1061: p_segment8 in pay_external_accounts.segment8%type,
1062: p_segment9 in pay_external_accounts.segment9%type,
1063: p_segment10 in pay_external_accounts.segment10%type,
1064: p_segment11 in pay_external_accounts.segment11%type,
1065: p_segment12 in pay_external_accounts.segment12%type,
1066: p_segment13 in pay_external_accounts.segment13%type,
1067: p_segment14 in pay_external_accounts.segment14%type,
1068: p_segment15 in pay_external_accounts.segment15%type,
1069: p_segment16 in pay_external_accounts.segment16%type,
1062: p_segment9 in pay_external_accounts.segment9%type,
1063: p_segment10 in pay_external_accounts.segment10%type,
1064: p_segment11 in pay_external_accounts.segment11%type,
1065: p_segment12 in pay_external_accounts.segment12%type,
1066: p_segment13 in pay_external_accounts.segment13%type,
1067: p_segment14 in pay_external_accounts.segment14%type,
1068: p_segment15 in pay_external_accounts.segment15%type,
1069: p_segment16 in pay_external_accounts.segment16%type,
1070: p_segment17 in pay_external_accounts.segment17%type,
1063: p_segment10 in pay_external_accounts.segment10%type,
1064: p_segment11 in pay_external_accounts.segment11%type,
1065: p_segment12 in pay_external_accounts.segment12%type,
1066: p_segment13 in pay_external_accounts.segment13%type,
1067: p_segment14 in pay_external_accounts.segment14%type,
1068: p_segment15 in pay_external_accounts.segment15%type,
1069: p_segment16 in pay_external_accounts.segment16%type,
1070: p_segment17 in pay_external_accounts.segment17%type,
1071: p_segment18 in pay_external_accounts.segment18%type,
1064: p_segment11 in pay_external_accounts.segment11%type,
1065: p_segment12 in pay_external_accounts.segment12%type,
1066: p_segment13 in pay_external_accounts.segment13%type,
1067: p_segment14 in pay_external_accounts.segment14%type,
1068: p_segment15 in pay_external_accounts.segment15%type,
1069: p_segment16 in pay_external_accounts.segment16%type,
1070: p_segment17 in pay_external_accounts.segment17%type,
1071: p_segment18 in pay_external_accounts.segment18%type,
1072: p_segment19 in pay_external_accounts.segment19%type,
1065: p_segment12 in pay_external_accounts.segment12%type,
1066: p_segment13 in pay_external_accounts.segment13%type,
1067: p_segment14 in pay_external_accounts.segment14%type,
1068: p_segment15 in pay_external_accounts.segment15%type,
1069: p_segment16 in pay_external_accounts.segment16%type,
1070: p_segment17 in pay_external_accounts.segment17%type,
1071: p_segment18 in pay_external_accounts.segment18%type,
1072: p_segment19 in pay_external_accounts.segment19%type,
1073: p_segment20 in pay_external_accounts.segment20%type,
1066: p_segment13 in pay_external_accounts.segment13%type,
1067: p_segment14 in pay_external_accounts.segment14%type,
1068: p_segment15 in pay_external_accounts.segment15%type,
1069: p_segment16 in pay_external_accounts.segment16%type,
1070: p_segment17 in pay_external_accounts.segment17%type,
1071: p_segment18 in pay_external_accounts.segment18%type,
1072: p_segment19 in pay_external_accounts.segment19%type,
1073: p_segment20 in pay_external_accounts.segment20%type,
1074: p_segment21 in pay_external_accounts.segment21%type,
1067: p_segment14 in pay_external_accounts.segment14%type,
1068: p_segment15 in pay_external_accounts.segment15%type,
1069: p_segment16 in pay_external_accounts.segment16%type,
1070: p_segment17 in pay_external_accounts.segment17%type,
1071: p_segment18 in pay_external_accounts.segment18%type,
1072: p_segment19 in pay_external_accounts.segment19%type,
1073: p_segment20 in pay_external_accounts.segment20%type,
1074: p_segment21 in pay_external_accounts.segment21%type,
1075: p_segment22 in pay_external_accounts.segment22%type,
1068: p_segment15 in pay_external_accounts.segment15%type,
1069: p_segment16 in pay_external_accounts.segment16%type,
1070: p_segment17 in pay_external_accounts.segment17%type,
1071: p_segment18 in pay_external_accounts.segment18%type,
1072: p_segment19 in pay_external_accounts.segment19%type,
1073: p_segment20 in pay_external_accounts.segment20%type,
1074: p_segment21 in pay_external_accounts.segment21%type,
1075: p_segment22 in pay_external_accounts.segment22%type,
1076: p_segment23 in pay_external_accounts.segment23%type,
1069: p_segment16 in pay_external_accounts.segment16%type,
1070: p_segment17 in pay_external_accounts.segment17%type,
1071: p_segment18 in pay_external_accounts.segment18%type,
1072: p_segment19 in pay_external_accounts.segment19%type,
1073: p_segment20 in pay_external_accounts.segment20%type,
1074: p_segment21 in pay_external_accounts.segment21%type,
1075: p_segment22 in pay_external_accounts.segment22%type,
1076: p_segment23 in pay_external_accounts.segment23%type,
1077: p_segment24 in pay_external_accounts.segment24%type,
1070: p_segment17 in pay_external_accounts.segment17%type,
1071: p_segment18 in pay_external_accounts.segment18%type,
1072: p_segment19 in pay_external_accounts.segment19%type,
1073: p_segment20 in pay_external_accounts.segment20%type,
1074: p_segment21 in pay_external_accounts.segment21%type,
1075: p_segment22 in pay_external_accounts.segment22%type,
1076: p_segment23 in pay_external_accounts.segment23%type,
1077: p_segment24 in pay_external_accounts.segment24%type,
1078: p_segment25 in pay_external_accounts.segment25%type,
1071: p_segment18 in pay_external_accounts.segment18%type,
1072: p_segment19 in pay_external_accounts.segment19%type,
1073: p_segment20 in pay_external_accounts.segment20%type,
1074: p_segment21 in pay_external_accounts.segment21%type,
1075: p_segment22 in pay_external_accounts.segment22%type,
1076: p_segment23 in pay_external_accounts.segment23%type,
1077: p_segment24 in pay_external_accounts.segment24%type,
1078: p_segment25 in pay_external_accounts.segment25%type,
1079: p_segment26 in pay_external_accounts.segment26%type,
1072: p_segment19 in pay_external_accounts.segment19%type,
1073: p_segment20 in pay_external_accounts.segment20%type,
1074: p_segment21 in pay_external_accounts.segment21%type,
1075: p_segment22 in pay_external_accounts.segment22%type,
1076: p_segment23 in pay_external_accounts.segment23%type,
1077: p_segment24 in pay_external_accounts.segment24%type,
1078: p_segment25 in pay_external_accounts.segment25%type,
1079: p_segment26 in pay_external_accounts.segment26%type,
1080: p_segment27 in pay_external_accounts.segment27%type,
1073: p_segment20 in pay_external_accounts.segment20%type,
1074: p_segment21 in pay_external_accounts.segment21%type,
1075: p_segment22 in pay_external_accounts.segment22%type,
1076: p_segment23 in pay_external_accounts.segment23%type,
1077: p_segment24 in pay_external_accounts.segment24%type,
1078: p_segment25 in pay_external_accounts.segment25%type,
1079: p_segment26 in pay_external_accounts.segment26%type,
1080: p_segment27 in pay_external_accounts.segment27%type,
1081: p_segment28 in pay_external_accounts.segment28%type,
1074: p_segment21 in pay_external_accounts.segment21%type,
1075: p_segment22 in pay_external_accounts.segment22%type,
1076: p_segment23 in pay_external_accounts.segment23%type,
1077: p_segment24 in pay_external_accounts.segment24%type,
1078: p_segment25 in pay_external_accounts.segment25%type,
1079: p_segment26 in pay_external_accounts.segment26%type,
1080: p_segment27 in pay_external_accounts.segment27%type,
1081: p_segment28 in pay_external_accounts.segment28%type,
1082: p_segment29 in pay_external_accounts.segment29%type,
1075: p_segment22 in pay_external_accounts.segment22%type,
1076: p_segment23 in pay_external_accounts.segment23%type,
1077: p_segment24 in pay_external_accounts.segment24%type,
1078: p_segment25 in pay_external_accounts.segment25%type,
1079: p_segment26 in pay_external_accounts.segment26%type,
1080: p_segment27 in pay_external_accounts.segment27%type,
1081: p_segment28 in pay_external_accounts.segment28%type,
1082: p_segment29 in pay_external_accounts.segment29%type,
1083: p_segment30 in pay_external_accounts.segment30%type) is
1076: p_segment23 in pay_external_accounts.segment23%type,
1077: p_segment24 in pay_external_accounts.segment24%type,
1078: p_segment25 in pay_external_accounts.segment25%type,
1079: p_segment26 in pay_external_accounts.segment26%type,
1080: p_segment27 in pay_external_accounts.segment27%type,
1081: p_segment28 in pay_external_accounts.segment28%type,
1082: p_segment29 in pay_external_accounts.segment29%type,
1083: p_segment30 in pay_external_accounts.segment30%type) is
1084: --
1077: p_segment24 in pay_external_accounts.segment24%type,
1078: p_segment25 in pay_external_accounts.segment25%type,
1079: p_segment26 in pay_external_accounts.segment26%type,
1080: p_segment27 in pay_external_accounts.segment27%type,
1081: p_segment28 in pay_external_accounts.segment28%type,
1082: p_segment29 in pay_external_accounts.segment29%type,
1083: p_segment30 in pay_external_accounts.segment30%type) is
1084: --
1085: l_proc varchar2(72) := g_package||'chk_us_segment7_30';
1078: p_segment25 in pay_external_accounts.segment25%type,
1079: p_segment26 in pay_external_accounts.segment26%type,
1080: p_segment27 in pay_external_accounts.segment27%type,
1081: p_segment28 in pay_external_accounts.segment28%type,
1082: p_segment29 in pay_external_accounts.segment29%type,
1083: p_segment30 in pay_external_accounts.segment30%type) is
1084: --
1085: l_proc varchar2(72) := g_package||'chk_us_segment7_30';
1086: l_err exception; -- local error exception
1079: p_segment26 in pay_external_accounts.segment26%type,
1080: p_segment27 in pay_external_accounts.segment27%type,
1081: p_segment28 in pay_external_accounts.segment28%type,
1082: p_segment29 in pay_external_accounts.segment29%type,
1083: p_segment30 in pay_external_accounts.segment30%type) is
1084: --
1085: l_proc varchar2(72) := g_package||'chk_us_segment7_30';
1086: l_err exception; -- local error exception
1087: l_n number; -- arg in error number (9..30)
1084: --
1085: l_proc varchar2(72) := g_package||'chk_us_segment7_30';
1086: l_err exception; -- local error exception
1087: l_n number; -- arg in error number (9..30)
1088: l_v pay_external_accounts.segment8%type; -- arg in error value (9..30)
1089: --
1090: begin
1091: hr_utility.set_location('Entering:'||l_proc, 5);
1092: --