1 PACKAGE IEO_SUM_AVB_RECORD AUTHID CURRENT_USER AS
2 /* $Header: IEOSRECS.pls 115.9 2003/01/02 17:08:59 dolee ship $ */
3
4 ------------------------------------------------------------------------------
5 -- Function : TOTAL_RECORD_FOR_IEO_CAMP
6 -- Description : calculate the total number of available records for one
7 -- specified campaign plus service
8 -- Parameters :
9 -- IN : LIST_SRV_NAME_Value IN VARCHAR2 Required
10 -- Name of campaign plus service
11 -- Return : NUMBER
12 -- Returns total number of available records
13 ------------------------------------------------------------------------------
14 FUNCTION TOTAL_RECORD_FOR_IEO_CAMP(LIST_SRV_NAME_Value IN VARCHAR2) RETURN NUMBER;
15
16 ------------------------------------------------------------------------------
17 -- Function : TOTAL_RECORD_FOR_AMS_CAMP
18 -- Description : calculate the total number of available records for one
19 -- specified campaign ID
20 -- Parameters :
21 -- IN : CAMPAIGN_ID_Value IN NUMBER Required
22 -- campaign ID
23 -- Return : NUMBER
24 -- Returns total number of available records
25 ------------------------------------------------------------------------------
26 FUNCTION TOTAL_RECORD_FOR_AMS_CAMP(CAMPAIGN_ID_Value IN NUMBER) RETURN NUMBER;
27
28 END IEO_SUM_AVB_RECORD;