APPS.JAI_OPM_GMD_TRIGGER_PKG dependencies on JAI_OPM_OSP_DTLS

Line 27: Cursor C_Rec_Exist IS SELECT rowid, unit_price FROM JAI_OPM_OSP_DTLS

23: , ja_osp_batch
24: from gme_batch_header
25: WHERE batch_id =pr_new.batch_id;
26:
27: Cursor C_Rec_Exist IS SELECT rowid, unit_price FROM JAI_OPM_OSP_DTLS
28: WHERE osp_header_id = pr_new.batch_id
29: AND organization_id = pr_new.organization_id
30: AND inventory_item_id = pr_new.inventory_item_id;
31:

Line 164: UPDATE JAI_OPM_OSP_DTLS

160:
161: END IF;
162: l_excise_payable := ((NVL(l_unit_price,0)*pr_new.actual_qty*nvl(l_excise_rate,0))/100);
163:
164: UPDATE JAI_OPM_OSP_DTLS
165: SET act_quantity = pr_new.actual_qty,
166: excise_payable = l_excise_payable,
167: last_updated_by = l_updated_by,
168: last_update_date = sysdate

Line 180: INSERT INTO JAI_OPM_OSP_DTLS (OSP_DETAIL_ID,

176: OPEN c_get_location_id (ln_po_id);
177: FETCH c_get_location_id INTO l_location_id;
178: CLOSE c_get_location_id;
179:
180: INSERT INTO JAI_OPM_OSP_DTLS (OSP_DETAIL_ID,
181: OSP_HEADER_ID,
182: TRANS_DATE,
183: UOM_CODE,
184: PLAN_QUANTITY ,

Line 199: VALUES ( JAI_OPM_OSP_DTLS_S1.NEXTVAL,

195: PROCESSING_CHARGE,
196: MAIN_RCPT_FLAG,
197: inventory_item_id,
198: organization_id)
199: VALUES ( JAI_OPM_OSP_DTLS_S1.NEXTVAL,
200: pr_new.batch_id,
201: sysdate,
202: /* Commented by nprashar for bug 7540543
203: pr_new.item_um,