[Home] [Help]
PACKAGE: APPS.CN_SF_PARAMS_PKG
Source
1 PACKAGE CN_SF_PARAMS_pkg AUTHID CURRENT_USER AS
2 /*$Header: cntprmss.pls 115.2 2002/01/28 20:05:09 pkm ship $*/
3
4 PROCEDURE insert_row
5 (P_REPOSITORY_ID IN cn_sf_repositories.REPOSITORY_ID%TYPE,
6 P_CONTRACT_TITLE IN cn_sf_repositories.CONTRACT_TITLE%TYPE,
7 P_TERMS_AND_CONDITIONS IN cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE,
8 P_CLUB_QUAL_TEXT IN cn_sf_repositories.CLUB_QUAL_TEXT%TYPE,
9 P_APPROVER_NAME IN cn_sf_repositories.APPROVER_NAME%TYPE,
10 P_APPROVER_TITLE IN cn_sf_repositories.APPROVER_TITLE%TYPE,
11 P_APPROVER_ORG_NAME IN cn_sf_repositories.APPROVER_ORG_NAME%TYPE,
12 P_FILE_ID IN cn_sf_repositories.FILE_ID%TYPE,
13 P_FORMU_ACTIVATED_FLAG IN cn_sf_repositories.FORMU_ACTIVATED_FLAG%TYPE,
14 P_TRANSACTION_CALENDAR_ID IN cn_sf_repositories.TRANSACTION_CALENDAR_ID%TYPE,
15 p_attribute_category IN cn_sf_repositories.attribute_category%TYPE := NULL,
16 p_attribute1 IN cn_sf_repositories.attribute1%TYPE := NULL,
17 p_attribute2 IN cn_sf_repositories.attribute2%TYPE := NULL,
18 p_attribute3 IN cn_sf_repositories.attribute3%TYPE := NULL,
19 p_attribute4 IN cn_sf_repositories.attribute4%TYPE := NULL,
20 p_attribute5 IN cn_sf_repositories.attribute5%TYPE := NULL,
21 p_attribute6 IN cn_sf_repositories.attribute6%TYPE := NULL,
22 p_attribute7 IN cn_sf_repositories.attribute7%TYPE := NULL,
23 p_attribute8 IN cn_sf_repositories.attribute8%TYPE := NULL,
24 p_attribute9 IN cn_sf_repositories.attribute9%TYPE := NULL,
25 p_attribute10 IN cn_sf_repositories.attribute10%TYPE := NULL,
26 p_attribute11 IN cn_sf_repositories.attribute11%TYPE := NULL,
27 p_attribute12 IN cn_sf_repositories.attribute12%TYPE := NULL,
28 p_attribute13 IN cn_sf_repositories.attribute13%TYPE := NULL,
29 p_attribute14 IN cn_sf_repositories.attribute14%TYPE := NULL,
30 p_attribute15 IN cn_sf_repositories.attribute15%TYPE := NULL,
31 p_created_by IN cn_sf_repositories.created_by%TYPE := NULL,
32 p_creation_date IN cn_sf_repositories.creation_date%TYPE := NULL,
33 p_last_update_login IN cn_sf_repositories.last_update_login%TYPE := NULL,
34 p_last_update_date IN cn_sf_repositories.last_update_date%TYPE := NULL,
35 p_last_updated_by IN cn_sf_repositories.last_updated_by%TYPE := NULL,
36 p_OBJECT_VERSION_NUMBER IN cn_sf_repositories.OBJECT_VERSION_NUMBER%TYPE := NULL);
37
38 PROCEDURE update_row
39 (P_REPOSITORY_ID IN cn_sf_repositories.REPOSITORY_ID%TYPE,
40 P_CONTRACT_TITLE IN cn_sf_repositories.CONTRACT_TITLE%TYPE,
41 P_TERMS_AND_CONDITIONS IN cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE,
42 P_CLUB_QUAL_TEXT IN cn_sf_repositories.CLUB_QUAL_TEXT%TYPE,
43 P_APPROVER_NAME IN cn_sf_repositories.APPROVER_NAME%TYPE,
44 P_APPROVER_TITLE IN cn_sf_repositories.APPROVER_TITLE%TYPE,
45 P_APPROVER_ORG_NAME IN cn_sf_repositories.APPROVER_ORG_NAME%TYPE,
46 P_FILE_ID IN cn_sf_repositories.FILE_ID%TYPE,
47 P_FORMU_ACTIVATED_FLAG IN cn_sf_repositories.FORMU_ACTIVATED_FLAG%TYPE,
48 P_TRANSACTION_CALENDAR_ID IN cn_sf_repositories.TRANSACTION_CALENDAR_ID%TYPE,
49 p_attribute_category IN cn_sf_repositories.attribute_category%TYPE := NULL,
50 p_attribute1 IN cn_sf_repositories.attribute1%TYPE := NULL,
51 p_attribute2 IN cn_sf_repositories.attribute2%TYPE := NULL,
52 p_attribute3 IN cn_sf_repositories.attribute3%TYPE := NULL,
53 p_attribute4 IN cn_sf_repositories.attribute4%TYPE := NULL,
54 p_attribute5 IN cn_sf_repositories.attribute5%TYPE := NULL,
55 p_attribute6 IN cn_sf_repositories.attribute6%TYPE := NULL,
56 p_attribute7 IN cn_sf_repositories.attribute7%TYPE := NULL,
57 p_attribute8 IN cn_sf_repositories.attribute8%TYPE := NULL,
58 p_attribute9 IN cn_sf_repositories.attribute9%TYPE := NULL,
59 p_attribute10 IN cn_sf_repositories.attribute10%TYPE := NULL,
60 p_attribute11 IN cn_sf_repositories.attribute11%TYPE := NULL,
61 p_attribute12 IN cn_sf_repositories.attribute12%TYPE := NULL,
62 p_attribute13 IN cn_sf_repositories.attribute13%TYPE := NULL,
63 p_attribute14 IN cn_sf_repositories.attribute14%TYPE := NULL,
64 p_attribute15 IN cn_sf_repositories.attribute15%TYPE := NULL,
65 p_created_by IN cn_sf_repositories.created_by%TYPE := NULL,
66 p_creation_date IN cn_sf_repositories.creation_date%TYPE := NULL,
67 p_last_update_login IN cn_sf_repositories.last_update_login%TYPE := NULL,
68 p_last_update_date IN cn_sf_repositories.last_update_date%TYPE := NULL,
69 p_last_updated_by IN cn_sf_repositories.last_updated_by%TYPE := NULL,
70 p_OBJECT_VERSION_NUMBER IN cn_sf_repositories.OBJECT_VERSION_NUMBER%TYPE := NULL);
71
72 PROCEDURE delete_row
73 (P_REPOSITORY_ID IN cn_sf_repositories.REPOSITORY_ID%TYPE);
74
75 END CN_SF_PARAMS_pkg;