1 PACKAGE IEO_I_CP_STOP_LIST AUTHID CURRENT_USER AS
2 /* $Header: IEOISTPS.pls 120.0 2005/06/02 10:30:42 appldev noship $ */
3
4 ------------------------------------------------------------------------------------
5 -- Procedure : STOP_LIST_INSERT
6 -- Description : insert date into table IEO_CP_STOP_LIST
7 -- Parameters :
8 -- IN : p_StopListKey IN IEO_CP_STOP_LIST.STOP_LIST_KEY%TYPE Required
9 -- Value of the STOP_LIST_KEY.
10 -- p_TelNumber IN IEO_CP_STOP_LIST.TELEPHONE_NUMBER%TYPE
11 -- Value of the TELEPHONE_NUMBER.
12 -- p_CustId IN IEO_CP_STOP_LIST.CUSTOMER_ID%TYPE
13 -- Value of the CUSTOMER_ID.
14 -- p_TimeZone IN IEO_CP_STOP_LIST.TIME_ZONE%TYPE
15 -- Value of the TIME_ZONE.
16 -- p_ExpireDate IN IEO_CP_STOP_LIST.STOP_EXPIRES_DATE%TYPE
17 -- Value of the STOP_EXPIRES_DATE.
18 -- p_Campaign IN IEO_CP_STOP_LIST.CAMPAIGN%TYPE
19 -- Value of the CAMPAIGN.
20 -- p_StopListCode IN IEO_CP_STOP_LIST.STOP_LIST_CODE%TYPE
21 -- Value of the STOP_LIST_CODE.
22 -- p_CreateBy IN IEO_CP_STOP_LIST.CREATED_BY%TYPE Required
23 -- Value of the CREATED_BY.
24 -- p_CreateDate IN IEO_CP_STOP_LIST.CREATION_DATE%TYPE
25 -- Value of the CREATION_DATE.
26 -- p_LastUpdateBy IN IEO_CP_STOP_LIST.LAST_UPDATED_BY%TYPE Required
27 -- Value of the LAST_UPDATED_BY.
28 -- p_LastUpdateDate IN IEO_CP_STOP_LIST.LAST_UPDATE_DATE%TYPE
29 -- Value of the LAST_UPDATE_DATE.
30 -- p_LastUpdateLogin IN IEO_CP_STOP_LIST.LAST_UPDATE_LOGIN%TYPE
31 -- Value of the LAST_UPDATE_LOGIN token.
32 -------------------------------------------------------------------------------------
33
34 PROCEDURE STOP_LIST_INSERT(
35 p_StopListKey IN IEO_CP_STOP_LIST.CP_STOP_LIST_KEY%TYPE,
36 p_TelNumber IN IEO_CP_STOP_LIST.TELEPHONE_NUMBER%TYPE DEFAULT null,
37 p_CustId IN IEO_CP_STOP_LIST.CUSTOMER_ID%TYPE DEFAULT null,
38 p_TimeZone IN IEO_CP_STOP_LIST.TIME_ZONE%TYPE DEFAULT null,
39 p_ExpireDate IN IEO_CP_STOP_LIST.STOP_EXPIRES_DATE%TYPE DEFAULT null,
40 p_Campaign IN IEO_CP_STOP_LIST.CAMPAIGN%TYPE DEFAULT null,
41 p_StopListCode IN IEO_CP_STOP_LIST.STOP_LIST_CODE%TYPE DEFAULT null,
42 p_CreateBy IN IEO_CP_STOP_LIST.CREATED_BY%TYPE,
43 p_CreateDate IN IEO_CP_STOP_LIST.CREATION_DATE%TYPE DEFAULT sysdate,
44 p_LastUpdateBy IN IEO_CP_STOP_LIST.LAST_UPDATED_BY%TYPE,
45 p_LastUpdateDate IN IEO_CP_STOP_LIST.LAST_UPDATE_DATE%TYPE DEFAULT sysdate,
46 p_LastUpdateLogin IN IEO_CP_STOP_LIST.LAST_UPDATE_LOGIN%TYPE DEFAULT null);
47
48 END IEO_I_CP_STOP_LIST;
[Home] [Help]