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