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

Line 4849: l_sll_tbl oks_bill_sch.streamlvl_tbl;

4845: WHERE kl.ID = p_line_id;
4846:
4847: l_duration NUMBER;
4848: l_timeunits VARCHAR2 (25);
4849: l_sll_tbl oks_bill_sch.streamlvl_tbl;
4850: l_bil_sch_out oks_bill_sch.itembillsch_tbl;
4851: l_strmlvl_id NUMBER := NULL;
4852: l_update_top_line VARCHAR2 (1);
4853: l_start_date DATE;

Line 4850: l_bil_sch_out oks_bill_sch.itembillsch_tbl;

4846:
4847: l_duration NUMBER;
4848: l_timeunits VARCHAR2 (25);
4849: l_sll_tbl oks_bill_sch.streamlvl_tbl;
4850: l_bil_sch_out oks_bill_sch.itembillsch_tbl;
4851: l_strmlvl_id NUMBER := NULL;
4852: l_update_top_line VARCHAR2 (1);
4853: l_start_date DATE;
4854: l_end_date DATE;

Line 5730: l_sll_tbl oks_bill_sch.streamlvl_tbl;

5726: l_sts_code VARCHAR2 (30);
5727: l_ste_code VARCHAR2 (30);
5728: l_duration NUMBER;
5729: l_timeunits VARCHAR2 (25);
5730: l_sll_tbl oks_bill_sch.streamlvl_tbl;
5731: l_bil_sch_out oks_bill_sch.itembillsch_tbl;
5732: l_strmlvl_id NUMBER := NULL;
5733: l_update_line VARCHAR2 (1);
5734: l_temp VARCHAR2 (2000);

Line 5731: l_bil_sch_out oks_bill_sch.itembillsch_tbl;

5727: l_ste_code VARCHAR2 (30);
5728: l_duration NUMBER;
5729: l_timeunits VARCHAR2 (25);
5730: l_sll_tbl oks_bill_sch.streamlvl_tbl;
5731: l_bil_sch_out oks_bill_sch.itembillsch_tbl;
5732: l_strmlvl_id NUMBER := NULL;
5733: l_update_line VARCHAR2 (1);
5734: l_temp VARCHAR2 (2000);
5735: BEGIN

Line 6107: oks_bill_sch.create_bill_sch_rules

6103: l_sll_tbl (1).advance_periods := NULL;
6104: l_sll_tbl (1).level_amount := NULL;
6105: l_sll_tbl (1).invoice_offset_days := NULL;
6106: l_sll_tbl (1).interface_offset_days := NULL;
6107: oks_bill_sch.create_bill_sch_rules
6108: (p_billing_type => 'T',
6109: p_sll_tbl => l_sll_tbl,
6110: p_invoice_rule_id => p_extwar_rec.line_invoicing_rule_id,
6111: x_bil_sch_out_tbl => l_bil_sch_out,

Line 6121: 'oks_bill_sch.create_bill_sch_rules(Return status = '

6117: fnd_log.STRING
6118: (fnd_log.level_event,
6119: g_module_current
6120: || '.Create_contract_Ibnew.after.bill_sch',
6121: 'oks_bill_sch.create_bill_sch_rules(Return status = '
6122: || l_return_status
6123: || ')'
6124: );
6125: END IF;

Line 6162: oks_bill_sch.update_om_sll_date

6158: IF check_lvlelements_exists (l_lineid)
6159: THEN
6160: IF l_update_line = 'Y'
6161: THEN
6162: oks_bill_sch.update_om_sll_date
6163: (p_top_line_id => l_lineid,
6164: x_return_status => l_return_status,
6165: x_msg_count => x_msg_count,
6166: x_msg_data => x_msg_data

Line 6176: 'oks_bill_sch.update_om_sll_date(Return status = '

6172: fnd_log.STRING
6173: (fnd_log.level_event,
6174: g_module_current
6175: || '.Create_contract_Ibnew.after.om_sll',
6176: 'oks_bill_sch.update_om_sll_date(Return status = '
6177: || l_return_status
6178: || ')'
6179: );
6180: END IF;

Line 6187: oks_bill_sch.create_bill_sch_cp

6183: THEN
6184: RAISE g_exception_halt_validation;
6185: END IF;
6186: ELSE
6187: oks_bill_sch.create_bill_sch_cp
6188: (p_top_line_id => l_lineid,
6189: p_cp_line_id => l_covlvl_id,
6190: p_cp_new => 'Y',
6191: x_return_status => l_return_status,

Line 6203: 'oks_bill_sch.create_bill_sch_cp(Return status = '

6199: fnd_log.STRING
6200: (fnd_log.level_event,
6201: g_module_current
6202: || '.Create_contract_Ibnew.after.sch_cp',
6203: 'oks_bill_sch.create_bill_sch_cp(Return status = '
6204: || l_return_status
6205: || ')'
6206: );
6207: END IF;

Line 6778: l_sll_tbl oks_bill_sch.streamlvl_tbl;

6774: l_total_days NUMBER;
6775: l_credit_amt NUMBER;
6776: l_duration NUMBER;
6777: l_timeunits VARCHAR2 (25);
6778: l_sll_tbl oks_bill_sch.streamlvl_tbl;
6779: l_bil_sch_out oks_bill_sch.itembillsch_tbl;
6780: l_strmlvl_id NUMBER := NULL;
6781: l_update_line VARCHAR2 (1);
6782: l_temp VARCHAR2 (2000);

Line 6779: l_bil_sch_out oks_bill_sch.itembillsch_tbl;

6775: l_credit_amt NUMBER;
6776: l_duration NUMBER;
6777: l_timeunits VARCHAR2 (25);
6778: l_sll_tbl oks_bill_sch.streamlvl_tbl;
6779: l_bil_sch_out oks_bill_sch.itembillsch_tbl;
6780: l_strmlvl_id NUMBER := NULL;
6781: l_update_line VARCHAR2 (1);
6782: l_temp VARCHAR2 (2000);
6783: l_ste_code VARCHAR2 (30);

Line 6796: l_new_cp_tbl oks_bill_sch.subline_id_tbl;

6792: l_id NUMBER;
6793: l_klnv_tbl_in oks_kln_pvt.klnv_tbl_type;
6794: l_klnv_tbl_out oks_kln_pvt.klnv_tbl_type;
6795: l_taxed_amount NUMBER := 0;
6796: l_new_cp_tbl oks_bill_sch.subline_id_tbl;
6797: l_warranty_flag VARCHAR2 (2);
6798: l_renewal_opr_instance_id NUMBER;
6799: l_opr_instance_id NUMBER;
6800: l_target_chr_id NUMBER;

Line 7267: oks_bill_sch.adjust_split_bill_sch

7263: p_kdtl_tbl (l_ctr).cust_account;
7264: l_inst_dtls_tbl (l_ctr1 + 1).new_k_status := l_sts_code;
7265: l_inst_dtls_tbl (l_ctr1 + 1).subline_date_terminated := NULL;
7266: l_new_cp_tbl (1).ID := l_covlvl_id;
7267: oks_bill_sch.adjust_split_bill_sch
7268: (p_old_cp_id => p_kdtl_tbl (l_ctr).object_line_id,
7269: p_new_cp_tbl => l_new_cp_tbl,
7270: x_return_status => l_return_status,
7271: x_msg_count => x_msg_count,

Line 8264: oks_bill_sch.adjust_replace_product_bs

8260:
8261: -------Billing Schedule
8262: IF p_kdtl_tbl (l_ctr).lse_id IN (9, 25)
8263: THEN -- added subscription contract category
8264: oks_bill_sch.adjust_replace_product_bs
8265: (p_old_cp_id => p_kdtl_tbl (l_ctr).object_line_id,
8266: p_new_cp_id => l_covlvl_id,
8267: x_return_status => l_return_status,
8268: x_msg_count => x_msg_count,

Line 8277: || '.CREATE_CONTRACT_IBREPLACE.OKS_BILL_SCH.ADJUST_REPLACE_PRODUCT_BS',

8273: THEN
8274: fnd_log.STRING
8275: (fnd_log.level_event,
8276: g_module_current
8277: || '.CREATE_CONTRACT_IBREPLACE.OKS_BILL_SCH.ADJUST_REPLACE_PRODUCT_BS',
8278: 'ADJUST_REPLACE_PRODUCT_BS(Return status = '
8279: || l_return_status
8280: );
8281: END IF;

Line 10604: l_sll_tbl oks_bill_sch.streamlvl_tbl;

10600: x_msg_count OUT NOCOPY NUMBER
10601: )
10602: IS
10603: l_strmlvl_id NUMBER;
10604: l_sll_tbl oks_bill_sch.streamlvl_tbl;
10605: l_return_status VARCHAR2 (1);
10606: l_duration NUMBER;
10607: l_timeunits VARCHAR2 (25);
10608: l_bil_sch_out oks_bill_sch.itembillsch_tbl;

Line 10608: l_bil_sch_out oks_bill_sch.itembillsch_tbl;

10604: l_sll_tbl oks_bill_sch.streamlvl_tbl;
10605: l_return_status VARCHAR2 (1);
10606: l_duration NUMBER;
10607: l_timeunits VARCHAR2 (25);
10608: l_bil_sch_out oks_bill_sch.itembillsch_tbl;
10609: l_uom_code Varchar2(240);
10610: Cursor get_day_uom_code IS
10611: select uom_code
10612: from okc_time_code_units_v

Line 10688: oks_bill_sch.create_bill_sch_rules

10684: l_sll_tbl (1).invoice_offset_days := NULL;
10685: l_sll_tbl (1).interface_offset_days := NULL;
10686:
10687: End If;
10688: oks_bill_sch.create_bill_sch_rules
10689: (p_billing_type => 'T',
10690: p_sll_tbl => l_sll_tbl,
10691: p_invoice_rule_id => -2,
10692: x_bil_sch_out_tbl => l_bil_sch_out,

Line 10702: 'oks_bill_sch.create_bill_sch_rules(Return status = '

10698: fnd_log.STRING
10699: (fnd_log.level_event,
10700: g_module_current
10701: || '.CREATE_K_SYSTEM_TRF.Create_billing_schedule',
10702: 'oks_bill_sch.create_bill_sch_rules(Return status = '
10703: || l_return_status
10704: || ')'
10705: );
10706: END IF;

Line 10736: oks_bill_sch.update_om_sll_date

10732: IF check_lvlelements_exists (p_line_id)
10733: THEN
10734: IF p_update_line = 'Y'
10735: THEN
10736: oks_bill_sch.update_om_sll_date
10737: (p_top_line_id => p_line_id,
10738: x_return_status => l_return_status,
10739: x_msg_count => x_msg_count,
10740: x_msg_data => x_msg_data

Line 10751: 'oks_bill_sch.update_om_sll_date(Return status = '

10747: fnd_log.STRING
10748: (fnd_log.level_event,
10749: g_module_current
10750: || '.CREATE_K_SYSTEM_TRF.Create_billing_schedule',
10751: 'oks_bill_sch.update_om_sll_date(Return status = '
10752: || l_return_status
10753: || ')'
10754: );
10755: END IF;

Line 10762: oks_bill_sch.create_bill_sch_cp

10758: THEN
10759: RAISE g_exception_halt_validation;
10760: END IF;
10761: ELSE
10762: oks_bill_sch.create_bill_sch_cp
10763: (p_top_line_id => p_line_id,
10764: p_cp_line_id => p_covlvl_id,
10765: p_cp_new => 'Y',
10766: x_return_status => l_return_status,

Line 10778: 'oks_bill_sch.create_bill_sch_cp(Return status = '

10774: fnd_log.STRING
10775: (fnd_log.level_event,
10776: g_module_current
10777: || '.CREATE_K_SYSTEM_TRF.Create_billing_schedule',
10778: 'oks_bill_sch.create_bill_sch_cp(Return status = '
10779: || l_return_status
10780: || ')'
10781: );
10782: END IF;

Line 15555: l_sll_tbl oks_bill_sch.streamlvl_tbl;

15551: l_srvc_stdt DATE;
15552: l_bill_schd_yn VARCHAR2 (1);
15553: l_dur NUMBER;
15554: l_time VARCHAR2 (25);
15555: l_sll_tbl oks_bill_sch.streamlvl_tbl;
15556: l_bil_sch_out oks_bill_sch.itembillsch_tbl;
15557: l_strmlvl_id NUMBER := NULL;
15558: l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
15559: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;

Line 15556: l_bil_sch_out oks_bill_sch.itembillsch_tbl;

15552: l_bill_schd_yn VARCHAR2 (1);
15553: l_dur NUMBER;
15554: l_time VARCHAR2 (25);
15555: l_sll_tbl oks_bill_sch.streamlvl_tbl;
15556: l_bil_sch_out oks_bill_sch.itembillsch_tbl;
15557: l_strmlvl_id NUMBER := NULL;
15558: l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
15559: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;
15560: l_ctr NUMBER;

Line 15779: oks_bill_sch.create_bill_sch_cp

15775: RAISE g_exception_halt_validation;
15776: END IF;
15777:
15778: ---update billing schedule
15779: oks_bill_sch.create_bill_sch_cp
15780: (p_top_line_id => p_kdtl_tbl (l_ctr).service_line_id,
15781: p_cp_line_id => p_kdtl_tbl (l_ctr).object_line_id,
15782: p_cp_new => 'N',
15783: x_return_status => l_return_status,

Line 15795: 'Oks_bill_sch.Create_Bill_Sch_CP(Return status = '

15791: THEN
15792: fnd_log.STRING
15793: (fnd_log.level_event,
15794: g_module_current || '.CREATE_CONTRACT_IBUPDATE',
15795: 'Oks_bill_sch.Create_Bill_Sch_CP(Return status = '
15796: || l_return_status
15797: || ')'
15798: );
15799: END IF;

Line 16403: oks_bill_sch.create_bill_sch_cp

16399: IF check_lvlelements_exists
16400: (p_kdtl_tbl (l_ctr).service_line_id
16401: )
16402: THEN
16403: oks_bill_sch.create_bill_sch_cp
16404: (p_top_line_id => p_kdtl_tbl (l_ctr).service_line_id,
16405: p_cp_line_id => l_covlvl_id,
16406: p_cp_new => 'Y',
16407: x_return_status => l_return_status,

Line 16420: 'oks_bill_sch.create_bill_sch_cp(Retun status = '

16416: fnd_log.STRING
16417: (fnd_log.level_event,
16418: g_module_current
16419: || '.CREATE_CONTRACT_IBUPDATE',
16420: 'oks_bill_sch.create_bill_sch_cp(Retun status = '
16421: || l_return_status
16422: || ')'
16423: );
16424: END IF;

Line 16558: oks_bill_sch.create_bill_sch_cp

16554: IF check_lvlelements_exists
16555: (p_kdtl_tbl (l_ctr).service_line_id
16556: )
16557: THEN
16558: oks_bill_sch.create_bill_sch_cp
16559: (p_top_line_id => p_kdtl_tbl (l_ctr).service_line_id,
16560: p_cp_line_id => p_kdtl_tbl (l_ctr).object_line_id,
16561: p_cp_new => 'N',
16562: x_return_status => l_return_status,

Line 16575: 'oks_bill_sch.create_bill_sch_cp(Retun status = '

16571: fnd_log.STRING
16572: (fnd_log.level_event,
16573: g_module_current
16574: || '.CREATE_CONTRACT_IBUPDATE',
16575: 'oks_bill_sch.create_bill_sch_cp(Retun status = '
16576: || l_return_status
16577: || ')'
16578: );
16579: END IF;