APPS.JAI_CMN_RG_TRANSFER_PKG dependencies on JAI_CMN_RG_BALANCES

Line 64: from JAI_CMN_RG_BALANCES

60: p_org_code_to org_organization_definitions.organization_code%type; --Added by nprashar for bug # 13824043
61:
62: CURSOR c_rg_balances(p_organization_id NUMBER, p_location_id NUMBER) IS
63: select nvl(rg23a_balance,0), nvl(rg23c_balance,0), nvl(pla_balance,0)
64: from JAI_CMN_RG_BALANCES
65: where organization_id = p_organization_id
66: and location_id = p_location_id;
67:
68: --Added by Sanjikum for cess for Bug #4136939

Line 101: from JAI_CMN_RG_BALANCES

97: AND a.tax_type = NVL(p_tax_type,a.tax_type);
98: /*Bug 5989740 bduvarag end*/
99: CURSOR balances_to_exist IS
100: select count(1)
101: from JAI_CMN_RG_BALANCES
102: where organization_id = p_to_organization_id
103: and location_id = p_to_location_id;
104:
105: CURSOR balance_cur(p_serial_no IN NUMBER, p_org_id NUMBER, p_location_id NUMBER,

Line 204: FROM JAI_CMN_RG_BALANCES_v

200: lv_reference_num jai_cmn_rg_23ac_ii_trxs.reference_num%TYPE ;--rchandan for bug#4428980
201: /*Bug 4543171 bduvarag start*/
202: CURSOR currency_cur IS
203: SELECT currency_code
204: FROM JAI_CMN_RG_BALANCES_v
205: WHERE organization_id = p_Organization_ID and Location_ID = p_Location_ID;
206:
207: /* Added by Ramananda for bug#4404994, start */
208:

Line 909: UPDATE JAI_CMN_RG_BALANCES

905: to_char(p_organization_id) || ' and location:' ||to_char(p_location_id));
906: END IF;
907:
908: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Updating the balances of the from org');
909: UPDATE JAI_CMN_RG_BALANCES
910: SET pla_balance = v_pla_bal,
911: rg23a_balance = v_rg23a_bal,
912: rg23c_balance = v_rg23c_bal
913: WHERE organization_id = p_organization_id

Line 918: UPDATE JAI_CMN_RG_BALANCES

914: and location_id = p_location_id;
915:
916: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Updating the balances of the TO org');
917:
918: UPDATE JAI_CMN_RG_BALANCES
919: SET pla_balance = v_to_pla_bal,
920: rg23a_balance = v_to_rg23a_bal,
921: rg23c_balance = v_to_rg23c_bal
922: where organization_id = p_to_organization_id