APPS.JAI_OPM_GBH_TRIGGER_PKG dependencies on JAI_OPM_OSP_HDRS

Line 17: FROM JAI_OPM_OSP_HDRS

13: */
14: PROCEDURE ARU_T1 ( pr_old t_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
15:
16: Cursor C_Reg_Sel IS SELECT register_selected, po_id
17: FROM JAI_OPM_OSP_HDRS
18: WHERE osp_header_id = pr_new.batch_id ;
19:
20: Cursor C_Vend_Id(p_po_id number) IS SELECT a. Vendor_id, a.ship_to_location_id, b.location_code FROM po_headers_all a, hr_locations_all b
21: WHERE po_header_id = p_po_id

Line 64: lv_register JAI_OPM_OSP_HDRS.REGISTER_SELECTED%type ;

60: return_days number;
61: l_location_id po_headers_all.ship_to_location_id%TYPE; /* Bug#9088563 */
62:
63: /* Added by Ramananda for removal of SQL LITERALs */
64: lv_register JAI_OPM_OSP_HDRS.REGISTER_SELECTED%type ;
65: lv_tran_name JAI_OPM_TXN_EXTN_HDRS.transaction_name%type ;
66:
67: BEGIN
68: pv_return_code := jai_constants.successful ;

Line 81: Major dependency issues arise out of this bug.New columns have been added to the JAI_OPM_OSP_HDRS

77: Since OPM 11.5.8 (OPM I ) , the table is changed to GME_BATCH_HEADER instead of the
78: table pm_btch_hdr .
79:
80: 3. ssumaith - bug # 2959256
81: Major dependency issues arise out of this bug.New columns have been added to the JAI_OPM_OSP_HDRS
82: table.The columns added are fin_year, form_number.All further patches using this object will need
83: to have this as a pre-requisite.
84:
85: 4. ssumaith - Bug # 3015825

Line 215: UPDATE JAI_OPM_OSP_HDRS

211: CLOSE C_Tot_Excise;
212:
213: l_recv_qty := ((nvl(l_act_tot_qty,0) / nvl(l_plan_qty,0))* nvl(l_tot_excise_payable,0));
214:
215: UPDATE JAI_OPM_OSP_HDRS
216: SET final_receipt = 'Y',
217: receivable_excise = l_recv_qty
218: WHERE osp_header_id = pr_new.batch_id;
219: END IF;