APPS.JAI_BOE_GENERAL_PKG dependencies on JAI_CMN_BOE_HDRS

Line 300: FROM jai_cmn_boe_hdrs jbh

296: IS
297: CURSOR get_boe_status_cur(pn_boe_id IN NUMBER)
298: IS
299: SELECT 'APPLIED' boe_status, jbh.boe_id
300: FROM jai_cmn_boe_hdrs jbh
301: WHERE jbh.boe_id = pn_boe_id
302: -- AND jbh.status = 'APPLIED' Comment out the condition for bug#12673597.
303: AND nvl(jbh.amount_applied, 0) > 0;
304:

Line 383: nvl(lv_product_table, '###') <> 'JAI_CMN_BOE_HDRS' OR

379: INTO ln_applicaton_id, lv_product_table, lv_reference_key1, lv_reference_key2, lv_reference_key3, lv_reference_key4, lv_reference_key5;
380: CLOSE get_invoice_info_cur;
381:
382: IF nvl(ln_applicaton_id, -1) <> 7000 OR
383: nvl(lv_product_table, '###') <> 'JAI_CMN_BOE_HDRS' OR
384: lv_reference_key1 IS NULL
385: THEN
386: lv_return := 'N';
387: ELSE

Line 477: UPDATE JAI_CMN_BOE_HDRS hdr

473: lv_count_detail number;
474: lv_count_round number;
475: lv_count_tax number;
476: BEGIN
477: UPDATE JAI_CMN_BOE_HDRS hdr
478: SET hdr.status = 'CANCELLED'
479: ,hdr.BOE_AMOUNT = 0
480: ,hdr.AMOUNT_APPLIED = 0
481: ,hdr.AMOUNT_WRITTEN_OFF = 0