APPS.OKS_BILLING_PUB dependencies on DBMS_SQL

Line 3041: v_cursor := DBMS_SQL.OPEN_CURSOR;

3037: If l_write_log then
3038: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => Truncating oks_process_billing');
3039: End If;
3040:
3041: v_cursor := DBMS_SQL.OPEN_CURSOR;
3042: /*Following line is required to avoid GSCC errors at ARU creation.
3043: Concatination of string is required to avoid run time error.
3044: Ampersand 1 is taking value from un_oks param in dbdrv command line.*/
3045: --v_truncstring := 'Truncate Table oks';

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

3044: Ampersand 1 is taking value from un_oks param in dbdrv command line.*/
3045: --v_truncstring := 'Truncate Table oks';
3046: --v_truncstring := v_truncstring||'.oks_process_billing';
3047: v_truncstring := 'Truncate Table OKS'||'.oks_process_billing';
3048: DBMS_SQL.PARSE(v_cursor,v_truncstring,DBMS_SQL.V7);
3049: DBMS_SQL.CLOSE_CURSOR(v_cursor);
3050: END IF;
3051:
3052:

Line 3049: DBMS_SQL.CLOSE_CURSOR(v_cursor);

3045: --v_truncstring := 'Truncate Table oks';
3046: --v_truncstring := v_truncstring||'.oks_process_billing';
3047: v_truncstring := 'Truncate Table OKS'||'.oks_process_billing';
3048: DBMS_SQL.PARSE(v_cursor,v_truncstring,DBMS_SQL.V7);
3049: DBMS_SQL.CLOSE_CURSOR(v_cursor);
3050: END IF;
3051:
3052:
3053: /* This call to AR Feeder is done to process any termination records.

Line 3390: v_cursor := DBMS_SQL.OPEN_CURSOR;

3386: -- restart detected (sub-requests finished)...cleanup and exit.
3387: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => Commiting here');
3388: COMMIT;
3389:
3390: v_cursor := DBMS_SQL.OPEN_CURSOR;
3391: /* Following line is required to avoid GSCC errors at ARU creation.
3392: Concatination of string is required to avoid run time error */
3393: -- v_truncstring := 'Truncate Table oks';
3394: -- v_truncstring := v_truncstring||'.oks_process_billing';

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

3392: Concatination of string is required to avoid run time error */
3393: -- v_truncstring := 'Truncate Table oks';
3394: -- v_truncstring := v_truncstring||'.oks_process_billing';
3395: v_truncstring := 'Truncate Table OKS'||'.oks_process_billing';
3396: DBMS_SQL.PARSE(v_cursor,v_truncstring,DBMS_SQL.V7);
3397: DBMS_SQL.CLOSE_CURSOR(v_cursor);
3398:
3399:
3400: retcode := 0;

Line 3397: DBMS_SQL.CLOSE_CURSOR(v_cursor);

3393: -- v_truncstring := 'Truncate Table oks';
3394: -- v_truncstring := v_truncstring||'.oks_process_billing';
3395: v_truncstring := 'Truncate Table OKS'||'.oks_process_billing';
3396: DBMS_SQL.PARSE(v_cursor,v_truncstring,DBMS_SQL.V7);
3397: DBMS_SQL.CLOSE_CURSOR(v_cursor);
3398:
3399:
3400: retcode := 0;
3401: return;

Line 3435: v_cursor := DBMS_SQL.OPEN_CURSOR;

3431:
3432:
3433: COMMIT;
3434:
3435: v_cursor := DBMS_SQL.OPEN_CURSOR;
3436: /* Following line is required to avoid GSCC errors at ARU creation.
3437: Concatination of string is required to avoid run time error */
3438: --v_truncstring := 'Truncate Table oks';
3439: --v_truncstring := v_truncstring||'.oks_process_billing';

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

3437: Concatination of string is required to avoid run time error */
3438: --v_truncstring := 'Truncate Table oks';
3439: --v_truncstring := v_truncstring||'.oks_process_billing';
3440: v_truncstring := 'Truncate Table OKS'||'.oks_process_billing';
3441: DBMS_SQL.PARSE(v_cursor,v_truncstring,DBMS_SQL.V7);
3442: DBMS_SQL.CLOSE_CURSOR(v_cursor);
3443:
3444: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Billing_Main Ends');
3445:

Line 3442: DBMS_SQL.CLOSE_CURSOR(v_cursor);

3438: --v_truncstring := 'Truncate Table oks';
3439: --v_truncstring := v_truncstring||'.oks_process_billing';
3440: v_truncstring := 'Truncate Table OKS'||'.oks_process_billing';
3441: DBMS_SQL.PARSE(v_cursor,v_truncstring,DBMS_SQL.V7);
3442: DBMS_SQL.CLOSE_CURSOR(v_cursor);
3443:
3444: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Billing_Main Ends');
3445:
3446: EXCEPTION