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 5017: l_sll_tbl oks_bill_sch.streamlvl_tbl;

5013: WHERE kl.ID = p_line_id;
5014:
5015: l_duration NUMBER;
5016: l_timeunits VARCHAR2 (25);
5017: l_sll_tbl oks_bill_sch.streamlvl_tbl;
5018: l_bil_sch_out oks_bill_sch.itembillsch_tbl;
5019: l_strmlvl_id NUMBER := NULL;
5020: l_update_top_line VARCHAR2 (1);
5021: l_start_date DATE;

Line 5018: l_bil_sch_out oks_bill_sch.itembillsch_tbl;

5014:
5015: l_duration NUMBER;
5016: l_timeunits VARCHAR2 (25);
5017: l_sll_tbl oks_bill_sch.streamlvl_tbl;
5018: l_bil_sch_out oks_bill_sch.itembillsch_tbl;
5019: l_strmlvl_id NUMBER := NULL;
5020: l_update_top_line VARCHAR2 (1);
5021: l_start_date DATE;
5022: l_end_date DATE;

Line 5898: l_sll_tbl oks_bill_sch.streamlvl_tbl;

5894: l_sts_code VARCHAR2 (30);
5895: l_ste_code VARCHAR2 (30);
5896: l_duration NUMBER;
5897: l_timeunits VARCHAR2 (25);
5898: l_sll_tbl oks_bill_sch.streamlvl_tbl;
5899: l_bil_sch_out oks_bill_sch.itembillsch_tbl;
5900: l_strmlvl_id NUMBER := NULL;
5901: l_update_line VARCHAR2 (1);
5902: l_temp VARCHAR2 (2000);

Line 5899: l_bil_sch_out oks_bill_sch.itembillsch_tbl;

5895: l_ste_code VARCHAR2 (30);
5896: l_duration NUMBER;
5897: l_timeunits VARCHAR2 (25);
5898: l_sll_tbl oks_bill_sch.streamlvl_tbl;
5899: l_bil_sch_out oks_bill_sch.itembillsch_tbl;
5900: l_strmlvl_id NUMBER := NULL;
5901: l_update_line VARCHAR2 (1);
5902: l_temp VARCHAR2 (2000);
5903: BEGIN

Line 6275: oks_bill_sch.create_bill_sch_rules

6271: l_sll_tbl (1).advance_periods := NULL;
6272: l_sll_tbl (1).level_amount := NULL;
6273: l_sll_tbl (1).invoice_offset_days := NULL;
6274: l_sll_tbl (1).interface_offset_days := NULL;
6275: oks_bill_sch.create_bill_sch_rules
6276: (p_billing_type => 'T',
6277: p_sll_tbl => l_sll_tbl,
6278: p_invoice_rule_id => p_extwar_rec.line_invoicing_rule_id,
6279: x_bil_sch_out_tbl => l_bil_sch_out,

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

6285: fnd_log.STRING
6286: (fnd_log.level_event,
6287: g_module_current
6288: || '.Create_contract_Ibnew.after.bill_sch',
6289: 'oks_bill_sch.create_bill_sch_rules(Return status = '
6290: || l_return_status
6291: || ')'
6292: );
6293: END IF;

Line 6330: oks_bill_sch.update_om_sll_date

6326: IF check_lvlelements_exists (l_lineid)
6327: THEN
6328: IF l_update_line = 'Y'
6329: THEN
6330: oks_bill_sch.update_om_sll_date
6331: (p_top_line_id => l_lineid,
6332: x_return_status => l_return_status,
6333: x_msg_count => x_msg_count,
6334: x_msg_data => x_msg_data

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

6340: fnd_log.STRING
6341: (fnd_log.level_event,
6342: g_module_current
6343: || '.Create_contract_Ibnew.after.om_sll',
6344: 'oks_bill_sch.update_om_sll_date(Return status = '
6345: || l_return_status
6346: || ')'
6347: );
6348: END IF;

Line 6355: oks_bill_sch.create_bill_sch_cp

6351: THEN
6352: RAISE g_exception_halt_validation;
6353: END IF;
6354: ELSE
6355: oks_bill_sch.create_bill_sch_cp
6356: (p_top_line_id => l_lineid,
6357: p_cp_line_id => l_covlvl_id,
6358: p_cp_new => 'Y',
6359: x_return_status => l_return_status,

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

6367: fnd_log.STRING
6368: (fnd_log.level_event,
6369: g_module_current
6370: || '.Create_contract_Ibnew.after.sch_cp',
6371: 'oks_bill_sch.create_bill_sch_cp(Return status = '
6372: || l_return_status
6373: || ')'
6374: );
6375: END IF;

Line 6959: l_sll_tbl oks_bill_sch.streamlvl_tbl;

6955: l_total_days NUMBER;
6956: l_credit_amt NUMBER;
6957: l_duration NUMBER;
6958: l_timeunits VARCHAR2 (25);
6959: l_sll_tbl oks_bill_sch.streamlvl_tbl;
6960: l_bil_sch_out oks_bill_sch.itembillsch_tbl;
6961: l_strmlvl_id NUMBER := NULL;
6962: l_update_line VARCHAR2 (1);
6963: l_temp VARCHAR2 (2000);

Line 6960: l_bil_sch_out oks_bill_sch.itembillsch_tbl;

6956: l_credit_amt NUMBER;
6957: l_duration NUMBER;
6958: l_timeunits VARCHAR2 (25);
6959: l_sll_tbl oks_bill_sch.streamlvl_tbl;
6960: l_bil_sch_out oks_bill_sch.itembillsch_tbl;
6961: l_strmlvl_id NUMBER := NULL;
6962: l_update_line VARCHAR2 (1);
6963: l_temp VARCHAR2 (2000);
6964: l_ste_code VARCHAR2 (30);

Line 6977: l_new_cp_tbl oks_bill_sch.subline_id_tbl;

6973: l_id NUMBER;
6974: l_klnv_tbl_in oks_kln_pvt.klnv_tbl_type;
6975: l_klnv_tbl_out oks_kln_pvt.klnv_tbl_type;
6976: l_taxed_amount NUMBER := 0;
6977: l_new_cp_tbl oks_bill_sch.subline_id_tbl;
6978: l_warranty_flag VARCHAR2 (2);
6979: l_renewal_opr_instance_id NUMBER;
6980: l_opr_instance_id NUMBER;
6981: l_target_chr_id NUMBER;

Line 7448: oks_bill_sch.adjust_split_bill_sch

7444: p_kdtl_tbl (l_ctr).cust_account;
7445: l_inst_dtls_tbl (l_ctr1 + 1).new_k_status := l_sts_code;
7446: l_inst_dtls_tbl (l_ctr1 + 1).subline_date_terminated := NULL;
7447: l_new_cp_tbl (1).ID := l_covlvl_id;
7448: oks_bill_sch.adjust_split_bill_sch
7449: (p_old_cp_id => p_kdtl_tbl (l_ctr).object_line_id,
7450: p_new_cp_tbl => l_new_cp_tbl,
7451: x_return_status => l_return_status,
7452: x_msg_count => x_msg_count,

Line 8482: oks_bill_sch.adjust_replace_product_bs

8478:
8479: -------Billing Schedule
8480: IF p_kdtl_tbl (l_ctr).lse_id IN (9, 25)
8481: THEN -- added subscription contract category
8482: oks_bill_sch.adjust_replace_product_bs
8483: (p_old_cp_id => p_kdtl_tbl (l_ctr).object_line_id,
8484: p_new_cp_id => l_covlvl_id,
8485: x_return_status => l_return_status,
8486: x_msg_count => x_msg_count,

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

8491: THEN
8492: fnd_log.STRING
8493: (fnd_log.level_event,
8494: g_module_current
8495: || '.CREATE_CONTRACT_IBREPLACE.OKS_BILL_SCH.ADJUST_REPLACE_PRODUCT_BS',
8496: 'ADJUST_REPLACE_PRODUCT_BS(Return status = '
8497: || l_return_status
8498: );
8499: END IF;

Line 10852: l_sll_tbl oks_bill_sch.streamlvl_tbl;

10848: x_msg_count OUT NOCOPY NUMBER
10849: )
10850: IS
10851: l_strmlvl_id NUMBER;
10852: l_sll_tbl oks_bill_sch.streamlvl_tbl;
10853: l_return_status VARCHAR2 (1);
10854: l_duration NUMBER;
10855: l_timeunits VARCHAR2 (25);
10856: l_bil_sch_out oks_bill_sch.itembillsch_tbl;

Line 10856: l_bil_sch_out oks_bill_sch.itembillsch_tbl;

10852: l_sll_tbl oks_bill_sch.streamlvl_tbl;
10853: l_return_status VARCHAR2 (1);
10854: l_duration NUMBER;
10855: l_timeunits VARCHAR2 (25);
10856: l_bil_sch_out oks_bill_sch.itembillsch_tbl;
10857: l_uom_code Varchar2(240);
10858: Cursor get_day_uom_code IS
10859: select uom_code
10860: from okc_time_code_units_v

Line 10936: oks_bill_sch.create_bill_sch_rules

10932: l_sll_tbl (1).invoice_offset_days := NULL;
10933: l_sll_tbl (1).interface_offset_days := NULL;
10934:
10935: End If;
10936: oks_bill_sch.create_bill_sch_rules
10937: (p_billing_type => 'T',
10938: p_sll_tbl => l_sll_tbl,
10939: p_invoice_rule_id => -2,
10940: x_bil_sch_out_tbl => l_bil_sch_out,

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

10946: fnd_log.STRING
10947: (fnd_log.level_event,
10948: g_module_current
10949: || '.CREATE_K_SYSTEM_TRF.Create_billing_schedule',
10950: 'oks_bill_sch.create_bill_sch_rules(Return status = '
10951: || l_return_status
10952: || ')'
10953: );
10954: END IF;

Line 10984: oks_bill_sch.update_om_sll_date

10980: IF check_lvlelements_exists (p_line_id)
10981: THEN
10982: IF p_update_line = 'Y'
10983: THEN
10984: oks_bill_sch.update_om_sll_date
10985: (p_top_line_id => p_line_id,
10986: x_return_status => l_return_status,
10987: x_msg_count => x_msg_count,
10988: x_msg_data => x_msg_data

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

10995: fnd_log.STRING
10996: (fnd_log.level_event,
10997: g_module_current
10998: || '.CREATE_K_SYSTEM_TRF.Create_billing_schedule',
10999: 'oks_bill_sch.update_om_sll_date(Return status = '
11000: || l_return_status
11001: || ')'
11002: );
11003: END IF;

Line 11010: oks_bill_sch.create_bill_sch_cp

11006: THEN
11007: RAISE g_exception_halt_validation;
11008: END IF;
11009: ELSE
11010: oks_bill_sch.create_bill_sch_cp
11011: (p_top_line_id => p_line_id,
11012: p_cp_line_id => p_covlvl_id,
11013: p_cp_new => 'Y',
11014: x_return_status => l_return_status,

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

11022: fnd_log.STRING
11023: (fnd_log.level_event,
11024: g_module_current
11025: || '.CREATE_K_SYSTEM_TRF.Create_billing_schedule',
11026: 'oks_bill_sch.create_bill_sch_cp(Return status = '
11027: || l_return_status
11028: || ')'
11029: );
11030: END IF;

Line 15853: l_sll_tbl oks_bill_sch.streamlvl_tbl;

15849: l_srvc_stdt DATE;
15850: l_bill_schd_yn VARCHAR2 (1);
15851: l_dur NUMBER;
15852: l_time VARCHAR2 (25);
15853: l_sll_tbl oks_bill_sch.streamlvl_tbl;
15854: l_bil_sch_out oks_bill_sch.itembillsch_tbl;
15855: l_strmlvl_id NUMBER := NULL;
15856: l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
15857: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;

Line 15854: l_bil_sch_out oks_bill_sch.itembillsch_tbl;

15850: l_bill_schd_yn VARCHAR2 (1);
15851: l_dur NUMBER;
15852: l_time VARCHAR2 (25);
15853: l_sll_tbl oks_bill_sch.streamlvl_tbl;
15854: l_bil_sch_out oks_bill_sch.itembillsch_tbl;
15855: l_strmlvl_id NUMBER := NULL;
15856: l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
15857: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;
15858: l_ctr NUMBER;

Line 16077: oks_bill_sch.create_bill_sch_cp

16073: RAISE g_exception_halt_validation;
16074: END IF;
16075:
16076: ---update billing schedule
16077: oks_bill_sch.create_bill_sch_cp
16078: (p_top_line_id => p_kdtl_tbl (l_ctr).service_line_id,
16079: p_cp_line_id => p_kdtl_tbl (l_ctr).object_line_id,
16080: p_cp_new => 'N',
16081: x_return_status => l_return_status,

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

16089: THEN
16090: fnd_log.STRING
16091: (fnd_log.level_event,
16092: g_module_current || '.CREATE_CONTRACT_IBUPDATE',
16093: 'Oks_bill_sch.Create_Bill_Sch_CP(Return status = '
16094: || l_return_status
16095: || ')'
16096: );
16097: END IF;

Line 16701: oks_bill_sch.create_bill_sch_cp

16697: IF check_lvlelements_exists
16698: (p_kdtl_tbl (l_ctr).service_line_id
16699: )
16700: THEN
16701: oks_bill_sch.create_bill_sch_cp
16702: (p_top_line_id => p_kdtl_tbl (l_ctr).service_line_id,
16703: p_cp_line_id => l_covlvl_id,
16704: p_cp_new => 'Y',
16705: x_return_status => l_return_status,

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

16714: fnd_log.STRING
16715: (fnd_log.level_event,
16716: g_module_current
16717: || '.CREATE_CONTRACT_IBUPDATE',
16718: 'oks_bill_sch.create_bill_sch_cp(Retun status = '
16719: || l_return_status
16720: || ')'
16721: );
16722: END IF;

Line 16856: oks_bill_sch.create_bill_sch_cp

16852: IF check_lvlelements_exists
16853: (p_kdtl_tbl (l_ctr).service_line_id
16854: )
16855: THEN
16856: oks_bill_sch.create_bill_sch_cp
16857: (p_top_line_id => p_kdtl_tbl (l_ctr).service_line_id,
16858: p_cp_line_id => p_kdtl_tbl (l_ctr).object_line_id,
16859: p_cp_new => 'N',
16860: x_return_status => l_return_status,

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

16869: fnd_log.STRING
16870: (fnd_log.level_event,
16871: g_module_current
16872: || '.CREATE_CONTRACT_IBUPDATE',
16873: 'oks_bill_sch.create_bill_sch_cp(Retun status = '
16874: || l_return_status
16875: || ')'
16876: );
16877: END IF;