DBA Data[Home] [Help]

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 1929: l_argumentNameVar dbms_describe.varchar2_table;

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;

Line 1930: l_OverLoadNum 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;

Line 1931: l_PosNum 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;

Line 1932: l_LevelNum 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;

Line 1933: l_DataTypeNum 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;

Line 1934: l_defaultValueNum 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;

Line 1935: l_InOutNum 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;

Line 1936: l_LengthNum 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;

Line 1937: l_PrecisionNum 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;

Line 1938: l_ScaleNum 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;
1942: lc binary_integer := 0;

Line 1939: l_RadixNum 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;
1943: l_actn varchar2(80);

Line 1940: l_SpareNum 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);
1944: Begin