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.

[Home] [Help]

APPS.OKS_SETUP_UTIL_PUB dependencies on OKS_BILL_SCH

Line 1083: OKS_BILL_SCH.Create_hdr_schedule(

1079: RAISE G_EXCEPTION_HALT_VALIDATION;
1080: END IF;
1081:
1082:
1083: OKS_BILL_SCH.Create_hdr_schedule(
1084: p_contract_id => p_new_chr_id,
1085: x_return_status => l_return_status,
1086: x_msg_count => l_msg_count,
1087: x_msg_data => l_msg_data);

Line 1740: x_strlvl_tbl OUT NOCOPY OKS_BILL_SCH.StreamLvl_tbl,

1736: PROCEDURE get_strlvls
1737: (p_chr_id IN NUMBER,
1738: p_cle_id IN NUMBER,
1739: p_billsch_type IN VARCHAR2,
1740: x_strlvl_tbl OUT NOCOPY OKS_BILL_SCH.StreamLvl_tbl,
1741: x_return_status OUT NOCOPY VARCHAR2
1742: )
1743: IS
1744:

Line 1754: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;

1750: l_api_version Number := 1;
1751: l_init_msg_list Varchar2(1) := 'F';
1752:
1753:
1754: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
1755: l_strlvl_tbl OKS_BILL_SCH.StreamLvl_tbl;
1756: l_klnv_tbl oks_kln_pvt.klnv_tbl_type;
1757: x_klnv_tbl oks_kln_pvt.klnv_tbl_type;
1758:

Line 1755: l_strlvl_tbl OKS_BILL_SCH.StreamLvl_tbl;

1751: l_init_msg_list Varchar2(1) := 'F';
1752:
1753:
1754: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
1755: l_strlvl_tbl OKS_BILL_SCH.StreamLvl_tbl;
1756: l_klnv_tbl oks_kln_pvt.klnv_tbl_type;
1757: x_klnv_tbl oks_kln_pvt.klnv_tbl_type;
1758:
1759: CURSOR old_cle_csr(p_cle_id NUMBER) IS

Line 1955: l_SLL_tbl_type OKS_BILL_SCH.StreamLvl_tbl;

1951: l_billing_type VARCHAR2(3);
1952:
1953: --tbl type
1954:
1955: l_SLL_tbl_type OKS_BILL_SCH.StreamLvl_tbl;
1956: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
1957: l_strlvl_tbl OKS_BILL_SCH.StreamLvl_tbl;
1958:
1959: --Sub Lines information

Line 1956: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;

1952:
1953: --tbl type
1954:
1955: l_SLL_tbl_type OKS_BILL_SCH.StreamLvl_tbl;
1956: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
1957: l_strlvl_tbl OKS_BILL_SCH.StreamLvl_tbl;
1958:
1959: --Sub Lines information
1960:

Line 1957: l_strlvl_tbl OKS_BILL_SCH.StreamLvl_tbl;

1953: --tbl type
1954:
1955: l_SLL_tbl_type OKS_BILL_SCH.StreamLvl_tbl;
1956: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
1957: l_strlvl_tbl OKS_BILL_SCH.StreamLvl_tbl;
1958:
1959: --Sub Lines information
1960:
1961: CURSOR sub_line_grp_csr (p_chr_id NUMBER,p_cle_id NUMBER) IS

Line 2047: oks_bill_sch.create_bill_sch_rules

2043:
2044: IF l_return_status = 'S' and l_strlvl_tbl.count > 0 THEN
2045:
2046: -- Call bill API
2047: oks_bill_sch.create_bill_sch_rules
2048: (
2049: p_billing_type => l_subline_billsch_type,
2050: p_sll_tbl => l_strlvl_tbl,
2051: p_invoice_rule_id => l_invoice_rule_id,

Line 2109: oks_bill_sch.create_bill_sch_rules

2105:
2106: IF l_strlvl_tbl.COUNT > 0 THEN
2107:
2108: -- Call bill API
2109: oks_bill_sch.create_bill_sch_rules
2110: (
2111: p_billing_type => p_billing_schedule_type,
2112: p_sll_tbl => l_strlvl_tbl,
2113: p_invoice_rule_id => l_invoice_rule_id,

Line 2555: l_SLL_tbl_type OKS_BILL_SCH.StreamLvl_tbl;

2551: l_msg_count NUMBER;
2552: l_msg_data VARCHAR2(2000):=null;
2553: l_old_cle_id NUMBER;
2554: l_count NUMBER;
2555: l_SLL_tbl_type OKS_BILL_SCH.StreamLvl_tbl;
2556: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
2557: l_strlvl_tbl OKS_BILL_SCH.StreamLvl_tbl;
2558: l_ste_code VARCHAR2(30);
2559: l_old_chr_id number;

Line 2556: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;

2552: l_msg_data VARCHAR2(2000):=null;
2553: l_old_cle_id NUMBER;
2554: l_count NUMBER;
2555: l_SLL_tbl_type OKS_BILL_SCH.StreamLvl_tbl;
2556: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
2557: l_strlvl_tbl OKS_BILL_SCH.StreamLvl_tbl;
2558: l_ste_code VARCHAR2(30);
2559: l_old_chr_id number;
2560:

Line 2557: l_strlvl_tbl OKS_BILL_SCH.StreamLvl_tbl;

2553: l_old_cle_id NUMBER;
2554: l_count NUMBER;
2555: l_SLL_tbl_type OKS_BILL_SCH.StreamLvl_tbl;
2556: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
2557: l_strlvl_tbl OKS_BILL_SCH.StreamLvl_tbl;
2558: l_ste_code VARCHAR2(30);
2559: l_old_chr_id number;
2560:
2561:

Line 3081: oks_bill_sch.create_bill_sch_rules

3077: x_strlvl_tbl => l_strlvl_tbl,
3078: x_return_status => l_return_status
3079: );
3080:
3081: oks_bill_sch.create_bill_sch_rules
3082: (
3083: p_billing_type => l_billing_schedule_type,
3084: p_sll_tbl => l_strlvl_tbl,
3085: p_invoice_rule_id => l_inv_rule_id,

Line 4310: OKS_BILL_SCH.Del_Rul_Elements(p_top_line_id => topline_rec.id,

4306: END LOOP;
4307:
4308: FOR topline_rec IN topline_csr(p_chr_id) LOOP
4309: -- will delete all the existing SLH, SLL and level elements for top line and its sub lines
4310: OKS_BILL_SCH.Del_Rul_Elements(p_top_line_id => topline_rec.id,
4311: x_return_status => l_return_status,
4312: x_msg_count => l_msg_count,
4313: x_msg_data => l_msg_data);
4314:

Line 4565: OKS_BILL_SCH.Del_Rul_Elements(p_top_line_id => p_line_id,

4561: ----------- Delete OKS billing schedule ----------------------------
4562: If l_parent_id is null Then
4563:
4564: -- will delete all the existing SLH, SLL and level elements for top line and its sub lines
4565: OKS_BILL_SCH.Del_Rul_Elements(p_top_line_id => p_line_id,
4566: x_return_status => l_return_status,
4567: x_msg_count => l_msg_count,
4568: x_msg_data => l_msg_data);
4569: If l_return_status <> OKC_API.G_RET_STS_SUCCESS then

Line 4576: 'Error in deleting billing schedule (OKS_BILL_SCH.Del_Rul_Elements)'

4572: G_UNEXPECTED_ERROR,
4573: G_SQLCODE_TOKEN,
4574: SQLCODE,
4575: G_SQLERRM_TOKEN,
4576: 'Error in deleting billing schedule (OKS_BILL_SCH.Del_Rul_Elements)'
4577: );
4578: RAISE G_EXCEPTION_HALT_VALIDATION;
4579: End if;
4580:

Line 4582: OKS_BILL_SCH.Del_subline_lvl_rule(p_top_line_id => l_parent_id,

4578: RAISE G_EXCEPTION_HALT_VALIDATION;
4579: End if;
4580:
4581: Else
4582: OKS_BILL_SCH.Del_subline_lvl_rule(p_top_line_id => l_parent_id,
4583: p_sub_line_id => p_line_id,
4584: x_return_status => l_return_status,
4585: x_msg_count => l_msg_count,
4586: x_msg_data => l_msg_data

Line 4595: 'Error in deleting billing schedule (OKS_BILL_SCH.Del_subline_lvl_rule)'

4591: G_UNEXPECTED_ERROR,
4592: G_SQLCODE_TOKEN,
4593: SQLCODE,
4594: G_SQLERRM_TOKEN,
4595: 'Error in deleting billing schedule (OKS_BILL_SCH.Del_subline_lvl_rule)'
4596: );
4597: RAISE G_EXCEPTION_HALT_VALIDATION;
4598: End if;
4599: End If;

Line 5185: OKS_BILL_SCH.del_rul_elements(

5181: --delete OKS billing schedule
5182: IF l_parent_id IS NULL THEN
5183:
5184: -- will delete all the existing SLH, SLL and level elements for top line and its sub lines
5185: OKS_BILL_SCH.del_rul_elements(
5186: p_top_line_id => p_line_id,
5187: x_return_status => x_return_status,
5188: x_msg_count => x_msg_count,
5189: x_msg_data => x_msg_data);

Line 5192: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.del_rul_elements', 'after call to OKS_BILL_SCH.del_rul_elements, x_return_status='||x_return_status);

5188: x_msg_count => x_msg_count,
5189: x_msg_data => x_msg_data);
5190:
5191: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5192: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.del_rul_elements', 'after call to OKS_BILL_SCH.del_rul_elements, x_return_status='||x_return_status);
5193: END IF;
5194:
5195: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5196: RAISE FND_API.g_exc_unexpected_error;

Line 5203: OKS_BILL_SCH.del_subline_lvl_rule(

5199: END IF;
5200:
5201: ELSE
5202:
5203: OKS_BILL_SCH.del_subline_lvl_rule(
5204: p_top_line_id => l_parent_id,
5205: p_sub_line_id => p_line_id,
5206: x_return_status => x_return_status,
5207: x_msg_count => x_msg_count,

Line 5211: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.del_subline_lvl_rule', 'after call to OKS_BILL_SCH.del_subline_lvl_rule, x_return_status='||x_return_status);

5207: x_msg_count => x_msg_count,
5208: x_msg_data => x_msg_data);
5209:
5210: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5211: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.del_subline_lvl_rule', 'after call to OKS_BILL_SCH.del_subline_lvl_rule, x_return_status='||x_return_status);
5212: END IF;
5213:
5214: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5215: RAISE FND_API.g_exc_unexpected_error;