735:
736: i BINARY_INTEGER;
737:
738: account_type gl_code_combinations.account_type%TYPE;
739: segment1 gl_code_combinations.segment1%TYPE;
740: segment2 gl_code_combinations.segment2%TYPE;
741: segment3 gl_code_combinations.segment3%TYPE;
742: segment4 gl_code_combinations.segment4%TYPE;
743: segment5 gl_code_combinations.segment5%TYPE;
736: i BINARY_INTEGER;
737:
738: account_type gl_code_combinations.account_type%TYPE;
739: segment1 gl_code_combinations.segment1%TYPE;
740: segment2 gl_code_combinations.segment2%TYPE;
741: segment3 gl_code_combinations.segment3%TYPE;
742: segment4 gl_code_combinations.segment4%TYPE;
743: segment5 gl_code_combinations.segment5%TYPE;
744: segment6 gl_code_combinations.segment6%TYPE;
737:
738: account_type gl_code_combinations.account_type%TYPE;
739: segment1 gl_code_combinations.segment1%TYPE;
740: segment2 gl_code_combinations.segment2%TYPE;
741: segment3 gl_code_combinations.segment3%TYPE;
742: segment4 gl_code_combinations.segment4%TYPE;
743: segment5 gl_code_combinations.segment5%TYPE;
744: segment6 gl_code_combinations.segment6%TYPE;
745: segment7 gl_code_combinations.segment7%TYPE;
738: account_type gl_code_combinations.account_type%TYPE;
739: segment1 gl_code_combinations.segment1%TYPE;
740: segment2 gl_code_combinations.segment2%TYPE;
741: segment3 gl_code_combinations.segment3%TYPE;
742: segment4 gl_code_combinations.segment4%TYPE;
743: segment5 gl_code_combinations.segment5%TYPE;
744: segment6 gl_code_combinations.segment6%TYPE;
745: segment7 gl_code_combinations.segment7%TYPE;
746: segment8 gl_code_combinations.segment8%TYPE;
739: segment1 gl_code_combinations.segment1%TYPE;
740: segment2 gl_code_combinations.segment2%TYPE;
741: segment3 gl_code_combinations.segment3%TYPE;
742: segment4 gl_code_combinations.segment4%TYPE;
743: segment5 gl_code_combinations.segment5%TYPE;
744: segment6 gl_code_combinations.segment6%TYPE;
745: segment7 gl_code_combinations.segment7%TYPE;
746: segment8 gl_code_combinations.segment8%TYPE;
747: segment9 gl_code_combinations.segment9%TYPE;
740: segment2 gl_code_combinations.segment2%TYPE;
741: segment3 gl_code_combinations.segment3%TYPE;
742: segment4 gl_code_combinations.segment4%TYPE;
743: segment5 gl_code_combinations.segment5%TYPE;
744: segment6 gl_code_combinations.segment6%TYPE;
745: segment7 gl_code_combinations.segment7%TYPE;
746: segment8 gl_code_combinations.segment8%TYPE;
747: segment9 gl_code_combinations.segment9%TYPE;
748: segment10 gl_code_combinations.segment10%TYPE;
741: segment3 gl_code_combinations.segment3%TYPE;
742: segment4 gl_code_combinations.segment4%TYPE;
743: segment5 gl_code_combinations.segment5%TYPE;
744: segment6 gl_code_combinations.segment6%TYPE;
745: segment7 gl_code_combinations.segment7%TYPE;
746: segment8 gl_code_combinations.segment8%TYPE;
747: segment9 gl_code_combinations.segment9%TYPE;
748: segment10 gl_code_combinations.segment10%TYPE;
749: segment11 gl_code_combinations.segment11%TYPE;
742: segment4 gl_code_combinations.segment4%TYPE;
743: segment5 gl_code_combinations.segment5%TYPE;
744: segment6 gl_code_combinations.segment6%TYPE;
745: segment7 gl_code_combinations.segment7%TYPE;
746: segment8 gl_code_combinations.segment8%TYPE;
747: segment9 gl_code_combinations.segment9%TYPE;
748: segment10 gl_code_combinations.segment10%TYPE;
749: segment11 gl_code_combinations.segment11%TYPE;
750: segment12 gl_code_combinations.segment12%TYPE;
743: segment5 gl_code_combinations.segment5%TYPE;
744: segment6 gl_code_combinations.segment6%TYPE;
745: segment7 gl_code_combinations.segment7%TYPE;
746: segment8 gl_code_combinations.segment8%TYPE;
747: segment9 gl_code_combinations.segment9%TYPE;
748: segment10 gl_code_combinations.segment10%TYPE;
749: segment11 gl_code_combinations.segment11%TYPE;
750: segment12 gl_code_combinations.segment12%TYPE;
751: segment13 gl_code_combinations.segment13%TYPE;
744: segment6 gl_code_combinations.segment6%TYPE;
745: segment7 gl_code_combinations.segment7%TYPE;
746: segment8 gl_code_combinations.segment8%TYPE;
747: segment9 gl_code_combinations.segment9%TYPE;
748: segment10 gl_code_combinations.segment10%TYPE;
749: segment11 gl_code_combinations.segment11%TYPE;
750: segment12 gl_code_combinations.segment12%TYPE;
751: segment13 gl_code_combinations.segment13%TYPE;
752: segment14 gl_code_combinations.segment14%TYPE;
745: segment7 gl_code_combinations.segment7%TYPE;
746: segment8 gl_code_combinations.segment8%TYPE;
747: segment9 gl_code_combinations.segment9%TYPE;
748: segment10 gl_code_combinations.segment10%TYPE;
749: segment11 gl_code_combinations.segment11%TYPE;
750: segment12 gl_code_combinations.segment12%TYPE;
751: segment13 gl_code_combinations.segment13%TYPE;
752: segment14 gl_code_combinations.segment14%TYPE;
753: segment15 gl_code_combinations.segment15%TYPE;
746: segment8 gl_code_combinations.segment8%TYPE;
747: segment9 gl_code_combinations.segment9%TYPE;
748: segment10 gl_code_combinations.segment10%TYPE;
749: segment11 gl_code_combinations.segment11%TYPE;
750: segment12 gl_code_combinations.segment12%TYPE;
751: segment13 gl_code_combinations.segment13%TYPE;
752: segment14 gl_code_combinations.segment14%TYPE;
753: segment15 gl_code_combinations.segment15%TYPE;
754: segment16 gl_code_combinations.segment16%TYPE;
747: segment9 gl_code_combinations.segment9%TYPE;
748: segment10 gl_code_combinations.segment10%TYPE;
749: segment11 gl_code_combinations.segment11%TYPE;
750: segment12 gl_code_combinations.segment12%TYPE;
751: segment13 gl_code_combinations.segment13%TYPE;
752: segment14 gl_code_combinations.segment14%TYPE;
753: segment15 gl_code_combinations.segment15%TYPE;
754: segment16 gl_code_combinations.segment16%TYPE;
755: segment17 gl_code_combinations.segment17%TYPE;
748: segment10 gl_code_combinations.segment10%TYPE;
749: segment11 gl_code_combinations.segment11%TYPE;
750: segment12 gl_code_combinations.segment12%TYPE;
751: segment13 gl_code_combinations.segment13%TYPE;
752: segment14 gl_code_combinations.segment14%TYPE;
753: segment15 gl_code_combinations.segment15%TYPE;
754: segment16 gl_code_combinations.segment16%TYPE;
755: segment17 gl_code_combinations.segment17%TYPE;
756: segment18 gl_code_combinations.segment18%TYPE;
749: segment11 gl_code_combinations.segment11%TYPE;
750: segment12 gl_code_combinations.segment12%TYPE;
751: segment13 gl_code_combinations.segment13%TYPE;
752: segment14 gl_code_combinations.segment14%TYPE;
753: segment15 gl_code_combinations.segment15%TYPE;
754: segment16 gl_code_combinations.segment16%TYPE;
755: segment17 gl_code_combinations.segment17%TYPE;
756: segment18 gl_code_combinations.segment18%TYPE;
757: segment19 gl_code_combinations.segment19%TYPE;
750: segment12 gl_code_combinations.segment12%TYPE;
751: segment13 gl_code_combinations.segment13%TYPE;
752: segment14 gl_code_combinations.segment14%TYPE;
753: segment15 gl_code_combinations.segment15%TYPE;
754: segment16 gl_code_combinations.segment16%TYPE;
755: segment17 gl_code_combinations.segment17%TYPE;
756: segment18 gl_code_combinations.segment18%TYPE;
757: segment19 gl_code_combinations.segment19%TYPE;
758: segment20 gl_code_combinations.segment20%TYPE;
751: segment13 gl_code_combinations.segment13%TYPE;
752: segment14 gl_code_combinations.segment14%TYPE;
753: segment15 gl_code_combinations.segment15%TYPE;
754: segment16 gl_code_combinations.segment16%TYPE;
755: segment17 gl_code_combinations.segment17%TYPE;
756: segment18 gl_code_combinations.segment18%TYPE;
757: segment19 gl_code_combinations.segment19%TYPE;
758: segment20 gl_code_combinations.segment20%TYPE;
759: segment21 gl_code_combinations.segment21%TYPE;
752: segment14 gl_code_combinations.segment14%TYPE;
753: segment15 gl_code_combinations.segment15%TYPE;
754: segment16 gl_code_combinations.segment16%TYPE;
755: segment17 gl_code_combinations.segment17%TYPE;
756: segment18 gl_code_combinations.segment18%TYPE;
757: segment19 gl_code_combinations.segment19%TYPE;
758: segment20 gl_code_combinations.segment20%TYPE;
759: segment21 gl_code_combinations.segment21%TYPE;
760: segment22 gl_code_combinations.segment22%TYPE;
753: segment15 gl_code_combinations.segment15%TYPE;
754: segment16 gl_code_combinations.segment16%TYPE;
755: segment17 gl_code_combinations.segment17%TYPE;
756: segment18 gl_code_combinations.segment18%TYPE;
757: segment19 gl_code_combinations.segment19%TYPE;
758: segment20 gl_code_combinations.segment20%TYPE;
759: segment21 gl_code_combinations.segment21%TYPE;
760: segment22 gl_code_combinations.segment22%TYPE;
761: segment23 gl_code_combinations.segment23%TYPE;
754: segment16 gl_code_combinations.segment16%TYPE;
755: segment17 gl_code_combinations.segment17%TYPE;
756: segment18 gl_code_combinations.segment18%TYPE;
757: segment19 gl_code_combinations.segment19%TYPE;
758: segment20 gl_code_combinations.segment20%TYPE;
759: segment21 gl_code_combinations.segment21%TYPE;
760: segment22 gl_code_combinations.segment22%TYPE;
761: segment23 gl_code_combinations.segment23%TYPE;
762: segment24 gl_code_combinations.segment24%TYPE;
755: segment17 gl_code_combinations.segment17%TYPE;
756: segment18 gl_code_combinations.segment18%TYPE;
757: segment19 gl_code_combinations.segment19%TYPE;
758: segment20 gl_code_combinations.segment20%TYPE;
759: segment21 gl_code_combinations.segment21%TYPE;
760: segment22 gl_code_combinations.segment22%TYPE;
761: segment23 gl_code_combinations.segment23%TYPE;
762: segment24 gl_code_combinations.segment24%TYPE;
763: segment25 gl_code_combinations.segment25%TYPE;
756: segment18 gl_code_combinations.segment18%TYPE;
757: segment19 gl_code_combinations.segment19%TYPE;
758: segment20 gl_code_combinations.segment20%TYPE;
759: segment21 gl_code_combinations.segment21%TYPE;
760: segment22 gl_code_combinations.segment22%TYPE;
761: segment23 gl_code_combinations.segment23%TYPE;
762: segment24 gl_code_combinations.segment24%TYPE;
763: segment25 gl_code_combinations.segment25%TYPE;
764: segment26 gl_code_combinations.segment26%TYPE;
757: segment19 gl_code_combinations.segment19%TYPE;
758: segment20 gl_code_combinations.segment20%TYPE;
759: segment21 gl_code_combinations.segment21%TYPE;
760: segment22 gl_code_combinations.segment22%TYPE;
761: segment23 gl_code_combinations.segment23%TYPE;
762: segment24 gl_code_combinations.segment24%TYPE;
763: segment25 gl_code_combinations.segment25%TYPE;
764: segment26 gl_code_combinations.segment26%TYPE;
765: segment27 gl_code_combinations.segment27%TYPE;
758: segment20 gl_code_combinations.segment20%TYPE;
759: segment21 gl_code_combinations.segment21%TYPE;
760: segment22 gl_code_combinations.segment22%TYPE;
761: segment23 gl_code_combinations.segment23%TYPE;
762: segment24 gl_code_combinations.segment24%TYPE;
763: segment25 gl_code_combinations.segment25%TYPE;
764: segment26 gl_code_combinations.segment26%TYPE;
765: segment27 gl_code_combinations.segment27%TYPE;
766: segment28 gl_code_combinations.segment28%TYPE;
759: segment21 gl_code_combinations.segment21%TYPE;
760: segment22 gl_code_combinations.segment22%TYPE;
761: segment23 gl_code_combinations.segment23%TYPE;
762: segment24 gl_code_combinations.segment24%TYPE;
763: segment25 gl_code_combinations.segment25%TYPE;
764: segment26 gl_code_combinations.segment26%TYPE;
765: segment27 gl_code_combinations.segment27%TYPE;
766: segment28 gl_code_combinations.segment28%TYPE;
767: segment29 gl_code_combinations.segment29%TYPE;
760: segment22 gl_code_combinations.segment22%TYPE;
761: segment23 gl_code_combinations.segment23%TYPE;
762: segment24 gl_code_combinations.segment24%TYPE;
763: segment25 gl_code_combinations.segment25%TYPE;
764: segment26 gl_code_combinations.segment26%TYPE;
765: segment27 gl_code_combinations.segment27%TYPE;
766: segment28 gl_code_combinations.segment28%TYPE;
767: segment29 gl_code_combinations.segment29%TYPE;
768: segment30 gl_code_combinations.segment30%TYPE;
761: segment23 gl_code_combinations.segment23%TYPE;
762: segment24 gl_code_combinations.segment24%TYPE;
763: segment25 gl_code_combinations.segment25%TYPE;
764: segment26 gl_code_combinations.segment26%TYPE;
765: segment27 gl_code_combinations.segment27%TYPE;
766: segment28 gl_code_combinations.segment28%TYPE;
767: segment29 gl_code_combinations.segment29%TYPE;
768: segment30 gl_code_combinations.segment30%TYPE;
769:
762: segment24 gl_code_combinations.segment24%TYPE;
763: segment25 gl_code_combinations.segment25%TYPE;
764: segment26 gl_code_combinations.segment26%TYPE;
765: segment27 gl_code_combinations.segment27%TYPE;
766: segment28 gl_code_combinations.segment28%TYPE;
767: segment29 gl_code_combinations.segment29%TYPE;
768: segment30 gl_code_combinations.segment30%TYPE;
769:
770: -- ========================= FND LOG ===========================
763: segment25 gl_code_combinations.segment25%TYPE;
764: segment26 gl_code_combinations.segment26%TYPE;
765: segment27 gl_code_combinations.segment27%TYPE;
766: segment28 gl_code_combinations.segment28%TYPE;
767: segment29 gl_code_combinations.segment29%TYPE;
768: segment30 gl_code_combinations.segment30%TYPE;
769:
770: -- ========================= FND LOG ===========================
771: l_full_path VARCHAR2(100) := g_path || 'glfini.';
764: segment26 gl_code_combinations.segment26%TYPE;
765: segment27 gl_code_combinations.segment27%TYPE;
766: segment28 gl_code_combinations.segment28%TYPE;
767: segment29 gl_code_combinations.segment29%TYPE;
768: segment30 gl_code_combinations.segment30%TYPE;
769:
770: -- ========================= FND LOG ===========================
771: l_full_path VARCHAR2(100) := g_path || 'glfini.';
772: -- ========================= FND LOG ===========================
2986:
2987: FUNCTION glfanc RETURN BOOLEAN IS
2988:
2989: cursor ccid_seq is
2990: select gl_code_combinations_s.NEXTVAL
2991: from sys.dual;
2992:
2993: -- ========================= FND LOG ===========================
2994: l_full_path VARCHAR2(100) := g_path || 'glfanc.';
3017: goto return_invalid;
3018: end if;
3019:
3020: update gl_dynamic_summ_combinations
3021: set code_combination_id = gl_code_combinations_s.NEXTVAL
3022: where code_combination_id = -1
3023: and dynamic_group_id = dyn_grp_id;
3024:
3025: -- ========================= FND LOG ===========================