DBA Data[Home] [Help]

APPS.AP_CUSTOM_TRIAL_BALANCE_PP_PKG dependencies on DBMS_SQL

Line 32: c := dbms_sql.open_cursor;

28: from user_objects
29: where object_name = 'JL_BR_AP_BALANCE_MAINTENANCE'
30: and object_type = 'PACKAGE BODY';
31:
32: c := dbms_sql.open_cursor;
33: statement := 'BEGIN
34: JL_BR_AP_BALANCE_MAINTENANCE.JL_BR_AP_BAL_MAINTENANCE' ||
35: '; END; ';
36:

Line 37: dbms_sql.parse(c, statement, dbms_sql.native);

33: statement := 'BEGIN
34: JL_BR_AP_BALANCE_MAINTENANCE.JL_BR_AP_BAL_MAINTENANCE' ||
35: '; END; ';
36:
37: dbms_sql.parse(c, statement, dbms_sql.native);
38:
39: rows := dbms_sql.execute(c);
40: dbms_sql.close_cursor(c);
41:

Line 39: rows := dbms_sql.execute(c);

35: '; END; ';
36:
37: dbms_sql.parse(c, statement, dbms_sql.native);
38:
39: rows := dbms_sql.execute(c);
40: dbms_sql.close_cursor(c);
41:
42: EXCEPTION
43: WHEN NO_DATA_FOUND THEN NULL;

Line 40: dbms_sql.close_cursor(c);

36:
37: dbms_sql.parse(c, statement, dbms_sql.native);
38:
39: rows := dbms_sql.execute(c);
40: dbms_sql.close_cursor(c);
41:
42: EXCEPTION
43: WHEN NO_DATA_FOUND THEN NULL;
44: WHEN OTHERS THEN NULL;