PACKAGE: APPS.BEN_SUM

Source

1 PACKAGE ben_sum AUTHID CURRENT_USER AS
2 /* $Header: bensumfm.pkh 115.1 2003/02/12 10:30:40 rpgupta noship $ */
3 --
4 TYPE sum_rec IS RECORD (
5 ORDER_NUM1          ben_benefits_summary_v.ORDER_NUM1%TYPE
6 ,ORDER_NUM2         ben_benefits_summary_v.ORDER_NUM2%TYPE
7 ,ORDER_NUM3         ben_benefits_summary_v.ORDER_NUM3%TYPE
8 ,NAME               ben_benefits_summary_v.NAME%TYPE
9 ,ID                 ben_benefits_summary_v.ID%TYPE
10 ,BUSINESS_GROUP_ID  ben_benefits_summary_v.BUSINESS_GROUP_ID%TYPE
11 ,PERSON_ID          ben_benefits_summary_v.PERSON_ID%TYPE
12 ,MEANING            ben_benefits_summary_v.MEANING%TYPE
13 ,TYPE               ben_benefits_summary_v.TYPE%TYPE
14 ,OBJECT_TYPE_CD     ben_benefits_summary_v.OBJECT_TYPE_CD%TYPE
15 );
16 --
17 TYPE sumtab IS TABLE OF sum_rec INDEX BY BINARY_INTEGER;
18 --
19 PROCEDURE sum_query
20   (block_data  IN OUT NOCOPY sumtab
21   ,p_person_id IN     NUMBER
22   );
23 --
24 END ben_sum;