APPS.OKL_BILLING_CONTROLLER_PVT dependencies on OKL_EXT_SELL_INVS_TL

Line 3028: update okl_ext_sell_invs_tl

3024: PRINT_TO_LOG('Performing bulk update for xsi tl, record count is '||g_xsi_tl_tbl.COUNT );
3025: BEGIN
3026: savepoint U3;
3027: for u in g_xsi_tl_tbl.first..g_xsi_tl_tbl.last loop
3028: update okl_ext_sell_invs_tl
3029: set xtrx_cons_invoice_number = g_xsi_tl_tbl(u).xtrx_cons_invoice_number,
3030: xtrx_format_type = g_xsi_tl_tbl(u).xtrx_format_type,
3031: xtrx_private_label = g_xsi_tl_tbl(u).xtrx_private_label,
3032: last_update_date = sysdate,

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

3035: where id = g_xsi_tl_tbl(u).id;
3036: end loop;
3037: EXCEPTION
3038: WHEN OTHERS THEN
3039: PRINT_TO_LOG('Error during Update of okl_ext_sell_invs_tl, rollback to U3');
3040: rollback to U3;
3041: RAISE;
3042: END;
3043: commit;

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 3911: okl_ext_sell_invs_tl xsit,

3907: xls.sel_id sel_id,
3908: xsib.legal_entity_id legal_entity_id -- for LE Uptake project 08-11-2006
3909: FROM
3910: okl_ext_sell_invs_b xsib,
3911: okl_ext_sell_invs_tl xsit,
3912: okl_xtl_sell_invs_b xls,
3913: okl_txd_ar_ln_dtls_b tld,
3914: okl_txl_ar_inv_lns_b til,
3915: okl_trx_ar_invoices_b tai,

Line 4667: update okl_ext_sell_invs_tl

4663: PRINT_TO_LOG('Performing final bulk update for xsi tl, record count is '||g_xsi_tl_tbl.COUNT );
4664: BEGIN
4665: savepoint U7;
4666: for u in g_xsi_tl_tbl.first..g_xsi_tl_tbl.last loop
4667: update okl_ext_sell_invs_tl
4668: set xtrx_cons_invoice_number = g_xsi_tl_tbl(u).xtrx_cons_invoice_number,
4669: xtrx_format_type = g_xsi_tl_tbl(u).xtrx_format_type,
4670: xtrx_private_label = g_xsi_tl_tbl(u).xtrx_private_label,
4671: last_update_date = sysdate,

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

4678: g_xsi_tl_tbl.delete;
4679: g_xsi_tl_counter := 0;
4680: EXCEPTION
4681: WHEN OTHERS THEN
4682: PRINT_TO_LOG('Error during Update of okl_ext_sell_invs_tl, rollback to U7');
4683: rollback to U7;
4684: RAISE;
4685: END;
4686: end if;

Line 5172: update okl_ext_sell_invs_tl

5168: PRINT_TO_LOG('Performing final bulk update for xsi tl, record count is '||g_xsi_tl_tbl.COUNT );
5169: BEGIN
5170: savepoint U7;
5171: for u in g_xsi_tl_tbl.first..g_xsi_tl_tbl.last loop
5172: update okl_ext_sell_invs_tl
5173: set xtrx_cons_invoice_number = g_xsi_tl_tbl(u).xtrx_cons_invoice_number,
5174: xtrx_format_type = g_xsi_tl_tbl(u).xtrx_format_type,
5175: xtrx_private_label = g_xsi_tl_tbl(u).xtrx_private_label,
5176: last_update_date = sysdate,

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

5183: g_xsi_tl_tbl.delete;
5184: g_xsi_tl_counter := 0;
5185: EXCEPTION
5186: WHEN OTHERS THEN
5187: PRINT_TO_LOG('Error during Update of okl_ext_sell_invs_tl, rollback to U7');
5188: rollback to U7;
5189: RAISE;
5190: END;
5191: end if;