[Home] [Help]
PACKAGE: APPS.HZ_CUST_CONTACT_POINTS_PKG
Source
1 PACKAGE HZ_CUST_CONTACT_POINTS_PKG AUTHID CURRENT_USER as
2 /*$Header: ARHCCPTS.pls 115.3 2002/11/21 18:55:07 sponnamb ship $ */
3
4
5
6 PROCEDURE Insert_Row(
7 x_Rowid IN OUT NOCOPY VARCHAR2,
8 x_CUST_CONTACT_POINT_ID NUMBER,
9 x_CUST_ACCOUNT_ID NUMBER,
10 x_CUST_ACCOUNT_SITE_ID NUMBER,
11 x_CUST_ACCOUNT_ROLE_ID NUMBER,
12 x_CONTACT_POINT_ID NUMBER,
13 x_LAST_UPDATED_BY NUMBER,
14 x_LAST_UPDATE_DATE DATE,
15 x_CREATED_BY NUMBER,
16 x_CREATION_DATE DATE,
17 x_LAST_UPDATE_LOGIN NUMBER,
18 x_STATUS VARCHAR2,
19 x_REQUEST_ID NUMBER,
20 x_PROGRAM_APPLICATION_ID NUMBER,
21 x_PROGRAM_ID NUMBER,
22 x_PROGRAM_UPDATE_DATE DATE);
23
24
25
26 PROCEDURE Lock_Row(
27 x_Rowid VARCHAR2,
28 x_CUST_CONTACT_POINT_ID NUMBER,
29 x_CUST_ACCOUNT_ID NUMBER,
30 x_CUST_ACCOUNT_SITE_ID NUMBER,
31 x_CUST_ACCOUNT_ROLE_ID NUMBER,
32 x_CONTACT_POINT_ID NUMBER,
33 x_LAST_UPDATED_BY NUMBER,
34 x_LAST_UPDATE_DATE DATE,
35 x_CREATED_BY NUMBER,
36 x_CREATION_DATE DATE,
37 x_LAST_UPDATE_LOGIN NUMBER,
38 x_STATUS VARCHAR2,
39 x_REQUEST_ID NUMBER,
40 x_PROGRAM_APPLICATION_ID NUMBER,
41 x_PROGRAM_ID NUMBER,
42 x_PROGRAM_UPDATE_DATE DATE);
43
44
45
46 PROCEDURE Update_Row(
47 x_Rowid VARCHAR2,
48 x_CUST_CONTACT_POINT_ID NUMBER,
49 x_CUST_ACCOUNT_ID NUMBER,
50 x_CUST_ACCOUNT_SITE_ID NUMBER,
51 x_CUST_ACCOUNT_ROLE_ID NUMBER,
52 x_CONTACT_POINT_ID NUMBER,
53 x_LAST_UPDATED_BY NUMBER,
54 x_LAST_UPDATE_DATE DATE,
55 x_CREATED_BY NUMBER,
56 x_CREATION_DATE DATE,
57 x_LAST_UPDATE_LOGIN NUMBER,
58 x_STATUS VARCHAR2,
59 x_REQUEST_ID NUMBER,
60 x_PROGRAM_APPLICATION_ID NUMBER,
61 x_PROGRAM_ID NUMBER,
62 x_PROGRAM_UPDATE_DATE DATE);
63
64
65
66 PROCEDURE Delete_Row( x_CUST_CONTACT_POINT_ID NUMBER);
67
68 END HZ_CUST_CONTACT_POINTS_PKG;