PACKAGE: APPS.HZ_SUSPENSION_ACTIVITY_PKG

Source

1 PACKAGE HZ_SUSPENSION_ACTIVITY_PKG as
2 /* $Header: ARHSATTS.pls 120.2 2005/10/30 03:54:57 appldev ship $*/
3 -- Start of Comments
4 -- Package name     : HZ_SUSPENSION_ACTIVITY_PKG
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 PROCEDURE Insert_Row(
11           p_SUSPENSION_ACTIVITY_ID   NUMBER,
12           p_ACTION_EFFECTIVE_ON_DATE    DATE,
13           p_ACTION_REASON    VARCHAR2,
14           p_ACTION_TYPE    VARCHAR2,
15           p_SITE_USE_ID    NUMBER,
16           p_CUST_ACCOUNT_ID    NUMBER,
17           p_NOTICE_METHOD    VARCHAR2,
18           p_NOTICE_RECEIVED_CONFIRMATION    VARCHAR2,
19           p_NOTICE_SENT_DATE    DATE,
20           p_NOTICE_TYPE    VARCHAR2,
21           p_BEGIN_DATE    DATE,
22           p_END_DATE    DATE,
23           p_CREATED_BY    NUMBER,
24           p_CREATION_DATE    DATE,
25           p_LAST_UPDATE_LOGIN    NUMBER,
26           p_LAST_UPDATE_DATE    DATE,
27           p_LAST_UPDATED_BY    NUMBER,
28           p_REQUEST_ID    NUMBER,
29           p_PROGRAM_APPLICATION_ID    NUMBER,
30           p_PROGRAM_ID    NUMBER,
31           p_PROGRAM_UPDATE_DATE    DATE,
32           p_WH_UPDATE_DATE    DATE);
33 
34 PROCEDURE Update_Row(
35           p_SUSPENSION_ACTIVITY_ID    NUMBER,
36           p_ACTION_EFFECTIVE_ON_DATE    DATE,
37           p_ACTION_REASON    VARCHAR2,
38           p_ACTION_TYPE    VARCHAR2,
39           p_SITE_USE_ID    NUMBER,
40           p_CUST_ACCOUNT_ID    NUMBER,
41           p_NOTICE_METHOD    VARCHAR2,
42           p_NOTICE_RECEIVED_CONFIRMATION    VARCHAR2,
43           p_NOTICE_SENT_DATE    DATE,
44           p_NOTICE_TYPE    VARCHAR2,
45           p_BEGIN_DATE    DATE,
46           p_END_DATE    DATE,
47           p_CREATED_BY    NUMBER,
48           p_CREATION_DATE    DATE,
49           p_LAST_UPDATE_LOGIN    NUMBER,
50           p_LAST_UPDATE_DATE    DATE,
51           p_LAST_UPDATED_BY    NUMBER,
52           p_REQUEST_ID    NUMBER,
53           p_PROGRAM_APPLICATION_ID    NUMBER,
54           p_PROGRAM_ID    NUMBER,
55           p_PROGRAM_UPDATE_DATE    DATE,
56           p_WH_UPDATE_DATE    DATE);
57 
58 PROCEDURE Lock_Row(
59           p_SUSPENSION_ACTIVITY_ID    NUMBER,
60           p_ACTION_EFFECTIVE_ON_DATE    DATE,
61           p_ACTION_REASON    VARCHAR2,
62           p_ACTION_TYPE    VARCHAR2,
63           p_SITE_USE_ID    NUMBER,
64           p_CUST_ACCOUNT_ID    NUMBER,
65           p_NOTICE_METHOD    VARCHAR2,
66           p_NOTICE_RECEIVED_CONFIRMATION    VARCHAR2,
67           p_NOTICE_SENT_DATE    DATE,
68           p_NOTICE_TYPE    VARCHAR2,
69           p_BEGIN_DATE    DATE,
70           p_END_DATE    DATE,
71           p_CREATED_BY    NUMBER,
72           p_CREATION_DATE    DATE,
73           p_LAST_UPDATE_LOGIN    NUMBER,
74           p_LAST_UPDATE_DATE    DATE,
75           p_LAST_UPDATED_BY    NUMBER,
76           p_REQUEST_ID    NUMBER,
77           p_PROGRAM_APPLICATION_ID    NUMBER,
78           p_PROGRAM_ID    NUMBER,
79           p_PROGRAM_UPDATE_DATE    DATE,
80           p_WH_UPDATE_DATE    DATE);
81 
82 PROCEDURE Delete_Row(
83     p_SUSPENSION_ACTIVITY_ID  NUMBER);
84 End HZ_SUSPENSION_ACTIVITY_PKG;