APPS.JAI_CMN_RG_PLA_TRXS_PKG dependencies on JAI_GENERAL_PKG

Line 159: ln_fin_year := jai_general_pkg.get_fin_year(p_organization_id);

155: FETCH c_orgn_info INTO r_orgn_info;
156: CLOSE c_orgn_info;
157:
158: lv_statement_id := '5';
159: ln_fin_year := jai_general_pkg.get_fin_year(p_organization_id);
160:
161: lv_statement_id := '6';
162: lv_last_register_id := jai_general_pkg.get_last_record_of_rg
163: ('PLA', p_organization_id, p_location_id, p_inventory_item_id, ln_fin_year);

Line 162: lv_last_register_id := jai_general_pkg.get_last_record_of_rg

158: lv_statement_id := '5';
159: ln_fin_year := jai_general_pkg.get_fin_year(p_organization_id);
160:
161: lv_statement_id := '6';
162: lv_last_register_id := jai_general_pkg.get_last_record_of_rg
163: ('PLA', p_organization_id, p_location_id, p_inventory_item_id, ln_fin_year);
164:
165: IF lv_last_register_id IS NULL THEN
166: IF r_orgn_info.ssi_unit_flag = jai_general_pkg.NO THEN

Line 166: IF r_orgn_info.ssi_unit_flag = jai_general_pkg.NO THEN

162: lv_last_register_id := jai_general_pkg.get_last_record_of_rg
163: ('PLA', p_organization_id, p_location_id, p_inventory_item_id, ln_fin_year);
164:
165: IF lv_last_register_id IS NULL THEN
166: IF r_orgn_info.ssi_unit_flag = jai_general_pkg.NO THEN
167: -- this is not an Error Condition
168: lv_message := 'PLA Register doesnt have sufficient balances';
169: GOTO end_of_processing;
170: ELSE

Line 200: IF r_orgn_info.ssi_unit_flag = jai_general_pkg.NO THEN

196: );
197:
198: ln_closing_balance := ln_opening_balance + ln_tr_amount;
199:
200: IF r_orgn_info.ssi_unit_flag = jai_general_pkg.NO THEN
201: -- *** check whether the balances are enough
202: IF ln_closing_balance < 0 THEN
203: lv_message := 'PLA Register doesnt have sufficient balances';
204: GOTO end_of_processing;

Line 215: lv_master_flag := jai_general_pkg.get_orgn_master_flag(p_organization_id, p_location_id);

211: ln_last_updated_by := ln_created_by;
212: ln_last_update_login := FND_GLOBAL.login_id;
213:
214: lv_statement_id := '9';
215: lv_master_flag := jai_general_pkg.get_orgn_master_flag(p_organization_id, p_location_id);
216:
217: lv_statement_id := '10';
218: jai_general_pkg.get_range_division(p_vendor_id, p_vendor_site_id, lv_range, lv_division);
219:

Line 218: jai_general_pkg.get_range_division(p_vendor_id, p_vendor_site_id, lv_range, lv_division);

214: lv_statement_id := '9';
215: lv_master_flag := jai_general_pkg.get_orgn_master_flag(p_organization_id, p_location_id);
216:
217: lv_statement_id := '10';
218: jai_general_pkg.get_range_division(p_vendor_id, p_vendor_site_id, lv_range, lv_division);
219:
220: -- added, Harshita for 4892111
221: OPEN c_fetch_register_id ;
222: FETCH c_fetch_register_id INTO ln_register_id ;