DBA Data[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;