DBA Data[Home] [Help]

PACKAGE: APPS.IEO_SUM_AVB_RECORD

Source


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;