APPS.OKL_BILLING_CONTROLLER_PVT dependencies on OKL_EXT_SELL_INVS_TL

Line 2964: update okl_ext_sell_invs_tl

2960: PRINT_TO_LOG('Performing bulk update for xsi tl, record count is '||g_xsi_tl_tbl.COUNT );
2961: BEGIN
2962: savepoint U3;
2963: for u in g_xsi_tl_tbl.first..g_xsi_tl_tbl.last loop
2964: update okl_ext_sell_invs_tl
2965: set xtrx_cons_invoice_number = g_xsi_tl_tbl(u).xtrx_cons_invoice_number,
2966: xtrx_format_type = g_xsi_tl_tbl(u).xtrx_format_type,
2967: xtrx_private_label = g_xsi_tl_tbl(u).xtrx_private_label,
2968: last_update_date = sysdate,

Line 2975: PRINT_TO_LOG('Error during Update of okl_ext_sell_invs_tl, rollback to U3');

2971: where id = g_xsi_tl_tbl(u).id;
2972: end loop;
2973: EXCEPTION
2974: WHEN OTHERS THEN
2975: PRINT_TO_LOG('Error during Update of okl_ext_sell_invs_tl, rollback to U3');
2976: rollback to U3;
2977: RAISE;
2978: END;
2979: commit;

Line 3783: okl_ext_sell_invs_tl xsit,

3779: xls.sel_id sel_id,
3780: xsib.legal_entity_id legal_entity_id -- for LE Uptake project 08-11-2006
3781: FROM
3782: okl_ext_sell_invs_b xsib,
3783: okl_ext_sell_invs_tl xsit,
3784: okl_xtl_sell_invs_b xls,
3785: okl_txd_ar_ln_dtls_b tld,
3786: okl_txl_ar_inv_lns_b til,
3787: okl_trx_ar_invoices_b tai,

Line 3847: okl_ext_sell_invs_tl xsit,

3843: xls.sel_id sel_id,
3844: xsib.legal_entity_id legal_entity_id -- for LE Uptake project 08-11-2006
3845: FROM
3846: okl_ext_sell_invs_b xsib,
3847: okl_ext_sell_invs_tl xsit,
3848: okl_xtl_sell_invs_b xls,
3849: okl_txd_ar_ln_dtls_b tld,
3850: okl_txl_ar_inv_lns_b til,
3851: okl_trx_ar_invoices_b tai,

Line 4603: update okl_ext_sell_invs_tl

4599: PRINT_TO_LOG('Performing final bulk update for xsi tl, record count is '||g_xsi_tl_tbl.COUNT );
4600: BEGIN
4601: savepoint U7;
4602: for u in g_xsi_tl_tbl.first..g_xsi_tl_tbl.last loop
4603: update okl_ext_sell_invs_tl
4604: set xtrx_cons_invoice_number = g_xsi_tl_tbl(u).xtrx_cons_invoice_number,
4605: xtrx_format_type = g_xsi_tl_tbl(u).xtrx_format_type,
4606: xtrx_private_label = g_xsi_tl_tbl(u).xtrx_private_label,
4607: last_update_date = sysdate,

Line 4618: PRINT_TO_LOG('Error during Update of okl_ext_sell_invs_tl, rollback to U7');

4614: g_xsi_tl_tbl.delete;
4615: g_xsi_tl_counter := 0;
4616: EXCEPTION
4617: WHEN OTHERS THEN
4618: PRINT_TO_LOG('Error during Update of okl_ext_sell_invs_tl, rollback to U7');
4619: rollback to U7;
4620: RAISE;
4621: END;
4622: end if;

Line 5108: update okl_ext_sell_invs_tl

5104: PRINT_TO_LOG('Performing final bulk update for xsi tl, record count is '||g_xsi_tl_tbl.COUNT );
5105: BEGIN
5106: savepoint U7;
5107: for u in g_xsi_tl_tbl.first..g_xsi_tl_tbl.last loop
5108: update okl_ext_sell_invs_tl
5109: set xtrx_cons_invoice_number = g_xsi_tl_tbl(u).xtrx_cons_invoice_number,
5110: xtrx_format_type = g_xsi_tl_tbl(u).xtrx_format_type,
5111: xtrx_private_label = g_xsi_tl_tbl(u).xtrx_private_label,
5112: last_update_date = sysdate,

Line 5123: PRINT_TO_LOG('Error during Update of okl_ext_sell_invs_tl, rollback to U7');

5119: g_xsi_tl_tbl.delete;
5120: g_xsi_tl_counter := 0;
5121: EXCEPTION
5122: WHEN OTHERS THEN
5123: PRINT_TO_LOG('Error during Update of okl_ext_sell_invs_tl, rollback to U7');
5124: rollback to U7;
5125: RAISE;
5126: END;
5127: end if;