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_BILL_REC_PUB dependencies on OKS_BILL_REC_PUB

Line 1: PACKAGE BODY OKS_BILL_REC_PUB AS

1: PACKAGE BODY OKS_BILL_REC_PUB AS
2: /* $Header: OKSPBRCB.pls 120.79.12020000.6 2013/04/16 15:53:11 mchandak ship $ */
3:
4:
5: --------------------------------------------

Line 11: G_MODULE_CURRENT CONSTANT VARCHAR2(255) := 'oks.plsql.oks_bill_rec_pub';

7: --------------------------------------------
8: g_bcl_id NUMBER;
9: g_bsl_id NUMBER;
10: g_credit_amount NUMBER;
11: G_MODULE_CURRENT CONSTANT VARCHAR2(255) := 'oks.plsql.oks_bill_rec_pub';
12: ------------------------------------------------------------------------
13: G_LOG_YES_NO Varchar2(10); --added by ansraj for 14016663
14: ------------------------------------------------------------------------
15: -- Begin partial period computation logic

Line 423: l_cov_tbl OKS_BILL_REC_PUB.COVERED_TBL;

419: inv_rec INV_ITEM_CSR%ROWTYPE;
420: rules_rec RULES_CSR%ROWTYPE;
421:
422:
423: l_cov_tbl OKS_BILL_REC_PUB.COVERED_TBL;
424: l_return_status VARCHAR2(20);
425: l_msg_data VARCHAR2(2000);
426: l_freq VARCHAR2(20);
427: l_temp_bcl_id_ri NUMBER := -11; -- stores the bcl_id for invoice line

Line 453: OKS_BILL_REC_PUB.INSERT_BCL

