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.OKS_BILLING_PUB dependencies on OKS_PROCESS_BILLING

Line 2297: FROM oks_process_billing

2293: Is
2294: Cursor billing_process (p_line_from IN NUMBER,
2295: p_line_to IN NUMBER) IS
2296: SELECT chr_id,cle_id,line_no
2297: FROM oks_process_billing
2298: WHERE line_no between p_line_from and p_line_to;
2299:
2300: -------------------------------------------------------------------------
2301: -- Begin partial period computation logic

Line 3038: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => Truncating oks_process_billing');

3034: --truncated during the restart of the parent
3035: If(FND_CONC_GLOBAL.request_data is null) THEN
3036:
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.

Line 3046: --v_truncstring := v_truncstring||'.oks_process_billing';

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';
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;

Line 3047: v_truncstring := 'Truncate Table OKS'||'.oks_process_billing';

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';
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:

Line 3112: INSERT /+ append / into oks_process_billing (chr_id,cle_id,line_no,currency_code)

3108: (p_contract_hdr_id is null) Then
3109:
3110: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Blind Query ' || ': with date '||p_date);
3111:
3112: INSERT /*+ append */ into oks_process_billing (chr_id,cle_id,line_no,currency_code)
3113: SELECT /*+ leading(lvl) ORDERED USE_HASH(line hdr sts as1)
3114: swap_join_inputs(hdr) swap_join_inputs(sts) */
3115: hdr.id hdr_id, line.id line_id, rownum, hdr.currency_code
3116: from (

Line 3155: INSERT /+ append / into oks_process_billing (chr_id,cle_id,line_no,currency_code)

3151: (p_contract_hdr_id is null) Then
3152:
3153: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query for Org id');
3154:
3155: INSERT /*+ append */ into oks_process_billing (chr_id,cle_id,line_no,currency_code)
3156: SELECT /*+ leading(lvl) ORDERED USE_HASH(line hdr sts as1)
3157: swap_join_inputs(hdr) swap_join_inputs(sts) */
3158: hdr.id hdr_id, line.id line_id, rownum, hdr.currency_code
3159: from (

Line 3196: INSERT into oks_process_billing (chr_id,cle_id,line_no,currency_code)

3192: (p_contract_hdr_id is not null) Then
3193:
3194: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query for Contract id');
3195:
3196: INSERT into oks_process_billing (chr_id,cle_id,line_no,currency_code)
3197:
3198: SELECT hdr.id hdr_id,line.id line_id,rownum,hdr.currency_code
3199: from okc_k_headers_b hdr, okc_k_lines_b line
3200: WHERE Hdr.id = line.dnz_chr_id

Line 3228: INSERT /+ append / into oks_process_billing (chr_id,cle_id,line_no,currency_code)

3224: (p_contract_hdr_id is null) Then
3225:
3226: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query for contract group and org id');
3227:
3228: INSERT /*+ append */ into oks_process_billing (chr_id,cle_id,line_no,currency_code)
3229: SELECT /*+ leading(lvl) ORDERED USE_HASH(line hdr sts as1 cgp)
3230: swap_join_inputs(hdr) swap_join_inputs(sts) swap_join_inputs(cgp) */
3231: hdr.id hdr_id, line.id line_id, rownum, hdr.currency_code
3232: from (

Line 3275: INSERT into oks_process_billing (chr_id,cle_id,line_no,currency_code)

3271: Else
3272:
3273: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query for rest of the parameters');
3274:
3275: INSERT into oks_process_billing (chr_id,cle_id,line_no,currency_code)
3276:
3277: SELECT hdr.id hdr_id,line.id line_id,rownum,hdr.currency_code
3278: from okc_k_headers_b hdr, okc_k_lines_b line
3279: WHERE Hdr.id = line.dnz_chr_id

Line 3312: ---this commit is required for the oks_process_billing table. should not be commented:

3308: Where rel.cle_id is not null );
3309:
3310: End if; -- End if clause for null parameters check
3311:
3312: ---this commit is required for the oks_process_billing table. should not be commented:
3313: commit;
3314: select count(*) into l_line_no from oks_process_billing;
3315:
3316: If l_write_log then

Line 3314: select count(*) into l_line_no from oks_process_billing;

3310: End if; -- End if clause for null parameters check
3311:
3312: ---this commit is required for the oks_process_billing table. should not be commented:
3313: commit;
3314: select count(*) into l_line_no from oks_process_billing;
3315:
3316: If l_write_log then
3317: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => Number of records in oks_process_billing is '||l_line_no);
3318: End If;

Line 3317: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => Number of records in oks_process_billing is '||l_line_no);

3313: commit;
3314: select count(*) into l_line_no from oks_process_billing;
3315:
3316: If l_write_log then
3317: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => Number of records in oks_process_billing is '||l_line_no);
3318: End If;
3319:
3320:
3321: END IF;

Line 3339: --SELECT ceil(count(*)/10) into l_slot_size from oks_process_billing;

3335:
3336: l_subrequests := 30; -- hard coded.
3337: l_slot_size := ceil(l_line_no / l_subrequests);
3338:
3339: --SELECT ceil(count(*)/10) into l_slot_size from oks_process_billing;
3340: l_min_boundary := 1;
3341: l_max_boundary := l_slot_size;
3342: FOR idx in 1..l_subrequests
3343: LOOP

Line 3394: -- v_truncstring := v_truncstring||'.oks_process_billing';

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';
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:

Line 3395: v_truncstring := 'Truncate Table OKS'||'.oks_process_billing';

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';
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:

Line 3439: --v_truncstring := v_truncstring||'.oks_process_billing';

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';
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:

Line 3440: v_truncstring := 'Truncate Table OKS'||'.oks_process_billing';

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';
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');