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 6: -- Description : insert date into table IEO_CP_STOP_LIST

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

Line 8: -- IN : p_StopListKey IN IEO_CP_STOP_LIST.STOP_LIST_KEY%TYPE Required

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

Line 10: -- p_TelNumber IN IEO_CP_STOP_LIST.TELEPHONE_NUMBER%TYPE

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

Line 12: -- p_CustId IN IEO_CP_STOP_LIST.CUSTOMER_ID%TYPE

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

Line 14: -- p_TimeZone IN IEO_CP_STOP_LIST.TIME_ZONE%TYPE

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

Line 16: -- p_ExpireDate IN IEO_CP_STOP_LIST.STOP_EXPIRES_DATE%TYPE

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

Line 18: -- p_Campaign IN IEO_CP_STOP_LIST.CAMPAIGN%TYPE

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

Line 20: -- p_StopListCode IN IEO_CP_STOP_LIST.STOP_LIST_CODE%TYPE

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

Line 22: -- p_CreateBy IN IEO_CP_STOP_LIST.CREATED_BY%TYPE Required

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

Line 24: -- p_CreateDate IN IEO_CP_STOP_LIST.CREATION_DATE%TYPE

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

Line 26: -- p_LastUpdateBy IN IEO_CP_STOP_LIST.LAST_UPDATED_BY%TYPE Required

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

Line 28: -- p_LastUpdateDate IN IEO_CP_STOP_LIST.LAST_UPDATE_DATE%TYPE

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: -------------------------------------------------------------------------------------

Line 30: -- p_LastUpdateLogin IN IEO_CP_STOP_LIST.LAST_UPDATE_LOGIN%TYPE

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(

Line 35: p_StopListKey IN IEO_CP_STOP_LIST.CP_STOP_LIST_KEY%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,

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

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,

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

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,

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

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,

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

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,

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

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,

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

Line 42: p_CreateBy IN IEO_CP_STOP_LIST.CREATED_BY%TYPE,

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

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

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:

Line 44: p_LastUpdateBy IN IEO_CP_STOP_LIST.LAST_UPDATED_BY%TYPE,

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;

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

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;

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