134: ln_last_updated_by := ln_created_by;
135: ln_last_update_login := FND_GLOBAL.login_id;
136:
137: lv_statement_id := '1';
138: ln_fin_year := jai_general_pkg.get_fin_year(p_organization_id);
139: lv_statement_id := '2';
140: lv_primary_uom_code := jai_general_pkg.get_primary_uom_code(p_organization_id, p_inventory_item_id);
141:
142: lv_transaction_type := p_transaction_type;
136:
137: lv_statement_id := '1';
138: ln_fin_year := jai_general_pkg.get_fin_year(p_organization_id);
139: lv_statement_id := '2';
140: lv_primary_uom_code := jai_general_pkg.get_primary_uom_code(p_organization_id, p_inventory_item_id);
141:
142: lv_transaction_type := p_transaction_type;
143:
144: lv_statement_id := '3';
153: GOTO end_of_processing;
154: END IF;
155:
156: lv_statement_id := '5';
157: vTransToPrimaryUOMConv := jai_general_pkg.trxn_to_primary_conv_rate
158: (p_transaction_uom_code, lv_primary_uom_code, p_inventory_item_id);
159:
160: ln_quantity := p_quantity_received * vTransToPrimaryUOMConv;
161: ln_qty_to_adjust := p_qty_to_adjust * vTransToPrimaryUOMConv;
161: ln_qty_to_adjust := p_qty_to_adjust * vTransToPrimaryUOMConv;
162: ln_quantity_issued := p_quantity_issued * vTransToPrimaryUOMConv;
163:
164: lv_statement_id := '6';
165: ln_last_register_id := jai_general_pkg.get_last_record_of_rg
166: ('RG23D', p_organization_id, p_location_id, p_inventory_item_id, ln_fin_year);
167:
168: lv_statement_id := '7';
169: OPEN c_get_last_record(ln_last_register_id);