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.56.12010000.2 2008/10/22 12:50:30 ssreekum 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: -- Begin partial period computation logic
14: -- Developer Mani Choudhary
15: -- Date 27-MAY-2005

Line 420: l_cov_tbl OKS_BILL_REC_PUB.COVERED_TBL;

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

Line 450: OKS_BILL_REC_PUB.INSERT_BCL

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

Line 498: OKS_BILL_REC_PUB.Insert_all_subline

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

Line 1001: OKS_BILL_REC_PUB.Usage_qty_to_bill

997: -- Developer Mani Choudhary
998: -- Date 11-JUN-2005
999: -- Added additional period_type parameter
1000: -------------------------------------------------------------------------
1001: OKS_BILL_REC_PUB.Usage_qty_to_bill
1002: (
1003: P_calledfrom => 3, --1 for normal , 2 for preview,
1004: P_cle_id => cur.id,
1005: P_Usage_type => p_usage_type,

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

3114: l_period_type is not null
3115: THEN
3116: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3117: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Pre_Terminate_Extwar',
3118: 'calling OKS_BILL_REC_PUB.Terminate_PPC with parameters P_period_start '||l_period_start||', P_period_type '||l_period_type
3119: ||' P_override_amount ' ||p_termination_amount||'p_con_terminate_amount '||p_con_termination_amount||' ,P_suppress_credit'||P_suppress_credit);
3120: END IF;
3121: OKS_BILL_REC_PUB.Terminate_PPC
3122: (P_termination_date => l_max_date_billed_from,

Line 3121: OKS_BILL_REC_PUB.Terminate_PPC

3117: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Pre_Terminate_Extwar',
3118: 'calling OKS_BILL_REC_PUB.Terminate_PPC with parameters P_period_start '||l_period_start||', P_period_type '||l_period_type
3119: ||' P_override_amount ' ||p_termination_amount||'p_con_terminate_amount '||p_con_termination_amount||' ,P_suppress_credit'||P_suppress_credit);
3120: END IF;
3121: OKS_BILL_REC_PUB.Terminate_PPC
3122: (P_termination_date => l_max_date_billed_from,
3123: p_end_date => l_max_date_billed_to,
3124: P_top_line_id => l_top_line_id,
3125: P_cp_line_id => l_cov_line_id, --01-APR-2006 mchoudha passing l_cov_line_id

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

3355: THEN
3356: IF l_date_rec.lse_id <> 13 OR nvl(l_usage_type,'XYZ') = 'NPR' THEN
3357: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3358: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Pre_Terminate_srvc.Service',
3359: 'calling OKS_BILL_REC_PUB.Terminate_PPC with parameters l_period_start '||l_period_start||', l_period_type '||l_period_type
3360: ||' P_override_amount ' ||p_termination_amount||'p_con_terminate_amount '||p_con_termination_amount||' ,P_suppress_credit'||P_suppress_credit);
3361: END IF;
3362:
3363: OKS_BILL_REC_PUB.Terminate_PPC

Line 3363: OKS_BILL_REC_PUB.Terminate_PPC

