[Home] [Help]
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;