449:
450: IF (p_bill_action in ('RI','SRI')) THEN
451:
452:
453: OKS_BILL_REC_PUB.INSERT_BCL
454: (
455: P_CALLEDFROM => 1,
456: X_RETURN_STAT => l_return_status,
457: P_CLE_ID => p_top_line_id,

Line 501: OKS_BILL_REC_PUB.Insert_all_subline

497: l_cov_tbl(1).amount := p_con_terminate_amount; --p_amount;
498: l_cov_tbl(1).bcl_amount := p_con_terminate_amount; --p_amount;
499: l_cov_tbl(1).date_to_interface := sysdate;
500:
501: OKS_BILL_REC_PUB.Insert_all_subline
502: (
503: P_CALLEDFROM => 1,
504: X_RETURN_STAT => l_return_status,
505: P_COVERED_TBL => l_cov_tbl,

Line 1020: OKS_BILL_REC_PUB.Usage_qty_to_bill

1016: -- Developer Mani Choudhary
1017: -- Date 11-JUN-2005
1018: -- Added additional period_type parameter
1019: -------------------------------------------------------------------------
1020: OKS_BILL_REC_PUB.Usage_qty_to_bill
1021: (
1022: P_calledfrom => 3, --1 for normal , 2 for preview,
1023: P_cle_id => cur.id,
1024: P_Usage_type => p_usage_type,

Line 3132: 'calling OKS_BILL_REC_PUB.Terminate_PPC with parameters P_period_start '||l_period_start||', P_period_type '||l_period_type

3128: l_period_type is not null
3129: THEN
3130: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3131: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Pre_Terminate_Extwar',
3132: 'calling OKS_BILL_REC_PUB.Terminate_PPC with parameters P_period_start '||l_period_start||', P_period_type '||l_period_type
3133: ||' P_override_amount ' ||p_termination_amount||'p_con_terminate_amount '||p_con_termination_amount||' ,P_suppress_credit'||P_suppress_credit);
3134: END IF;
3135: OKS_BILL_REC_PUB.Terminate_PPC
3136: (P_termination_date => l_max_date_billed_from,

Line 3135: OKS_BILL_REC_PUB.Terminate_PPC

3131: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Pre_Terminate_Extwar',
3132: 'calling OKS_BILL_REC_PUB.Terminate_PPC with parameters P_period_start '||l_period_start||', P_period_type '||l_period_type
3133: ||' P_override_amount ' ||p_termination_amount||'p_con_terminate_amount '||p_con_termination_amount||' ,P_suppress_credit'||P_suppress_credit);
3134: END IF;
3135: OKS_BILL_REC_PUB.Terminate_PPC
3136: (P_termination_date => l_max_date_billed_from,
3137: p_end_date => l_max_date_billed_to,
3138: P_top_line_id => l_top_line_id,
3139: P_cp_line_id => l_cov_line_id, --01-APR-2006 mchoudha passing l_cov_line_id

Line 3383: 'calling OKS_BILL_REC_PUB.Terminate_PPC with parameters l_period_start '||l_period_start||', l_period_type '||l_period_type

3379: THEN
3380: IF l_lse_id <> 13 OR nvl(l_usage_type,'XYZ') = 'NPR' THEN /* Modified for Bug#14647106*/
3381: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3382: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Pre_Terminate_srvc.Service',
3383: 'calling OKS_BILL_REC_PUB.Terminate_PPC with parameters l_period_start '||l_period_start||', l_period_type '||l_period_type
3384: ||' P_override_amount ' ||p_termination_amount||'p_con_terminate_amount '||p_con_termination_amount||' ,P_suppress_credit'||P_suppress_credit);
3385: END IF;
3386:
3387: OKS_BILL_REC_PUB.Terminate_PPC

Line 3387: OKS_BILL_REC_PUB.Terminate_PPC

3383: 'calling OKS_BILL_REC_PUB.Terminate_PPC with parameters l_period_start '||l_period_start||', l_period_type '||l_period_type
3384: ||' P_override_amount ' ||p_termination_amount||'p_con_terminate_amount '||p_con_termination_amount||' ,P_suppress_credit'||P_suppress_credit);
3385: END IF;
3386:
3387: OKS_BILL_REC_PUB.Terminate_PPC
3388: (P_termination_date => l_termination_date,
3389: p_end_date => l_date_rec.end_date,
3390: P_top_line_id => p_k_line_id,
3391: P_cp_line_id => NULL,

Line 3407: 'calling OKS_BILL_REC_PUB.Create_trx_records with parameters l_period_start '||l_period_start||', l_period_type '||l_period_type

3403: --For usage , period start should be SERVICE
3404: -- and amount based termination will be based on billing not on price uom
3405: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3406: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Pre_Terminate_srvc.Usage',
3407: 'calling OKS_BILL_REC_PUB.Create_trx_records with parameters l_period_start '||l_period_start||', l_period_type '||l_period_type
3408: ||' P_override_amount ' ||p_termination_amount||'p_con_terminate_amount '||p_con_termination_amount||' ,P_suppress_credit'||P_suppress_credit);
3409: END IF;
3410:
3411: l_period_start := 'SERVICE';

Line 3671: OKS_BILL_REC_PUB.Pre_Terminate_Amount

3667: x_msg_data => l_msg_data);
3668:
3669: l_termination_amount := p_termination_amount;
3670:
3671: OKS_BILL_REC_PUB.Pre_Terminate_Amount
3672: ( p_id => p_line_id,
3673: p_terminate_date => l_termination_date,
3674: p_flag => 1,
3675: X_Amount => l_con_termination_amount,

Line 6306: -- call oks_bill_rec_pub.Get_prorated_Usage_Qty to get the prorated usage

6302: -------------------------------------------------------------------------
6303: -- Begin partial period computation logic
6304: -- Developer Mani Choudhary
6305: -- Date 11-JUN-2005
6306: -- call oks_bill_rec_pub.Get_prorated_Usage_Qty to get the prorated usage
6307: -------------------------------------------------------------------------
6308: IF p_period_type IS NOT NULL AND
6309: p_period_start IS NOT NULL
6310: THEN

Line 6316: l_qty := OKS_BILL_REC_PUB.Get_Prorated_Usage_Qty

6312: FETCH l_Billuom_csr INTO l_uom_code;
6313: CLOSE l_Billuom_csr;
6314: IF (p_calledfrom = 3) THEN
6315:
6316: l_qty := OKS_BILL_REC_PUB.Get_Prorated_Usage_Qty
6317: (
6318: p_start_date => p_cov_prd_start_date,
6319: p_end_date => p_cov_prd_end_date-1,
6320: p_qty => l_qty,

Line 6330: l_qty := OKS_BILL_REC_PUB.Get_Prorated_Usage_Qty

6326: --IF nvl(l_qty,0) = 0 THEN
6327: -- RAISE G_EXCEPTION_HALT_VALIDATION;
6328: --END IF;
6329: ELSE
6330: l_qty := OKS_BILL_REC_PUB.Get_Prorated_Usage_Qty
6331: (
6332: p_start_date => p_cov_prd_start_date,
6333: p_end_date => p_cov_prd_end_date,
6334: p_qty => l_qty,

Line 7880: l_cov_tbl OKS_BILL_REC_PUB.COVERED_TBL;

7876: l_billed_rec l_billed_csr%rowtype;
7877: l_amount_rec l_amount_csr%rowtype;
7878: qty_uom_rec qty_uom_csr%rowtype;
7879: l_item_rec l_inv_item_csr%rowtype;
7880: l_cov_tbl OKS_BILL_REC_PUB.COVERED_TBL;
7881:
7882:
7883: l_date_billed_from DATE;
7884: l_date_billed_to DATE;

Line 7973: OKS_BILL_REC_PUB.Insert_bcl

7969:
7970:
7971: If l_ad_cnt = 0 Then
7972:
7973: OKS_BILL_REC_PUB.Insert_bcl
7974: (
7975: p_calledfrom => p_calledfrom,
7976: x_return_stat => l_return_status,
7977: p_cle_id => l_billed_cle_id,

Line 8055: OKS_BILL_REC_PUB.Insert_all_subline

8051: l_ptr := l_ptr + 1;
8052:
8053: End Loop; -- subline loop
8054:
8055: OKS_BILL_REC_PUB.Insert_all_subline
8056: (
8057: p_calledfrom => p_calledfrom,
8058: x_return_stat => l_return_status,
8059: p_covered_tbl => l_cov_tbl,

Line 8825: 'calling OKS_BILL_REC_PUB.Terminate_PPC with parameters l_period_start '||l_period_start||', l_period_type '||l_period_type

8821: THEN
8822: IF l_lse_id <> 13 OR nvl(l_usage_type,'XYZ') = 'NPR' THEN
8823: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
8824: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_cp.Service',
8825: 'calling OKS_BILL_REC_PUB.Terminate_PPC with parameters l_period_start '||l_period_start||', l_period_type '||l_period_type
8826: ||' P_override_amount ' ||p_override_amount||'p_con_terminate_amount '||p_con_terminate_amount||' ,P_suppress_credit'||P_suppress_credit);
8827: END IF;
8828: OKS_BILL_REC_PUB.Terminate_PPC
8829: (P_termination_date => l_termination_date,

Line 8828: OKS_BILL_REC_PUB.Terminate_PPC

8824: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_cp.Service',
8825: 'calling OKS_BILL_REC_PUB.Terminate_PPC with parameters l_period_start '||l_period_start||', l_period_type '||l_period_type
8826: ||' P_override_amount ' ||p_override_amount||'p_con_terminate_amount '||p_con_terminate_amount||' ,P_suppress_credit'||P_suppress_credit);
8827: END IF;
8828: OKS_BILL_REC_PUB.Terminate_PPC
8829: (P_termination_date => l_termination_date,
8830: p_end_date => l_max_date,
8831: P_top_line_id => p_top_line_id,
8832: P_cp_line_id => p_cp_line_id,

Line 8846: 'calling OKS_BILL_REC_PUB.Create_trx_records with parameters l_period_start '||l_period_start||', l_period_type '||l_period_type

8842: ELSE
8843: --This procedure will be called for usage amount based termination
8844: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
8845: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_cp.Usage',
8846: 'calling OKS_BILL_REC_PUB.Create_trx_records with parameters l_period_start '||l_period_start||', l_period_type '||l_period_type
8847: ||' P_override_amount ' ||p_override_amount||'p_con_terminate_amount '||p_con_terminate_amount||' ,P_suppress_credit'||P_suppress_credit);
8848: END IF;
8849: Create_trx_records(
8850: p_called_from => 1,

Line 11126: p_token1_value => 'OKS_BILL_REC_PUB.Get_partial_term_amount',

11122: WHEN INVALID_UOM_EXCEPTION THEN
11123: OKC_API.SET_MESSAGE(p_app_name => 'OKS',
11124: p_msg_name => 'OKS_INVD_UOM_CODE',
11125: p_token1 => 'OKS_API_NAME',
11126: p_token1_value => 'OKS_BILL_REC_PUB.Get_partial_term_amount',
11127: p_token2 => 'UOM_CODE',
11128: p_token2_value => P_uom);
11129: IF cs_validate_uom%ISOPEN THEN
11130: CLOSE cs_validate_uom;

Line 11150: END OKS_BILL_REC_PUB ;

11146: RETURN NULL;
11147: END Get_partial_term_amount;
11148:
11149:
11150: END OKS_BILL_REC_PUB ;
11151:
11152: