APPS.JG_XLA_GL_TRANSFER_PKG dependencies on DBMS_SQL

Line 119: l_cursor := dbms_sql.open_cursor;

115: l_start_date := 'to_date(''' || to_char(p_start_date,'dd/mm/yyyy') || '''' || ',''dd/mm/yyyy'')';
116: l_end_date := 'to_date(''' || to_char(p_end_date,'dd/mm/yyyy') || '''' || ',''dd/mm/yyyy'')';
117:
118: -- Create the SQL statement
119: l_cursor := dbms_sql.open_cursor;
120: l_sqlstmt := 'BEGIN jl_xla_gl_transfer_pkg.jl_xla_gl_transfer( ' ||
121: l_request_id || ',' ||
122: l_transfer_run_id || ',' ||
123: l_start_date || ',' ||

Line 127: dbms_sql.parse (l_cursor, l_sqlstmt, dbms_sql.native);

123: l_start_date || ',' ||
124: l_end_date || ' ); END;';
125:
126: -- Parse the SQL statement
127: dbms_sql.parse (l_cursor, l_sqlstmt, dbms_sql.native);
128:
129: -- Execute the SQL statement
130: l_ignore := dbms_sql.execute (l_cursor);
131:

Line 130: l_ignore := dbms_sql.execute (l_cursor);

126: -- Parse the SQL statement
127: dbms_sql.parse (l_cursor, l_sqlstmt, dbms_sql.native);
128:
129: -- Execute the SQL statement
130: l_ignore := dbms_sql.execute (l_cursor);
131:
132: -- Close the cursor
133: dbms_sql.close_cursor (l_cursor);
134:

Line 133: dbms_sql.close_cursor (l_cursor);

129: -- Execute the SQL statement
130: l_ignore := dbms_sql.execute (l_cursor);
131:
132: -- Close the cursor
133: dbms_sql.close_cursor (l_cursor);
134:
135: EXCEPTION
136: WHEN others THEN
137: IF (dbms_sql.is_open(l_cursor)) THEN

Line 137: IF (dbms_sql.is_open(l_cursor)) THEN

133: dbms_sql.close_cursor (l_cursor);
134:
135: EXCEPTION
136: WHEN others THEN
137: IF (dbms_sql.is_open(l_cursor)) THEN
138: dbms_sql.close_cursor(l_cursor);
139: END IF;
140: APP_EXCEPTION.RAISE_EXCEPTION;
141: END;

Line 138: dbms_sql.close_cursor(l_cursor);

134:
135: EXCEPTION
136: WHEN others THEN
137: IF (dbms_sql.is_open(l_cursor)) THEN
138: dbms_sql.close_cursor(l_cursor);
139: END IF;
140: APP_EXCEPTION.RAISE_EXCEPTION;
141: END;
142: