eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEO_I_CP_STOP_LIST dependencies on IEO_CP_STOP_LIST

Line 9: p_StopListKey IN IEO_CP_STOP_LIST.CP_STOP_LIST_KEY%TYPE,

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,

Line 10: p_TelNumber IN IEO_CP_STOP_LIST.TELEPHONE_NUMBER%TYPE DEFAULT null,

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,

Line 11: p_CustId IN IEO_CP_STOP_LIST.CUSTOMER_ID%TYPE DEFAULT null,

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,

Line 12: p_TimeZone IN IEO_CP_STOP_LIST.TIME_ZONE%TYPE DEFAULT null,

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,

Line 13: p_ExpireDate IN IEO_CP_STOP_LIST.STOP_EXPIRES_DATE%TYPE DEFAULT null,

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,

Line 14: p_Campaign IN IEO_CP_STOP_LIST.CAMPAIGN%TYPE DEFAULT null,

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,

Line 15: p_StopListCode IN IEO_CP_STOP_LIST.STOP_LIST_CODE%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,

Line 16: p_CreateBy IN IEO_CP_STOP_LIST.CREATED_BY%TYPE,

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)

Line 17: p_CreateDate IN IEO_CP_STOP_LIST.CREATION_DATE%TYPE DEFAULT sysdate,

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

Line 18: p_LastUpdateBy IN IEO_CP_STOP_LIST.LAST_UPDATED_BY%TYPE,

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

Line 19: p_LastUpdateDate IN IEO_CP_STOP_LIST.LAST_UPDATE_DATE%TYPE DEFAULT sysdate,

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

Line 20: p_LastUpdateLogin IN IEO_CP_STOP_LIST.LAST_UPDATE_LOGIN%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,

Line 24: INSERT INTO IEO_CP_STOP_LIST(CP_STOP_LIST_KEY,TELEPHONE_NUMBER,CUSTOMER_ID,TIME_ZONE,STOP_EXPIRES_DATE,

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);