APPS.OKS_BILLING_PUB dependencies on DBMS_SQL

Line 6194: v_cursor := DBMS_SQL.OPEN_CURSOR;

6190: If l_write_log then
6191: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => Truncating oks_process_billing');
6192: End If;
6193:
6194: v_cursor := DBMS_SQL.OPEN_CURSOR;
6195: /*Following line is required to avoid GSCC errors at ARU creation.
6196: Concatination of string is required to avoid run time error.
6197: Ampersand 1 is taking value from un_oks param in dbdrv command line.*/
6198: --v_truncstring := 'Truncate Table oks';

Line 6201: DBMS_SQL.PARSE(v_cursor,v_truncstring,DBMS_SQL.V7);

6197: Ampersand 1 is taking value from un_oks param in dbdrv command line.*/
6198: --v_truncstring := 'Truncate Table oks';
6199: --v_truncstring := v_truncstring||'.oks_process_billing';
6200: v_truncstring := 'Truncate Table OKS'||'.oks_process_billing';
6201: DBMS_SQL.PARSE(v_cursor,v_truncstring,DBMS_SQL.V7);
6202: DBMS_SQL.CLOSE_CURSOR(v_cursor);
6203: END IF;
6204:
6205:

Line 6202: DBMS_SQL.CLOSE_CURSOR(v_cursor);

6198: --v_truncstring := 'Truncate Table oks';
6199: --v_truncstring := v_truncstring||'.oks_process_billing';
6200: v_truncstring := 'Truncate Table OKS'||'.oks_process_billing';
6201: DBMS_SQL.PARSE(v_cursor,v_truncstring,DBMS_SQL.V7);
6202: DBMS_SQL.CLOSE_CURSOR(v_cursor);
6203: END IF;
6204:
6205:
6206: /* This call to AR Feeder is done to process any termination records.

Line 6892: v_cursor := DBMS_SQL.OPEN_CURSOR;

6888: -- restart detected (sub-requests finished)...cleanup and exit.
6889: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => Commiting here');
6890: COMMIT;
6891:
6892: v_cursor := DBMS_SQL.OPEN_CURSOR;
6893: /* Following line is required to avoid GSCC errors at ARU creation.
6894: Concatination of string is required to avoid run time error */
6895: -- v_truncstring := 'Truncate Table oks';
6896: -- v_truncstring := v_truncstring||'.oks_process_billing';

Line 6898: DBMS_SQL.PARSE(v_cursor,v_truncstring,DBMS_SQL.V7);

6894: Concatination of string is required to avoid run time error */
6895: -- v_truncstring := 'Truncate Table oks';
6896: -- v_truncstring := v_truncstring||'.oks_process_billing';
6897: v_truncstring := 'Truncate Table OKS'||'.oks_process_billing';
6898: DBMS_SQL.PARSE(v_cursor,v_truncstring,DBMS_SQL.V7);
6899: DBMS_SQL.CLOSE_CURSOR(v_cursor);
6900:
6901:
6902: retcode := 0;

Line 6899: DBMS_SQL.CLOSE_CURSOR(v_cursor);

6895: -- v_truncstring := 'Truncate Table oks';
6896: -- v_truncstring := v_truncstring||'.oks_process_billing';
6897: v_truncstring := 'Truncate Table OKS'||'.oks_process_billing';
6898: DBMS_SQL.PARSE(v_cursor,v_truncstring,DBMS_SQL.V7);
6899: DBMS_SQL.CLOSE_CURSOR(v_cursor);
6900:
6901:
6902: retcode := 0;
6903: return;

Line 6937: v_cursor := DBMS_SQL.OPEN_CURSOR;

6933:
6934:
6935: COMMIT;
6936:
6937: v_cursor := DBMS_SQL.OPEN_CURSOR;
6938: /* Following line is required to avoid GSCC errors at ARU creation.
6939: Concatination of string is required to avoid run time error */
6940: --v_truncstring := 'Truncate Table oks';
6941: --v_truncstring := v_truncstring||'.oks_process_billing';

Line 6943: DBMS_SQL.PARSE(v_cursor,v_truncstring,DBMS_SQL.V7);

6939: Concatination of string is required to avoid run time error */
6940: --v_truncstring := 'Truncate Table oks';
6941: --v_truncstring := v_truncstring||'.oks_process_billing';
6942: v_truncstring := 'Truncate Table OKS'||'.oks_process_billing';
6943: DBMS_SQL.PARSE(v_cursor,v_truncstring,DBMS_SQL.V7);
6944: DBMS_SQL.CLOSE_CURSOR(v_cursor);
6945:
6946: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Billing_Main Ends');
6947:

Line 6944: DBMS_SQL.CLOSE_CURSOR(v_cursor);

6940: --v_truncstring := 'Truncate Table oks';
6941: --v_truncstring := v_truncstring||'.oks_process_billing';
6942: v_truncstring := 'Truncate Table OKS'||'.oks_process_billing';
6943: DBMS_SQL.PARSE(v_cursor,v_truncstring,DBMS_SQL.V7);
6944: DBMS_SQL.CLOSE_CURSOR(v_cursor);
6945:
6946: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Billing_Main Ends');
6947:
6948: EXCEPTION