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 2302: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.create_hdr_sll', 'calling OKS_BILL_SCH.create_hdr_schedule');

2298: RAISE FND_API.g_exc_error;
2299: END IF;
2300:
2301: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2302: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.create_hdr_sll', 'calling OKS_BILL_SCH.create_hdr_schedule');
2303: END IF;
2304:
2305: OKS_BILL_SCH.create_hdr_schedule(
2306: p_contract_id => p_chr_id,

Line 2305: OKS_BILL_SCH.create_hdr_schedule(

2301: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2302: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.create_hdr_sll', 'calling OKS_BILL_SCH.create_hdr_schedule');
2303: END IF;
2304:
2305: OKS_BILL_SCH.create_hdr_schedule(
2306: p_contract_id => p_chr_id,
2307: x_return_status => x_return_status,
2308: x_msg_count => x_msg_count,
2309: x_msg_data => x_msg_data);

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

2308: x_msg_count => x_msg_count,
2309: x_msg_data => x_msg_data);
2310:
2311: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2312: 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);
2313: END IF;
2314:
2315: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2316: RAISE FND_API.g_exc_unexpected_error;

Line 2410: l_line_sllv_tbl OKS_BILL_SCH.streamlvl_tbl;

2406:
2407: l_top_line_tbl top_line_tbl;
2408: l_line_strlvl_tbl line_strlvl_tbl;
2409:
2410: l_line_sllv_tbl OKS_BILL_SCH.streamlvl_tbl;
2411: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;
2412: l_line_sll_ctr NUMBER := 0;
2413:
2414: BEGIN

Line 2411: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;

2407: l_top_line_tbl top_line_tbl;
2408: l_line_strlvl_tbl line_strlvl_tbl;
2409:
2410: l_line_sllv_tbl OKS_BILL_SCH.streamlvl_tbl;
2411: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;
2412: l_line_sll_ctr NUMBER := 0;
2413:
2414: BEGIN
2415: --log key input parameters

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

2496: l_line_strlvl_tbl.delete;
2497:
2498: --call the billing api to create the billing schedule for the topline and it's sublines
2499: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2500: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.topline_billing', 'calling OKS_BILL_SCH.create_bill_sch_rules');
2501: END IF;
2502:
2503: OKS_BILL_SCH.create_bill_sch_rules(
2504: p_billing_type => l_top_line_tbl(i).billing_schedule_type,

Line 2503: OKS_BILL_SCH.create_bill_sch_rules(

2499: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2500: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.topline_billing', 'calling OKS_BILL_SCH.create_bill_sch_rules');
2501: END IF;
2502:
2503: OKS_BILL_SCH.create_bill_sch_rules(
2504: p_billing_type => l_top_line_tbl(i).billing_schedule_type,
2505: p_sll_tbl => l_line_sllv_tbl,
2506: p_invoice_rule_id => l_top_line_tbl(i).inv_rule_id,
2507: x_bil_sch_out_tbl => l_bil_sch_out_tbl,

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

2507: x_bil_sch_out_tbl => l_bil_sch_out_tbl,
2508: x_return_status => x_return_status);
2509:
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', 'after call to OKS_BILL_SCH.create_bill_sch_rules, x_return_status='||x_return_status);
2512: END IF;
2513:
2514: l_bil_sch_out_tbl.delete;
2515: l_line_sllv_tbl.delete;

Line 2627: l_sll_tbl OKS_BILL_SCH.streamlvl_tbl;

2623:
2624: l_rec OKS_BILLING_PROFILES_PUB.billing_profile_rec;
2625: l_sll_tbl_out OKS_BILLING_PROFILES_PUB.stream_level_tbl;
2626:
2627: l_sll_tbl OKS_BILL_SCH.streamlvl_tbl;
2628: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;
2629:
2630: l_invoice_rule_id NUMBER;
2631: l_account_rule_id NUMBER;

Line 2628: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;

2624: l_rec OKS_BILLING_PROFILES_PUB.billing_profile_rec;
2625: l_sll_tbl_out OKS_BILLING_PROFILES_PUB.stream_level_tbl;
2626:
2627: l_sll_tbl OKS_BILL_SCH.streamlvl_tbl;
2628: l_bil_sch_out_tbl OKS_BILL_SCH.itembillsch_tbl;
2629:
2630: l_invoice_rule_id NUMBER;
2631: l_account_rule_id NUMBER;
2632: l_rule_id NUMBER;

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

2715: END LOOP;
2716:
2717: --create billing schedule for the topline and it's sublines
2718: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2719: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'create_tl_bill_sch: i='||i||' calling OKS_BILL_SCH.create_bill_sch_rules');
2720: END IF;
2721:
2722: --for usage lines with variable usage type (Actual by Qty, Actual by Period)
2723: --the invoice rule has to be "Arrears" (-3), irrespective of the billing profile value

Line 2732: OKS_BILL_SCH.create_bill_sch_rules(

2728: 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));
2729: END IF;
2730:
2731: l_var_usg_typ_flag := TRUE;
2732: OKS_BILL_SCH.create_bill_sch_rules(
2733: p_billing_type => l_bsch_typ_tbl(i),
2734: p_sll_tbl => l_sll_tbl,
2735: p_invoice_rule_id => -3,
2736: x_bil_sch_out_tbl => l_bil_sch_out_tbl,

Line 2739: OKS_BILL_SCH.create_bill_sch_rules(

2735: p_invoice_rule_id => -3,
2736: x_bil_sch_out_tbl => l_bil_sch_out_tbl,
2737: x_return_status => x_return_status);
2738: ELSE
2739: OKS_BILL_SCH.create_bill_sch_rules(
2740: p_billing_type => l_bsch_typ_tbl(i),
2741: p_sll_tbl => l_sll_tbl,
2742: p_invoice_rule_id => l_invoice_rule_id,
2743: x_bil_sch_out_tbl => l_bil_sch_out_tbl,

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

2744: x_return_status => x_return_status);
2745: END IF;
2746:
2747: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2748: 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);
2749: END IF;
2750:
2751: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2752: RAISE FND_API.g_exc_unexpected_error;

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

3023:
3024: DELETE FROM oks_stream_levels_b
3025: WHERE dnz_chr_id = p_chr_id;
3026:
3027: --doing this becuase this is what OKS_BILL_SCH.del_rul_elements does
3028: --and we are replacing that call
3029: UPDATE oks_k_lines_b
3030: SET billing_schedule_type = NULL
3031: WHERE cle_id IN