eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_BATCH_UTILS dependencies on DBMS_DESCRIBE

Line 63: * 12-Jan-04 vvprabhu 115.38 Changed the calls to dbms_describe.dbms_procedure

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

Line 1939: l_argumentNameVar dbms_describe.varchar2_table;

1935: and b.executable_id = c.executable_id
1936: ;
1937: L_proc varchar2(80) := g_package||'.get_rpt_header';
1938: l_exec varchar2(80);
1939: l_argumentNameVar dbms_describe.varchar2_table;
1940: l_OverLoadNum dbms_describe.number_table;
1941: l_PosNum dbms_describe.number_table;
1942: l_LevelNum dbms_describe.number_table;
1943: l_DataTypeNum dbms_describe.number_table;

Line 1940: l_OverLoadNum dbms_describe.number_table;

1936: ;
1937: L_proc varchar2(80) := g_package||'.get_rpt_header';
1938: l_exec varchar2(80);
1939: l_argumentNameVar dbms_describe.varchar2_table;
1940: l_OverLoadNum dbms_describe.number_table;
1941: l_PosNum dbms_describe.number_table;
1942: l_LevelNum dbms_describe.number_table;
1943: l_DataTypeNum dbms_describe.number_table;
1944: l_defaultValueNum dbms_describe.number_table;

Line 1941: l_PosNum dbms_describe.number_table;

1937: L_proc varchar2(80) := g_package||'.get_rpt_header';
1938: l_exec varchar2(80);
1939: l_argumentNameVar dbms_describe.varchar2_table;
1940: l_OverLoadNum dbms_describe.number_table;
1941: l_PosNum dbms_describe.number_table;
1942: l_LevelNum dbms_describe.number_table;
1943: l_DataTypeNum dbms_describe.number_table;
1944: l_defaultValueNum dbms_describe.number_table;
1945: l_InOutNum dbms_describe.number_table;

Line 1942: l_LevelNum dbms_describe.number_table;

1938: l_exec varchar2(80);
1939: l_argumentNameVar dbms_describe.varchar2_table;
1940: l_OverLoadNum dbms_describe.number_table;
1941: l_PosNum dbms_describe.number_table;
1942: l_LevelNum dbms_describe.number_table;
1943: l_DataTypeNum dbms_describe.number_table;
1944: l_defaultValueNum dbms_describe.number_table;
1945: l_InOutNum dbms_describe.number_table;
1946: l_LengthNum dbms_describe.number_table;

Line 1943: l_DataTypeNum dbms_describe.number_table;

1939: l_argumentNameVar dbms_describe.varchar2_table;
1940: l_OverLoadNum dbms_describe.number_table;
1941: l_PosNum dbms_describe.number_table;
1942: l_LevelNum dbms_describe.number_table;
1943: l_DataTypeNum dbms_describe.number_table;
1944: l_defaultValueNum dbms_describe.number_table;
1945: l_InOutNum dbms_describe.number_table;
1946: l_LengthNum dbms_describe.number_table;
1947: l_PrecisionNum dbms_describe.number_table;

Line 1944: l_defaultValueNum dbms_describe.number_table;

1940: l_OverLoadNum dbms_describe.number_table;
1941: l_PosNum dbms_describe.number_table;
1942: l_LevelNum dbms_describe.number_table;
1943: l_DataTypeNum dbms_describe.number_table;
1944: l_defaultValueNum dbms_describe.number_table;
1945: l_InOutNum dbms_describe.number_table;
1946: l_LengthNum dbms_describe.number_table;
1947: l_PrecisionNum dbms_describe.number_table;
1948: l_ScaleNum dbms_describe.number_table;

Line 1945: l_InOutNum dbms_describe.number_table;

1941: l_PosNum dbms_describe.number_table;
1942: l_LevelNum dbms_describe.number_table;
1943: l_DataTypeNum dbms_describe.number_table;
1944: l_defaultValueNum dbms_describe.number_table;
1945: l_InOutNum dbms_describe.number_table;
1946: l_LengthNum dbms_describe.number_table;
1947: l_PrecisionNum dbms_describe.number_table;
1948: l_ScaleNum dbms_describe.number_table;
1949: l_RadixNum dbms_describe.number_table;

Line 1946: l_LengthNum dbms_describe.number_table;

1942: l_LevelNum dbms_describe.number_table;
1943: l_DataTypeNum dbms_describe.number_table;
1944: l_defaultValueNum dbms_describe.number_table;
1945: l_InOutNum dbms_describe.number_table;
1946: l_LengthNum dbms_describe.number_table;
1947: l_PrecisionNum dbms_describe.number_table;
1948: l_ScaleNum dbms_describe.number_table;
1949: l_RadixNum dbms_describe.number_table;
1950: l_SpareNum dbms_describe.number_table;

Line 1947: l_PrecisionNum dbms_describe.number_table;

1943: l_DataTypeNum dbms_describe.number_table;
1944: l_defaultValueNum dbms_describe.number_table;
1945: l_InOutNum dbms_describe.number_table;
1946: l_LengthNum dbms_describe.number_table;
1947: l_PrecisionNum dbms_describe.number_table;
1948: l_ScaleNum dbms_describe.number_table;
1949: l_RadixNum dbms_describe.number_table;
1950: l_SpareNum dbms_describe.number_table;
1951: l_cnt binary_integer := 1;

Line 1948: l_ScaleNum dbms_describe.number_table;

1944: l_defaultValueNum dbms_describe.number_table;
1945: l_InOutNum dbms_describe.number_table;
1946: l_LengthNum dbms_describe.number_table;
1947: l_PrecisionNum dbms_describe.number_table;
1948: l_ScaleNum dbms_describe.number_table;
1949: l_RadixNum dbms_describe.number_table;
1950: l_SpareNum dbms_describe.number_table;
1951: l_cnt binary_integer := 1;
1952: lc binary_integer := 0;

Line 1949: l_RadixNum dbms_describe.number_table;

1945: l_InOutNum dbms_describe.number_table;
1946: l_LengthNum dbms_describe.number_table;
1947: l_PrecisionNum dbms_describe.number_table;
1948: l_ScaleNum dbms_describe.number_table;
1949: l_RadixNum dbms_describe.number_table;
1950: l_SpareNum dbms_describe.number_table;
1951: l_cnt binary_integer := 1;
1952: lc binary_integer := 0;
1953: l_actn varchar2(80);

Line 1950: l_SpareNum dbms_describe.number_table;

1946: l_LengthNum dbms_describe.number_table;
1947: l_PrecisionNum dbms_describe.number_table;
1948: l_ScaleNum dbms_describe.number_table;
1949: l_RadixNum dbms_describe.number_table;
1950: l_SpareNum dbms_describe.number_table;
1951: l_cnt binary_integer := 1;
1952: lc binary_integer := 0;
1953: l_actn varchar2(80);
1954: Begin