PACKAGE BODY: APPS.IEO_I_CP_STOP_LIST

Source

1 PACKAGE BODY IEO_I_CP_STOP_LIST AS
2 /* $Header: IEOISTPB.pls 120.0 2005/06/02 10:45:29 appldev noship $ */
3 
4 ------------------------------------------------------------------------------
5 --  Procedure   : STOP_LIST_INSERT
6 ------------------------------------------------------------------------------
7 
8 PROCEDURE STOP_LIST_INSERT(
9 	p_StopListKey	IN  IEO_CP_STOP_LIST.CP_STOP_LIST_KEY%TYPE,
10 	p_TelNumber	IN  IEO_CP_STOP_LIST.TELEPHONE_NUMBER%TYPE DEFAULT null,
11 	p_CustId	IN  IEO_CP_STOP_LIST.CUSTOMER_ID%TYPE DEFAULT null,
12 	p_TimeZone	IN  IEO_CP_STOP_LIST.TIME_ZONE%TYPE DEFAULT null,
13 	p_ExpireDate	IN  IEO_CP_STOP_LIST.STOP_EXPIRES_DATE%TYPE DEFAULT null,
14 	p_Campaign	IN  IEO_CP_STOP_LIST.CAMPAIGN%TYPE DEFAULT null,
15 	p_StopListCode	IN  IEO_CP_STOP_LIST.STOP_LIST_CODE%TYPE DEFAULT null,
16 	p_CreateBy	IN  IEO_CP_STOP_LIST.CREATED_BY%TYPE,
17 	p_CreateDate	IN  IEO_CP_STOP_LIST.CREATION_DATE%TYPE DEFAULT sysdate,
18 	p_LastUpdateBy	IN  IEO_CP_STOP_LIST.LAST_UPDATED_BY%TYPE,
19 	p_LastUpdateDate IN  IEO_CP_STOP_LIST.LAST_UPDATE_DATE%TYPE DEFAULT sysdate,
20 	p_LastUpdateLogin IN IEO_CP_STOP_LIST.LAST_UPDATE_LOGIN%TYPE DEFAULT null)
21 	AS
22 BEGIN
23 	-- insert a new row in table
24 	INSERT INTO IEO_CP_STOP_LIST(CP_STOP_LIST_KEY,TELEPHONE_NUMBER,CUSTOMER_ID,TIME_ZONE,STOP_EXPIRES_DATE,
25 	CAMPAIGN,STOP_LIST_CODE,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,
26 	LAST_UPDATE_LOGIN) VALUES(p_StopListKey,p_TelNumber,p_CustId,p_TimeZone,
27 	p_ExpireDate,p_Campaign,p_StopListCode,p_CreateBy,p_CreateDate,p_LastUpdateBy,
28 	p_LastUpdateDate,p_LastUpdateLogin);
29 
30 END STOP_LIST_INSERT;
31 END IEO_I_CP_STOP_LIST;