[Home] [Help]
1: PACKAGE BODY PA_PWP_SUMM_PKG AS
2: -- $Header: PAPWPSMB.pls 120.19 2011/06/28 09:56:53 jjgeorge noship $
3:
4: -- This procedure populates data in PA_PWP_CUSTOMER_SUMM_ALL table.
5: -- The data populated in PA_PWP_CUSTOMER_SUMM_ALL table is used in subcontractor
6: --(supplier) workbench.
7: PROCEDURE Populate_summary
8: (P_Project_Id IN NUMBER)
1: PACKAGE BODY PA_PWP_SUMM_PKG AS
2: -- $Header: PAPWPSMB.pls 120.19 2011/06/28 09:56:53 jjgeorge noship $
3:
4: -- This procedure populates data in PA_PWP_CUSTOMER_SUMM_ALL table.
5: -- The data populated in PA_PWP_CUSTOMER_SUMM_ALL table is used in subcontractor
6: --(supplier) workbench.
7: PROCEDURE Populate_summary
8: (P_Project_Id IN NUMBER)
9: IS
459: WHERE PWP.project_id = P_Project_Id ;
460:
461: */
462:
463: UPDATE PA_PWP_CUSTOMER_SUMM_ALL pwp
464: SET
465: ( bill_to_address,
466: ship_to_address
467: )