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_SETUP_UTIL_PUB dependencies on OKS_BILL_SCH

Line 1075: OKS_BILL_SCH.Create_hdr_schedule(

1071: RAISE G_EXCEPTION_HALT_VALIDATION;
1072: END IF;
1073:
1074:
1075: OKS_BILL_SCH.Create_hdr_schedule(
1076: p_contract_id => p_new_chr_id,
1077: x_return_status => l_return_status,
1078: x_msg_count => l_msg_count,
1079: x_msg_data => l_msg_data);

Line 1732: x_strlvl_tbl OUT NOCOPY OKS_BILL_SCH.StreamLvl_tbl,

1728: PROCEDURE get_strlvls
1729: (p_chr_id IN NUMBER,
1730: p_cle_id IN NUMBER,
1731: p_billsch_type IN VARCHAR2,
1732: x_strlvl_tbl OUT NOCOPY OKS_BILL_SCH.StreamLvl_tbl,
1733: x_return_status OUT NOCOPY VARCHAR2
1734: )
1735: IS
1736:

Line 1746: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;

1742: l_api_version Number := 1;
1743: l_init_msg_list Varchar2(1) := 'F';
1744:
1745:
1746: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
1747: l_strlvl_tbl OKS_BILL_SCH.StreamLvl_tbl;
1748: l_klnv_tbl oks_kln_pvt.klnv_tbl_type;
1749: x_klnv_tbl oks_kln_pvt.klnv_tbl_type;
1750:

Line 1747: l_strlvl_tbl OKS_BILL_SCH.StreamLvl_tbl;

1743: l_init_msg_list Varchar2(1) := 'F';
1744:
1745:
1746: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
1747: l_strlvl_tbl OKS_BILL_SCH.StreamLvl_tbl;
1748: l_klnv_tbl oks_kln_pvt.klnv_tbl_type;
1749: x_klnv_tbl oks_kln_pvt.klnv_tbl_type;
1750:
1751: CURSOR old_cle_csr(p_cle_id NUMBER) IS

Line 1946: l_SLL_tbl_type OKS_BILL_SCH.StreamLvl_tbl;

1942: l_billing_type VARCHAR2(3);
1943:
1944: --tbl type
1945:
1946: l_SLL_tbl_type OKS_BILL_SCH.StreamLvl_tbl;
1947: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
1948: l_strlvl_tbl OKS_BILL_SCH.StreamLvl_tbl;
1949:
1950: --Sub Lines information

Line 1947: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;

1943:
1944: --tbl type
1945:
1946: l_SLL_tbl_type OKS_BILL_SCH.StreamLvl_tbl;
1947: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
1948: l_strlvl_tbl OKS_BILL_SCH.StreamLvl_tbl;
1949:
1950: --Sub Lines information
1951:

Line 1948: l_strlvl_tbl OKS_BILL_SCH.StreamLvl_tbl;

1944: --tbl type
1945:
1946: l_SLL_tbl_type OKS_BILL_SCH.StreamLvl_tbl;
1947: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
1948: l_strlvl_tbl OKS_BILL_SCH.StreamLvl_tbl;
1949:
1950: --Sub Lines information
1951:
1952: CURSOR sub_line_grp_csr (p_chr_id NUMBER,p_cle_id NUMBER) IS

Line 2038: oks_bill_sch.create_bill_sch_rules

2034:
2035: IF l_return_status = 'S' and l_strlvl_tbl.count > 0 THEN
2036:
2037: -- Call bill API
2038: oks_bill_sch.create_bill_sch_rules
2039: (
2040: p_billing_type => l_subline_billsch_type,
2041: p_sll_tbl => l_strlvl_tbl,
2042: p_invoice_rule_id => l_invoice_rule_id,

Line 2100: oks_bill_sch.create_bill_sch_rules

2096:
2097: IF l_strlvl_tbl.COUNT > 0 THEN
2098:
2099: -- Call bill API
2100: oks_bill_sch.create_bill_sch_rules
2101: (
2102: p_billing_type => p_billing_schedule_type,
2103: p_sll_tbl => l_strlvl_tbl,
2104: p_invoice_rule_id => l_invoice_rule_id,

Line 2546: l_SLL_tbl_type OKS_BILL_SCH.StreamLvl_tbl;

2542: l_msg_count NUMBER;
2543: l_msg_data VARCHAR2(2000):=null;
2544: l_old_cle_id NUMBER;
2545: l_count NUMBER;
2546: l_SLL_tbl_type OKS_BILL_SCH.StreamLvl_tbl;
2547: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
2548: l_strlvl_tbl OKS_BILL_SCH.StreamLvl_tbl;
2549: l_ste_code VARCHAR2(30);
2550: l_old_chr_id number;

Line 2547: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;

2543: l_msg_data VARCHAR2(2000):=null;
2544: l_old_cle_id NUMBER;
2545: l_count NUMBER;
2546: l_SLL_tbl_type OKS_BILL_SCH.StreamLvl_tbl;
2547: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
2548: l_strlvl_tbl OKS_BILL_SCH.StreamLvl_tbl;
2549: l_ste_code VARCHAR2(30);
2550: l_old_chr_id number;
2551:

Line 2548: l_strlvl_tbl OKS_BILL_SCH.StreamLvl_tbl;

2544: l_old_cle_id NUMBER;
2545: l_count NUMBER;
2546: l_SLL_tbl_type OKS_BILL_SCH.StreamLvl_tbl;
2547: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
2548: l_strlvl_tbl OKS_BILL_SCH.StreamLvl_tbl;
2549: l_ste_code VARCHAR2(30);
2550: l_old_chr_id number;
2551:
2552:

Line 3072: oks_bill_sch.create_bill_sch_rules

3068: x_strlvl_tbl => l_strlvl_tbl,
3069: x_return_status => l_return_status
3070: );
3071:
3072: oks_bill_sch.create_bill_sch_rules
3073: (
3074: p_billing_type => l_billing_schedule_type,
3075: p_sll_tbl => l_strlvl_tbl,
3076: p_invoice_rule_id => l_inv_rule_id,

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

4297: END LOOP;
4298:
4299: FOR topline_rec IN topline_csr(p_chr_id) LOOP
4300: -- will delete all the existing SLH, SLL and level elements for top line and its sub lines
4301: OKS_BILL_SCH.Del_Rul_Elements(p_top_line_id => topline_rec.id,
4302: x_return_status => l_return_status,
4303: x_msg_count => l_msg_count,
4304: x_msg_data => l_msg_data);
4305:

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

4552: ----------- Delete OKS billing schedule ----------------------------
4553: If l_parent_id is null Then
4554:
4555: -- will delete all the existing SLH, SLL and level elements for top line and its sub lines
4556: OKS_BILL_SCH.Del_Rul_Elements(p_top_line_id => p_line_id,
4557: x_return_status => l_return_status,
4558: x_msg_count => l_msg_count,
4559: x_msg_data => l_msg_data);
4560: If l_return_status <> OKC_API.G_RET_STS_SUCCESS then

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

4563: G_UNEXPECTED_ERROR,
4564: G_SQLCODE_TOKEN,
4565: SQLCODE,
4566: G_SQLERRM_TOKEN,
4567: 'Error in deleting billing schedule (OKS_BILL_SCH.Del_Rul_Elements)'
4568: );
4569: RAISE G_EXCEPTION_HALT_VALIDATION;
4570: End if;
4571:

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

4569: RAISE G_EXCEPTION_HALT_VALIDATION;
4570: End if;
4571:
4572: Else
4573: OKS_BILL_SCH.Del_subline_lvl_rule(p_top_line_id => l_parent_id,
4574: p_sub_line_id => p_line_id,
4575: x_return_status => l_return_status,
4576: x_msg_count => l_msg_count,
4577: x_msg_data => l_msg_data

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

4582: G_UNEXPECTED_ERROR,
4583: G_SQLCODE_TOKEN,
4584: SQLCODE,
4585: G_SQLERRM_TOKEN,
4586: 'Error in deleting billing schedule (OKS_BILL_SCH.Del_subline_lvl_rule)'
4587: );
4588: RAISE G_EXCEPTION_HALT_VALIDATION;
4589: End if;
4590: End If;

Line 5176: OKS_BILL_SCH.del_rul_elements(

5172: --delete OKS billing schedule
5173: IF l_parent_id IS NULL THEN
5174:
5175: -- will delete all the existing SLH, SLL and level elements for top line and its sub lines
5176: OKS_BILL_SCH.del_rul_elements(
5177: p_top_line_id => p_line_id,
5178: x_return_status => x_return_status,
5179: x_msg_count => x_msg_count,
5180: x_msg_data => x_msg_data);

Line 5183: 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);

5179: x_msg_count => x_msg_count,
5180: x_msg_data => x_msg_data);
5181:
5182: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5183: 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);
5184: END IF;
5185:
5186: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5187: RAISE FND_API.g_exc_unexpected_error;

Line 5194: OKS_BILL_SCH.del_subline_lvl_rule(

5190: END IF;
5191:
5192: ELSE
5193:
5194: OKS_BILL_SCH.del_subline_lvl_rule(
5195: p_top_line_id => l_parent_id,
5196: p_sub_line_id => p_line_id,
5197: x_return_status => x_return_status,
5198: x_msg_count => x_msg_count,

Line 5202: 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);

5198: x_msg_count => x_msg_count,
5199: x_msg_data => x_msg_data);
5200:
5201: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5202: 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);
5203: END IF;
5204:
5205: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5206: RAISE FND_API.g_exc_unexpected_error;