DBA Data[Home] [Help]

APPS.GL_FLEX_INSERT_PKG dependencies on GL_CODE_COMBINATIONS_S

Line 739: segment1 gl_code_combinations.segment1%TYPE;

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;

Line 740: segment2 gl_code_combinations.segment2%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;

Line 741: segment3 gl_code_combinations.segment3%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;

Line 742: segment4 gl_code_combinations.segment4%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;

Line 743: segment5 gl_code_combinations.segment5%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;

Line 744: segment6 gl_code_combinations.segment6%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;

Line 745: segment7 gl_code_combinations.segment7%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;

Line 746: segment8 gl_code_combinations.segment8%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;

Line 747: segment9 gl_code_combinations.segment9%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;

Line 748: segment10 gl_code_combinations.segment10%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;

Line 749: segment11 gl_code_combinations.segment11%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;

Line 750: segment12 gl_code_combinations.segment12%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;

Line 751: segment13 gl_code_combinations.segment13%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;

Line 752: segment14 gl_code_combinations.segment14%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;

Line 753: segment15 gl_code_combinations.segment15%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;

Line 754: segment16 gl_code_combinations.segment16%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;

Line 755: segment17 gl_code_combinations.segment17%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;

Line 756: segment18 gl_code_combinations.segment18%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;

Line 757: segment19 gl_code_combinations.segment19%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;

Line 758: segment20 gl_code_combinations.segment20%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;

Line 759: segment21 gl_code_combinations.segment21%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;

Line 760: segment22 gl_code_combinations.segment22%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;

Line 761: segment23 gl_code_combinations.segment23%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;

Line 762: segment24 gl_code_combinations.segment24%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;

Line 763: segment25 gl_code_combinations.segment25%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;

Line 764: segment26 gl_code_combinations.segment26%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;

Line 765: segment27 gl_code_combinations.segment27%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:

Line 766: segment28 gl_code_combinations.segment28%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:
770: -- ========================= FND LOG ===========================

Line 767: segment29 gl_code_combinations.segment29%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 ===========================
771: l_full_path VARCHAR2(100) := g_path || 'glfini.';

Line 768: segment30 gl_code_combinations.segment30%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.';
772: -- ========================= FND LOG ===========================

Line 2990: select gl_code_combinations_s.NEXTVAL

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

Line 3021: set code_combination_id = gl_code_combinations_s.NEXTVAL

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 ===========================