DBA Data[Home] [Help]

APPS.JAI_PO_HOOK_PKG dependencies on JAI_RCV_LINES

Line 489: UPDATE JAI_RCV_LINES

485: ); -- Added by Jia for GST Bug#10043656 on 2010/09/10
486:
487: ln_tax_amount := ln_line_amount;
488:
489: UPDATE JAI_RCV_LINES
490: SET Last_Update_Date = SYSDATE,
491: tax_amount = ln_tax_amount,
492: Last_Updated_By = r_rcpt_line.last_updated_by,
493: Last_Update_Login = r_rcpt_line.last_update_login

Line 657: /*UPDATE JAI_RCV_LINES

653: ); -- Added by Jia for GST Bug#10043656 on 2010/09/10
654:
655: --ln_tax_amount := ln_line_amount;
656:
657: /*UPDATE JAI_RCV_LINES
658: SET Last_Update_Date = sysdate,
659: tax_amount = ln_tax_amount ,
660: Last_Updated_By = r_rcpt_line.last_updated_by,
661: Last_Update_Login = r_rcpt_line.last_update_login

Line 748: FROM JAI_RCV_LINES

744: ln_organization_id NUMBER;
745:
746: CURSOR c_rcpt_cur IS
747: SELECT *
748: FROM JAI_RCV_LINES
749: WHERE shipment_header_id = p_shipment_header_id;
750:
751: r_rcpt_rec c_rcpt_cur%ROWTYPE;
752: ln_batch_id NUMBER;