APPS.JAI_JOM_LM_TRIGGER_PKG dependencies on JAI_OM_LC_HDRS

Line 17: FROM JAI_OM_LC_HDRS

13: */
14: PROCEDURE ARI_T1 ( pr_old t_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
15: CURSOR Lc_Check_Count IS
16: SELECT COUNT(*)
17: FROM JAI_OM_LC_HDRS
18: WHERE lc_number = pr_new.lc_number;
19:
20: CURSOR c_lc_Balance IS
21: SELECT LC_BALANCE_AMOUNT

Line 22: FROM JAI_OM_LC_HDRS

18: WHERE lc_number = pr_new.lc_number;
19:
20: CURSOR c_lc_Balance IS
21: SELECT LC_BALANCE_AMOUNT
22: FROM JAI_OM_LC_HDRS
23: WHERE LC_NUMBER = pr_new.LC_NUMBER;
24:
25:
26: lv_amount_applied NUMBER; -- := pr_new.amount; --Ramananda for File.Sql.35

Line 58: UPDATE JAI_OM_LC_HDRS

54: IF lv_lc_count > 0
55: THEN
56: /*Bug6124130 bduvarag, added the = condition */
57: IF v_lc_balance - lv_amount_applied >= 0 Then
58: UPDATE JAI_OM_LC_HDRS
59: SET lc_balance_amount = ROUND(NVL(lc_balance_amount,0),2) - ROUND(NVL(lv_amount_applied,0),2)
60: WHERE lc_number = pr_new.lc_number;
61: ELSE
62: /* RAISE_APPLICATION_ERROR(-20102,'There is not enough Balance available for this Matching');