3359: 'calling OKS_BILL_REC_PUB.Terminate_PPC with parameters l_period_start '||l_period_start||', l_period_type '||l_period_type
3360: ||' P_override_amount ' ||p_termination_amount||'p_con_terminate_amount '||p_con_termination_amount||' ,P_suppress_credit'||P_suppress_credit);
3361: END IF;
3362:
3363: OKS_BILL_REC_PUB.Terminate_PPC
3364: (P_termination_date => l_termination_date,
3365: p_end_date => l_date_rec.end_date,
3366: P_top_line_id => p_k_line_id,
3367: P_cp_line_id => NULL,

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

3379: --For usage , period start should be SERVICE
3380: -- and amount based termination will be based on billing not on price uom
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.Usage',
3383: 'calling OKS_BILL_REC_PUB.Create_trx_records 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: l_period_start := 'SERVICE';

Line 3645: OKS_BILL_REC_PUB.Pre_Terminate_Amount

3641: x_msg_data => l_msg_data);
3642:
3643: l_termination_amount := p_termination_amount;
3644:
3645: OKS_BILL_REC_PUB.Pre_Terminate_Amount
3646: ( p_id => p_line_id,
3647: p_terminate_date => l_termination_date,
3648: p_flag => 1,
3649: X_Amount => l_con_termination_amount,

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

6276: -------------------------------------------------------------------------
6277: -- Begin partial period computation logic
6278: -- Developer Mani Choudhary
6279: -- Date 11-JUN-2005
6280: -- call oks_bill_rec_pub.Get_prorated_Usage_Qty to get the prorated usage
6281: -------------------------------------------------------------------------
6282: IF p_period_type IS NOT NULL AND
6283: p_period_start IS NOT NULL
6284: THEN

Line 6290: l_qty := OKS_BILL_REC_PUB.Get_Prorated_Usage_Qty

6286: FETCH l_Billuom_csr INTO l_uom_code;
6287: CLOSE l_Billuom_csr;
6288: IF (p_calledfrom = 3) THEN
6289:
6290: l_qty := OKS_BILL_REC_PUB.Get_Prorated_Usage_Qty
6291: (
6292: p_start_date => p_cov_prd_start_date,
6293: p_end_date => p_cov_prd_end_date-1,
6294: p_qty => l_qty,

Line 6304: l_qty := OKS_BILL_REC_PUB.Get_Prorated_Usage_Qty

6300: --IF nvl(l_qty,0) = 0 THEN
6301: -- RAISE G_EXCEPTION_HALT_VALIDATION;
6302: --END IF;
6303: ELSE
6304: l_qty := OKS_BILL_REC_PUB.Get_Prorated_Usage_Qty
6305: (
6306: p_start_date => p_cov_prd_start_date,
6307: p_end_date => p_cov_prd_end_date,
6308: p_qty => l_qty,

Line 7848: l_cov_tbl OKS_BILL_REC_PUB.COVERED_TBL;

7844: l_billed_rec l_billed_csr%rowtype;
7845: l_amount_rec l_amount_csr%rowtype;
7846: qty_uom_rec qty_uom_csr%rowtype;
7847: l_item_rec l_inv_item_csr%rowtype;
7848: l_cov_tbl OKS_BILL_REC_PUB.COVERED_TBL;
7849:
7850:
7851: l_date_billed_from DATE;
7852: l_date_billed_to DATE;

Line 7941: OKS_BILL_REC_PUB.Insert_bcl

7937:
7938:
7939: If l_ad_cnt = 0 Then
7940:
7941: OKS_BILL_REC_PUB.Insert_bcl
7942: (
7943: p_calledfrom => p_calledfrom,
7944: x_return_stat => l_return_status,
7945: p_cle_id => l_billed_cle_id,

Line 8023: OKS_BILL_REC_PUB.Insert_all_subline

8019: l_ptr := l_ptr + 1;
8020:
8021: End Loop; -- subline loop
8022:
8023: OKS_BILL_REC_PUB.Insert_all_subline
8024: (
8025: p_calledfrom => p_calledfrom,
8026: x_return_stat => l_return_status,
8027: p_covered_tbl => l_cov_tbl,

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

8781: THEN
8782: IF l_lse_id <> 13 OR nvl(l_usage_type,'XYZ') = 'NPR' THEN
8783: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
8784: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_cp.Service',
8785: 'calling OKS_BILL_REC_PUB.Terminate_PPC with parameters l_period_start '||l_period_start||', l_period_type '||l_period_type
8786: ||' P_override_amount ' ||p_override_amount||'p_con_terminate_amount '||p_con_terminate_amount||' ,P_suppress_credit'||P_suppress_credit);
8787: END IF;
8788: OKS_BILL_REC_PUB.Terminate_PPC
8789: (P_termination_date => l_termination_date,

Line 8788: OKS_BILL_REC_PUB.Terminate_PPC

8784: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_cp.Service',
8785: 'calling OKS_BILL_REC_PUB.Terminate_PPC with parameters l_period_start '||l_period_start||', l_period_type '||l_period_type
8786: ||' P_override_amount ' ||p_override_amount||'p_con_terminate_amount '||p_con_terminate_amount||' ,P_suppress_credit'||P_suppress_credit);
8787: END IF;
8788: OKS_BILL_REC_PUB.Terminate_PPC
8789: (P_termination_date => l_termination_date,
8790: p_end_date => l_max_date,
8791: P_top_line_id => p_top_line_id,
8792: P_cp_line_id => p_cp_line_id,

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

8802: ELSE
8803: --This procedure will be called for usage amount based termination
8804: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
8805: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_cp.Usage',
8806: 'calling OKS_BILL_REC_PUB.Create_trx_records with parameters l_period_start '||l_period_start||', l_period_type '||l_period_type
8807: ||' P_override_amount ' ||p_override_amount||'p_con_terminate_amount '||p_con_terminate_amount||' ,P_suppress_credit'||P_suppress_credit);
8808: END IF;
8809: Create_trx_records(
8810: p_called_from => 1,

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

10973: WHEN INVALID_UOM_EXCEPTION THEN
10974: OKC_API.SET_MESSAGE(p_app_name => 'OKS',
10975: p_msg_name => 'OKS_INVD_UOM_CODE',
10976: p_token1 => 'OKS_API_NAME',
10977: p_token1_value => 'OKS_BILL_REC_PUB.Get_partial_term_amount',
10978: p_token2 => 'UOM_CODE',
10979: p_token2_value => P_uom);
10980: IF cs_validate_uom%ISOPEN THEN
10981: CLOSE cs_validate_uom;

Line 11001: END OKS_BILL_REC_PUB ;

10997: RETURN NULL;
10998: END Get_partial_term_amount;
10999:
11000:
11001: END OKS_BILL_REC_PUB ;
11002:
11003: