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

Line 2311: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.create_hdr_sll', 'calling OKS_BILL_SCH.create_hdr_schedule');

2307: RAISE FND_API.g_exc_error;
2308: END IF;
2309:
2310: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2311: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.create_hdr_sll', 'calling OKS_BILL_SCH.create_hdr_schedule');
2312: END IF;
2313:
2314: OKS_BILL_SCH.create_hdr_schedule(
2315: p_contract_id => p_chr_id,

Line 2314: OKS_BILL_SCH.create_hdr_schedule(

2310: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2311: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.create_hdr_sll', 'calling OKS_BILL_SCH.create_hdr_schedule');
2312: END IF;
2313:
2314: OKS_BILL_SCH.create_hdr_schedule(
2315: p_contract_id => p_chr_id,
2316: x_return_status => x_return_status,
2317: x_msg_count => x_msg_count,
2318: x_msg_data => x_msg_data);

Line 2321: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.create_hdr_sll', 'after call to OKS_BILL_SCH.create_hdr_schedule, x_return_status='||x_return_status);

2317: x_msg_count => x_msg_count,
2318: x_msg_data => x_msg_data);
2319:
2320: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2321: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.create_hdr_sll', 'after call to OKS_BILL_SCH.create_hdr_schedule, x_return_status='||x_return_status);
2322: END IF;
2323:
2324: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2325: RAISE FND_API.g_exc_unexpected_error;

Line 2421: l_line_sllv_tbl OKS_BILL_SCH.streamlvl_tbl;

2417:
2418: l_top_line_tbl top_line_tbl;
2419: l_line_strlvl_tbl line_strlvl_tbl;
2420:
2421: l_line_sllv_tbl OKS_BILL_SCH.streamlvl_tbl;
2422: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;
2423: l_line_sll_ctr NUMBER := 0;
2424:
2425: BEGIN

Line 2422: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;

2418: l_top_line_tbl top_line_tbl;
2419: l_line_strlvl_tbl line_strlvl_tbl;
2420:
2421: l_line_sllv_tbl OKS_BILL_SCH.streamlvl_tbl;
2422: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;
2423: l_line_sll_ctr NUMBER := 0;
2424:
2425: BEGIN
2426: --log key input parameters

Line 2511: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.topline_billing', 'calling OKS_BILL_SCH.create_bill_sch_rules');

2507: l_line_strlvl_tbl.delete;
2508:
2509: --call the billing api to create the billing schedule for the topline and it's sublines
2510: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2511: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.topline_billing', 'calling OKS_BILL_SCH.create_bill_sch_rules');
2512: END IF;
2513:
2514: OKS_BILL_SCH.create_bill_sch_rules(
2515: p_billing_type => l_top_line_tbl(i).billing_schedule_type,

Line 2514: OKS_BILL_SCH.create_bill_sch_rules(

2510: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2511: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.topline_billing', 'calling OKS_BILL_SCH.create_bill_sch_rules');
2512: END IF;
2513:
2514: OKS_BILL_SCH.create_bill_sch_rules(
2515: p_billing_type => l_top_line_tbl(i).billing_schedule_type,
2516: p_sll_tbl => l_line_sllv_tbl,
2517: p_invoice_rule_id => l_top_line_tbl(i).inv_rule_id,
2518: x_bil_sch_out_tbl => l_bil_sch_out_tbl,

Line 2522: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.topline_billing', 'after call to OKS_BILL_SCH.create_bill_sch_rules, x_return_status='||x_return_status);

2518: x_bil_sch_out_tbl => l_bil_sch_out_tbl,
2519: x_return_status => x_return_status);
2520:
2521: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2522: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.topline_billing', 'after call to OKS_BILL_SCH.create_bill_sch_rules, x_return_status='||x_return_status);
2523: END IF;
2524:
2525: l_bil_sch_out_tbl.delete;
2526: l_line_sllv_tbl.delete;

Line 2638: l_sll_tbl OKS_BILL_SCH.streamlvl_tbl;

2634:
2635: l_rec OKS_BILLING_PROFILES_PUB.billing_profile_rec;
2636: l_sll_tbl_out OKS_BILLING_PROFILES_PUB.stream_level_tbl;
2637:
2638: l_sll_tbl OKS_BILL_SCH.streamlvl_tbl;
2639: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;
2640:
2641: l_invoice_rule_id NUMBER;
2642: l_account_rule_id NUMBER;

Line 2639: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;

2635: l_rec OKS_BILLING_PROFILES_PUB.billing_profile_rec;
2636: l_sll_tbl_out OKS_BILLING_PROFILES_PUB.stream_level_tbl;
2637:
2638: l_sll_tbl OKS_BILL_SCH.streamlvl_tbl;
2639: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;
2640:
2641: l_invoice_rule_id NUMBER;
2642: l_account_rule_id NUMBER;
2643: l_rule_id NUMBER;

Line 2730: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'create_tl_bill_sch: i='||i||' calling OKS_BILL_SCH.create_bill_sch_rules');

2726: END LOOP;
2727:
2728: --create billing schedule for the topline and it's sublines
2729: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2730: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'create_tl_bill_sch: i='||i||' calling OKS_BILL_SCH.create_bill_sch_rules');
2731: END IF;
2732:
2733: --for usage lines with variable usage type (Actual by Qty, Actual by Period)
2734: --the invoice rule has to be "Arrears" (-3), irrespective of the billing profile value

Line 2743: OKS_BILL_SCH.create_bill_sch_rules(

2739: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'var_usage_chk: i='||i||' ,l_invoice_rule_id='||l_invoice_rule_id||' ,l_usage_typ_tbl(i)='||l_usage_typ_tbl(i)||' ,id='||l_id_tbl(i));
2740: END IF;
2741:
2742: l_var_usg_typ_flag := TRUE;
2743: OKS_BILL_SCH.create_bill_sch_rules(
2744: p_billing_type => l_bsch_typ_tbl(i),
2745: p_sll_tbl => l_sll_tbl,
2746: p_invoice_rule_id => -3,
2747: x_bil_sch_out_tbl => l_bil_sch_out_tbl,

Line 2750: OKS_BILL_SCH.create_bill_sch_rules(

2746: p_invoice_rule_id => -3,
2747: x_bil_sch_out_tbl => l_bil_sch_out_tbl,
2748: x_return_status => x_return_status);
2749: ELSE
2750: OKS_BILL_SCH.create_bill_sch_rules(
2751: p_billing_type => l_bsch_typ_tbl(i),
2752: p_sll_tbl => l_sll_tbl,
2753: p_invoice_rule_id => l_invoice_rule_id,
2754: x_bil_sch_out_tbl => l_bil_sch_out_tbl,

Line 2759: FND_LOG.string(FND_LOG.level_statement, l_mod_name, 'create_tl_bill_sch: i='||i||' after call to OKS_BILL_SCH.create_bill_sch_rules, x_return_status='||x_return_status);

2755: x_return_status => x_return_status);
2756: END IF;
2757:
2758: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2759: FND_LOG.string(FND_LOG.level_statement, l_mod_name, 'create_tl_bill_sch: i='||i||' after call to OKS_BILL_SCH.create_bill_sch_rules, x_return_status='||x_return_status);
2760: END IF;
2761:
2762: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2763: RAISE FND_API.g_exc_unexpected_error;

Line 3038: --doing this becuase this is what OKS_BILL_SCH.del_rul_elements does

3034:
3035: DELETE FROM oks_stream_levels_b
3036: WHERE dnz_chr_id = p_chr_id;
3037:
3038: --doing this becuase this is what OKS_BILL_SCH.del_rul_elements does
3039: --and we are replacing that call
3040: UPDATE oks_k_lines_b
3041: SET billing_schedule_type = NULL
3042: WHERE cle_id IN