748: -- X_BILL_TO_SITE_STATUS VARCHAR2
749: -- X_SHIP_TO_SITE_STATUS VARCHAR2
750: --
751: PROCEDURE Get_active_sites
752: ( P_BILL_TO_ADDRESS_ID IN PA_PLSQL_DATATYPES.IdTabTyp ,
753: P_SHIP_TO_ADDRESS_ID IN PA_PLSQL_DATATYPES.IdTabTyp ,
754: P_NO_OF_RECORDS IN NUMBER,
755: P_CUST_CREDIT_HOLD IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp, --File.Sql.39 bug 4440895
756: X_BILL_TO_SITE_USE_ID OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
749: -- X_SHIP_TO_SITE_STATUS VARCHAR2
750: --
751: PROCEDURE Get_active_sites
752: ( P_BILL_TO_ADDRESS_ID IN PA_PLSQL_DATATYPES.IdTabTyp ,
753: P_SHIP_TO_ADDRESS_ID IN PA_PLSQL_DATATYPES.IdTabTyp ,
754: P_NO_OF_RECORDS IN NUMBER,
755: P_CUST_CREDIT_HOLD IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp, --File.Sql.39 bug 4440895
756: X_BILL_TO_SITE_USE_ID OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
757: X_SHIP_TO_SITE_USE_ID OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
751: PROCEDURE Get_active_sites
752: ( P_BILL_TO_ADDRESS_ID IN PA_PLSQL_DATATYPES.IdTabTyp ,
753: P_SHIP_TO_ADDRESS_ID IN PA_PLSQL_DATATYPES.IdTabTyp ,
754: P_NO_OF_RECORDS IN NUMBER,
755: P_CUST_CREDIT_HOLD IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp, --File.Sql.39 bug 4440895
756: X_BILL_TO_SITE_USE_ID OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
757: X_SHIP_TO_SITE_USE_ID OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
758: X_BILL_TO_SITE_STATUS OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp, --File.Sql.39 bug 4440895
759: X_SHIP_TO_SITE_STATUS OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp) --File.Sql.39 bug 4440895
752: ( P_BILL_TO_ADDRESS_ID IN PA_PLSQL_DATATYPES.IdTabTyp ,
753: P_SHIP_TO_ADDRESS_ID IN PA_PLSQL_DATATYPES.IdTabTyp ,
754: P_NO_OF_RECORDS IN NUMBER,
755: P_CUST_CREDIT_HOLD IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp, --File.Sql.39 bug 4440895
756: X_BILL_TO_SITE_USE_ID OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
757: X_SHIP_TO_SITE_USE_ID OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
758: X_BILL_TO_SITE_STATUS OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp, --File.Sql.39 bug 4440895
759: X_SHIP_TO_SITE_STATUS OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp) --File.Sql.39 bug 4440895
760: IS
753: P_SHIP_TO_ADDRESS_ID IN PA_PLSQL_DATATYPES.IdTabTyp ,
754: P_NO_OF_RECORDS IN NUMBER,
755: P_CUST_CREDIT_HOLD IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp, --File.Sql.39 bug 4440895
756: X_BILL_TO_SITE_USE_ID OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
757: X_SHIP_TO_SITE_USE_ID OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
758: X_BILL_TO_SITE_STATUS OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp, --File.Sql.39 bug 4440895
759: X_SHIP_TO_SITE_STATUS OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp) --File.Sql.39 bug 4440895
760: IS
761: I number;
754: P_NO_OF_RECORDS IN NUMBER,
755: P_CUST_CREDIT_HOLD IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp, --File.Sql.39 bug 4440895
756: X_BILL_TO_SITE_USE_ID OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
757: X_SHIP_TO_SITE_USE_ID OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
758: X_BILL_TO_SITE_STATUS OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp, --File.Sql.39 bug 4440895
759: X_SHIP_TO_SITE_STATUS OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp) --File.Sql.39 bug 4440895
760: IS
761: I number;
762: BEGIN
755: P_CUST_CREDIT_HOLD IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp, --File.Sql.39 bug 4440895
756: X_BILL_TO_SITE_USE_ID OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
757: X_SHIP_TO_SITE_USE_ID OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
758: X_BILL_TO_SITE_STATUS OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp, --File.Sql.39 bug 4440895
759: X_SHIP_TO_SITE_STATUS OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp) --File.Sql.39 bug 4440895
760: IS
761: I number;
762: BEGIN
763: