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