59: * called to check for child records of derived
60: * factors.
61: * 30-Jun-03 vsethi 115.37 Changed reference for table ben_rptg_grp
62: * MLS compliant view ben_rptg_grp_v
63: * 12-Jan-04 vvprabhu 115.38 Changed the calls to dbms_describe.dbms_procedure
64: * to hr_general.describe_procedure in procedure
65: * get_rpt_header
66: * 21-Jun-04 kmahendr 115.39 Corrected Prompt for legal Entity.
67: * 20-Aug-04 nhunur 115.40 Added a procedure for person selection rule
1925: and b.executable_id = c.executable_id
1926: ;
1927: L_proc varchar2(80) := g_package||'.get_rpt_header';
1928: l_exec varchar2(80);
1929: l_argumentNameVar dbms_describe.varchar2_table;
1930: l_OverLoadNum dbms_describe.number_table;
1931: l_PosNum dbms_describe.number_table;
1932: l_LevelNum dbms_describe.number_table;
1933: l_DataTypeNum dbms_describe.number_table;
1926: ;
1927: L_proc varchar2(80) := g_package||'.get_rpt_header';
1928: l_exec varchar2(80);
1929: l_argumentNameVar dbms_describe.varchar2_table;
1930: l_OverLoadNum dbms_describe.number_table;
1931: l_PosNum dbms_describe.number_table;
1932: l_LevelNum dbms_describe.number_table;
1933: l_DataTypeNum dbms_describe.number_table;
1934: l_defaultValueNum dbms_describe.number_table;
1927: L_proc varchar2(80) := g_package||'.get_rpt_header';
1928: l_exec varchar2(80);
1929: l_argumentNameVar dbms_describe.varchar2_table;
1930: l_OverLoadNum dbms_describe.number_table;
1931: l_PosNum dbms_describe.number_table;
1932: l_LevelNum dbms_describe.number_table;
1933: l_DataTypeNum dbms_describe.number_table;
1934: l_defaultValueNum dbms_describe.number_table;
1935: l_InOutNum dbms_describe.number_table;
1928: l_exec varchar2(80);
1929: l_argumentNameVar dbms_describe.varchar2_table;
1930: l_OverLoadNum dbms_describe.number_table;
1931: l_PosNum dbms_describe.number_table;
1932: l_LevelNum dbms_describe.number_table;
1933: l_DataTypeNum dbms_describe.number_table;
1934: l_defaultValueNum dbms_describe.number_table;
1935: l_InOutNum dbms_describe.number_table;
1936: l_LengthNum dbms_describe.number_table;
1929: l_argumentNameVar dbms_describe.varchar2_table;
1930: l_OverLoadNum dbms_describe.number_table;
1931: l_PosNum dbms_describe.number_table;
1932: l_LevelNum dbms_describe.number_table;
1933: l_DataTypeNum dbms_describe.number_table;
1934: l_defaultValueNum dbms_describe.number_table;
1935: l_InOutNum dbms_describe.number_table;
1936: l_LengthNum dbms_describe.number_table;
1937: l_PrecisionNum dbms_describe.number_table;
1930: l_OverLoadNum dbms_describe.number_table;
1931: l_PosNum dbms_describe.number_table;
1932: l_LevelNum dbms_describe.number_table;
1933: l_DataTypeNum dbms_describe.number_table;
1934: l_defaultValueNum dbms_describe.number_table;
1935: l_InOutNum dbms_describe.number_table;
1936: l_LengthNum dbms_describe.number_table;
1937: l_PrecisionNum dbms_describe.number_table;
1938: l_ScaleNum dbms_describe.number_table;
1931: l_PosNum dbms_describe.number_table;
1932: l_LevelNum dbms_describe.number_table;
1933: l_DataTypeNum dbms_describe.number_table;
1934: l_defaultValueNum dbms_describe.number_table;
1935: l_InOutNum dbms_describe.number_table;
1936: l_LengthNum dbms_describe.number_table;
1937: l_PrecisionNum dbms_describe.number_table;
1938: l_ScaleNum dbms_describe.number_table;
1939: l_RadixNum dbms_describe.number_table;
1932: l_LevelNum dbms_describe.number_table;
1933: l_DataTypeNum dbms_describe.number_table;
1934: l_defaultValueNum dbms_describe.number_table;
1935: l_InOutNum dbms_describe.number_table;
1936: l_LengthNum dbms_describe.number_table;
1937: l_PrecisionNum dbms_describe.number_table;
1938: l_ScaleNum dbms_describe.number_table;
1939: l_RadixNum dbms_describe.number_table;
1940: l_SpareNum dbms_describe.number_table;
1933: l_DataTypeNum dbms_describe.number_table;
1934: l_defaultValueNum dbms_describe.number_table;
1935: l_InOutNum dbms_describe.number_table;
1936: l_LengthNum dbms_describe.number_table;
1937: l_PrecisionNum dbms_describe.number_table;
1938: l_ScaleNum dbms_describe.number_table;
1939: l_RadixNum dbms_describe.number_table;
1940: l_SpareNum dbms_describe.number_table;
1941: l_cnt binary_integer := 1;
1934: l_defaultValueNum dbms_describe.number_table;
1935: l_InOutNum dbms_describe.number_table;
1936: l_LengthNum dbms_describe.number_table;
1937: l_PrecisionNum dbms_describe.number_table;
1938: l_ScaleNum dbms_describe.number_table;
1939: l_RadixNum dbms_describe.number_table;
1940: l_SpareNum dbms_describe.number_table;
1941: l_cnt binary_integer := 1;
1942: lc binary_integer := 0;
1935: l_InOutNum dbms_describe.number_table;
1936: l_LengthNum dbms_describe.number_table;
1937: l_PrecisionNum dbms_describe.number_table;
1938: l_ScaleNum dbms_describe.number_table;
1939: l_RadixNum dbms_describe.number_table;
1940: l_SpareNum dbms_describe.number_table;
1941: l_cnt binary_integer := 1;
1942: lc binary_integer := 0;
1943: l_actn varchar2(80);
1936: l_LengthNum dbms_describe.number_table;
1937: l_PrecisionNum dbms_describe.number_table;
1938: l_ScaleNum dbms_describe.number_table;
1939: l_RadixNum dbms_describe.number_table;
1940: l_SpareNum dbms_describe.number_table;
1941: l_cnt binary_integer := 1;
1942: lc binary_integer := 0;
1943: l_actn varchar2(80);
1944: Begin