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.PAYWSDYG_PKG dependencies on DBMS_SQL

Line 21: g_dyt_pkg_head dbms_sql.varchar2s;

17:
18:
19: -- To store the dynamic triggers as a package use array so as to overcome
20: -- the limit of 32767
21: g_dyt_pkg_head dbms_sql.varchar2s;
22: g_dyt_pkg_body dbms_sql.varchar2s;
23: g_dyt_pkg_hindex number := 0;
24: g_dyt_pkg_bindex number := 0;
25:

Line 22: g_dyt_pkg_body dbms_sql.varchar2s;

18:
19: -- To store the dynamic triggers as a package use array so as to overcome
20: -- the limit of 32767
21: g_dyt_pkg_head dbms_sql.varchar2s;
22: g_dyt_pkg_body dbms_sql.varchar2s;
23: g_dyt_pkg_hindex number := 0;
24: g_dyt_pkg_bindex number := 0;
25:
26: -- Global for PAY schema name

Line 81: -- | parsed using dbms_sql procedure. |

77: -- | DESCRIPTION: The dynamic generation will build up code and store it in an |
78: -- | an array of varchar2(32767). The task of this procedure is to split|
79: -- | the above array elements into array elements of size 254. This is |
80: -- | required so as to the package body of more than 32 K size can be |
81: -- | parsed using dbms_sql procedure. |
82: -- | PARAMETERS : p_new_code_tbl - A big fat table containing rows of new code |
83: -- | p_body - Flag, false => package header, true => body |
84: -- | RETURNS : None, simply sets global placeholder |
85: -- | RAISES : None |

Line 744: l_desc Dbms_Sql.Desc_Tab;

740: ) IS
741: --
742: l_csr INTEGER;
743: l_cols INTEGER;
744: l_desc Dbms_Sql.Desc_Tab;
745: l_name VARCHAR2(35);
746: l_code VARCHAR2(32767) := p_code;
747: l_rc NUMBER;
748: --

Line 752: l_csr := Dbms_Sql.Open_Cursor;

748: --
749: BEGIN
750: --
751: -- Open a dynamic SQL cursor for parsing and describing
752: l_csr := Dbms_Sql.Open_Cursor;
753: --
754: -- Replace the placeholders but add a colon to the start of local
755: -- variable names (turning them into bind variables) so that the
756: -- statement will parse OK

Line 762: Dbms_Sql.Parse(l_csr,l_code,Dbms_Sql.Native);

758: --
759: BEGIN
760: --
761: -- Parse and describe the statement
762: Dbms_Sql.Parse(l_csr,l_code,Dbms_Sql.Native);
763: Dbms_Sql.Describe_Columns(l_csr,l_cols,l_desc);
764: Dbms_Sql.Close_Cursor(l_csr);
765: EXCEPTION
766: WHEN OTHERS THEN

Line 763: Dbms_Sql.Describe_Columns(l_csr,l_cols,l_desc);

759: BEGIN
760: --
761: -- Parse and describe the statement
762: Dbms_Sql.Parse(l_csr,l_code,Dbms_Sql.Native);
763: Dbms_Sql.Describe_Columns(l_csr,l_cols,l_desc);
764: Dbms_Sql.Close_Cursor(l_csr);
765: EXCEPTION
766: WHEN OTHERS THEN
767: --

Line 764: Dbms_Sql.Close_Cursor(l_csr);

760: --
761: -- Parse and describe the statement
762: Dbms_Sql.Parse(l_csr,l_code,Dbms_Sql.Native);
763: Dbms_Sql.Describe_Columns(l_csr,l_cols,l_desc);
764: Dbms_Sql.Close_Cursor(l_csr);
765: EXCEPTION
766: WHEN OTHERS THEN
767: --
768: -- Turn all errors into one of our custom errors

Line 769: Dbms_Sql.Close_Cursor(l_csr);

765: EXCEPTION
766: WHEN OTHERS THEN
767: --
768: -- Turn all errors into one of our custom errors
769: Dbms_Sql.Close_Cursor(l_csr);
770: fnd_message.set_name('PAY','PAY_DYG_CANNOT_ANALYSE_QUERY');
771: app_exception.raise_exception;
772: END;
773: --

Line 1323: -- Runs a SQL statement using the dbms_sql package. No bind variables

1319: END module_ok;
1320:
1321: -- -------------------- build_dyt_pkg_from_tbl ----------------------------
1322: -- Description:
1323: -- Runs a SQL statement using the dbms_sql package. No bind variables
1324: -- allowed. This procedure uses pl/sql table of varchar2 as an input
1325: -- and hence is suitable to compile very large packages i.e more than
1326: -- 32767 char.
1327: -- ------------------------------------------------------------------------

Line 1329: p_package_body dbms_sql.varchar2s,

1325: -- and hence is suitable to compile very large packages i.e more than
1326: -- 32767 char.
1327: -- ------------------------------------------------------------------------
1328: procedure build_dyt_pkg_from_tbl(
1329: p_package_body dbms_sql.varchar2s,
1330: p_package_index number,
1331: p_body boolean )
1332: is
1333: l_csr_sql integer;

Line 1342: l_csr_sql := dbms_sql.open_cursor;

1338: hr_utility.set_location(l_proc,10);
1339: hr_utility.trace('p_package_index - '||p_package_index);
1340:
1341: --
1342: l_csr_sql := dbms_sql.open_cursor;
1343: dbms_sql.parse( l_csr_sql, p_package_body,1,p_package_index,p_body, dbms_sql.v7 );
1344: l_rows := dbms_sql.execute( l_csr_sql );
1345: dbms_sql.close_cursor( l_csr_sql );
1346: --

Line 1343: dbms_sql.parse( l_csr_sql, p_package_body,1,p_package_index,p_body, dbms_sql.v7 );

1339: hr_utility.trace('p_package_index - '||p_package_index);
1340:
1341: --
1342: l_csr_sql := dbms_sql.open_cursor;
1343: dbms_sql.parse( l_csr_sql, p_package_body,1,p_package_index,p_body, dbms_sql.v7 );
1344: l_rows := dbms_sql.execute( l_csr_sql );
1345: dbms_sql.close_cursor( l_csr_sql );
1346: --
1347:

Line 1344: l_rows := dbms_sql.execute( l_csr_sql );

1340:
1341: --
1342: l_csr_sql := dbms_sql.open_cursor;
1343: dbms_sql.parse( l_csr_sql, p_package_body,1,p_package_index,p_body, dbms_sql.v7 );
1344: l_rows := dbms_sql.execute( l_csr_sql );
1345: dbms_sql.close_cursor( l_csr_sql );
1346: --
1347:
1348: hr_utility.set_location(l_proc,900);

Line 1345: dbms_sql.close_cursor( l_csr_sql );

1341: --
1342: l_csr_sql := dbms_sql.open_cursor;
1343: dbms_sql.parse( l_csr_sql, p_package_body,1,p_package_index,p_body, dbms_sql.v7 );
1344: l_rows := dbms_sql.execute( l_csr_sql );
1345: dbms_sql.close_cursor( l_csr_sql );
1346: --
1347:
1348: hr_utility.set_location(l_proc,900);
1349: exception