APPS.JAI_OPM_GMD_TRIGGER_PKG dependencies on JAI_OPM_OSP_DTLS

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

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

Line 158: UPDATE JAI_OPM_OSP_DTLS

154:
155: END IF;
156: l_excise_payable := ((NVL(l_unit_price,0)*pr_new.actual_qty*nvl(l_excise_rate,0))/100);
157:
158: UPDATE JAI_OPM_OSP_DTLS
159: SET act_quantity = pr_new.actual_qty,
160: excise_payable = l_excise_payable,
161: last_updated_by = l_updated_by,
162: last_update_date = sysdate

Line 174: INSERT INTO JAI_OPM_OSP_DTLS (OSP_DETAIL_ID,

170: OPEN c_get_location_id (ln_po_id);
171: FETCH c_get_location_id INTO l_location_id;
172: CLOSE c_get_location_id;
173:
174: INSERT INTO JAI_OPM_OSP_DTLS (OSP_DETAIL_ID,
175: OSP_HEADER_ID,
176: TRANS_DATE,
177: UOM_CODE,
178: PLAN_QUANTITY ,

Line 193: VALUES ( JAI_OPM_OSP_DTLS_S1.NEXTVAL,

189: PROCESSING_CHARGE,
190: MAIN_RCPT_FLAG,
191: inventory_item_id,
192: organization_id)
193: VALUES ( JAI_OPM_OSP_DTLS_S1.NEXTVAL,
194: pr_new.batch_id,
195: sysdate,
196: /* Commented by nprashar for bug 7540543
197: pr_new.item_um,