eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_SF_PARAMS_PKG dependencies on CN_SF_REPOSITORIES

Line 6: P_REPOSITORY_ID IN cn_sf_repositories.REPOSITORY_ID%TYPE,

2: /*$Header: cntprmsb.pls 115.2 2002/01/28 20:05:07 pkm ship $*/
3:
4: PROCEDURE insert_row
5: (
6: P_REPOSITORY_ID IN cn_sf_repositories.REPOSITORY_ID%TYPE,
7: P_CONTRACT_TITLE IN cn_sf_repositories.CONTRACT_TITLE%TYPE,
8: P_TERMS_AND_CONDITIONS IN cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE,
9: P_CLUB_QUAL_TEXT IN cn_sf_repositories.CLUB_QUAL_TEXT%TYPE,
10: P_APPROVER_NAME IN cn_sf_repositories.APPROVER_NAME%TYPE,

Line 7: P_CONTRACT_TITLE IN cn_sf_repositories.CONTRACT_TITLE%TYPE,

3:
4: PROCEDURE insert_row
5: (
6: P_REPOSITORY_ID IN cn_sf_repositories.REPOSITORY_ID%TYPE,
7: P_CONTRACT_TITLE IN cn_sf_repositories.CONTRACT_TITLE%TYPE,
8: P_TERMS_AND_CONDITIONS IN cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE,
9: P_CLUB_QUAL_TEXT IN cn_sf_repositories.CLUB_QUAL_TEXT%TYPE,
10: P_APPROVER_NAME IN cn_sf_repositories.APPROVER_NAME%TYPE,
11: P_APPROVER_TITLE IN cn_sf_repositories.APPROVER_TITLE%TYPE,

Line 8: P_TERMS_AND_CONDITIONS IN cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE,

4: PROCEDURE insert_row
5: (
6: P_REPOSITORY_ID IN cn_sf_repositories.REPOSITORY_ID%TYPE,
7: P_CONTRACT_TITLE IN cn_sf_repositories.CONTRACT_TITLE%TYPE,
8: P_TERMS_AND_CONDITIONS IN cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE,
9: P_CLUB_QUAL_TEXT IN cn_sf_repositories.CLUB_QUAL_TEXT%TYPE,
10: P_APPROVER_NAME IN cn_sf_repositories.APPROVER_NAME%TYPE,
11: P_APPROVER_TITLE IN cn_sf_repositories.APPROVER_TITLE%TYPE,
12: P_APPROVER_ORG_NAME IN cn_sf_repositories.APPROVER_ORG_NAME%TYPE,

Line 9: P_CLUB_QUAL_TEXT IN cn_sf_repositories.CLUB_QUAL_TEXT%TYPE,

5: (
6: P_REPOSITORY_ID IN cn_sf_repositories.REPOSITORY_ID%TYPE,
7: P_CONTRACT_TITLE IN cn_sf_repositories.CONTRACT_TITLE%TYPE,
8: P_TERMS_AND_CONDITIONS IN cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE,
9: P_CLUB_QUAL_TEXT IN cn_sf_repositories.CLUB_QUAL_TEXT%TYPE,
10: P_APPROVER_NAME IN cn_sf_repositories.APPROVER_NAME%TYPE,
11: P_APPROVER_TITLE IN cn_sf_repositories.APPROVER_TITLE%TYPE,
12: P_APPROVER_ORG_NAME IN cn_sf_repositories.APPROVER_ORG_NAME%TYPE,
13: P_FILE_ID IN cn_sf_repositories.FILE_ID%TYPE,

Line 10: P_APPROVER_NAME IN cn_sf_repositories.APPROVER_NAME%TYPE,

6: P_REPOSITORY_ID IN cn_sf_repositories.REPOSITORY_ID%TYPE,
7: P_CONTRACT_TITLE IN cn_sf_repositories.CONTRACT_TITLE%TYPE,
8: P_TERMS_AND_CONDITIONS IN cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE,
9: P_CLUB_QUAL_TEXT IN cn_sf_repositories.CLUB_QUAL_TEXT%TYPE,
10: P_APPROVER_NAME IN cn_sf_repositories.APPROVER_NAME%TYPE,
11: P_APPROVER_TITLE IN cn_sf_repositories.APPROVER_TITLE%TYPE,
12: P_APPROVER_ORG_NAME IN cn_sf_repositories.APPROVER_ORG_NAME%TYPE,
13: P_FILE_ID IN cn_sf_repositories.FILE_ID%TYPE,
14: P_FORMU_ACTIVATED_FLAG IN cn_sf_repositories.FORMU_ACTIVATED_FLAG%TYPE,

Line 11: P_APPROVER_TITLE IN cn_sf_repositories.APPROVER_TITLE%TYPE,

7: P_CONTRACT_TITLE IN cn_sf_repositories.CONTRACT_TITLE%TYPE,
8: P_TERMS_AND_CONDITIONS IN cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE,
9: P_CLUB_QUAL_TEXT IN cn_sf_repositories.CLUB_QUAL_TEXT%TYPE,
10: P_APPROVER_NAME IN cn_sf_repositories.APPROVER_NAME%TYPE,
11: P_APPROVER_TITLE IN cn_sf_repositories.APPROVER_TITLE%TYPE,
12: P_APPROVER_ORG_NAME IN cn_sf_repositories.APPROVER_ORG_NAME%TYPE,
13: P_FILE_ID IN cn_sf_repositories.FILE_ID%TYPE,
14: P_FORMU_ACTIVATED_FLAG IN cn_sf_repositories.FORMU_ACTIVATED_FLAG%TYPE,
15: P_TRANSACTION_CALENDAR_ID IN cn_sf_repositories.TRANSACTION_CALENDAR_ID%TYPE,

Line 12: P_APPROVER_ORG_NAME IN cn_sf_repositories.APPROVER_ORG_NAME%TYPE,

8: P_TERMS_AND_CONDITIONS IN cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE,
9: P_CLUB_QUAL_TEXT IN cn_sf_repositories.CLUB_QUAL_TEXT%TYPE,
10: P_APPROVER_NAME IN cn_sf_repositories.APPROVER_NAME%TYPE,
11: P_APPROVER_TITLE IN cn_sf_repositories.APPROVER_TITLE%TYPE,
12: P_APPROVER_ORG_NAME IN cn_sf_repositories.APPROVER_ORG_NAME%TYPE,
13: P_FILE_ID IN cn_sf_repositories.FILE_ID%TYPE,
14: P_FORMU_ACTIVATED_FLAG IN cn_sf_repositories.FORMU_ACTIVATED_FLAG%TYPE,
15: P_TRANSACTION_CALENDAR_ID IN cn_sf_repositories.TRANSACTION_CALENDAR_ID%TYPE,
16: p_attribute_category IN cn_sf_repositories.attribute_category%TYPE := NULL,

Line 13: P_FILE_ID IN cn_sf_repositories.FILE_ID%TYPE,

9: P_CLUB_QUAL_TEXT IN cn_sf_repositories.CLUB_QUAL_TEXT%TYPE,
10: P_APPROVER_NAME IN cn_sf_repositories.APPROVER_NAME%TYPE,
11: P_APPROVER_TITLE IN cn_sf_repositories.APPROVER_TITLE%TYPE,
12: P_APPROVER_ORG_NAME IN cn_sf_repositories.APPROVER_ORG_NAME%TYPE,
13: P_FILE_ID IN cn_sf_repositories.FILE_ID%TYPE,
14: P_FORMU_ACTIVATED_FLAG IN cn_sf_repositories.FORMU_ACTIVATED_FLAG%TYPE,
15: P_TRANSACTION_CALENDAR_ID IN cn_sf_repositories.TRANSACTION_CALENDAR_ID%TYPE,
16: p_attribute_category IN cn_sf_repositories.attribute_category%TYPE := NULL,
17: p_attribute1 IN cn_sf_repositories.attribute1%TYPE := NULL,

Line 14: P_FORMU_ACTIVATED_FLAG IN cn_sf_repositories.FORMU_ACTIVATED_FLAG%TYPE,

10: P_APPROVER_NAME IN cn_sf_repositories.APPROVER_NAME%TYPE,
11: P_APPROVER_TITLE IN cn_sf_repositories.APPROVER_TITLE%TYPE,
12: P_APPROVER_ORG_NAME IN cn_sf_repositories.APPROVER_ORG_NAME%TYPE,
13: P_FILE_ID IN cn_sf_repositories.FILE_ID%TYPE,
14: P_FORMU_ACTIVATED_FLAG IN cn_sf_repositories.FORMU_ACTIVATED_FLAG%TYPE,
15: P_TRANSACTION_CALENDAR_ID IN cn_sf_repositories.TRANSACTION_CALENDAR_ID%TYPE,
16: p_attribute_category IN cn_sf_repositories.attribute_category%TYPE := NULL,
17: p_attribute1 IN cn_sf_repositories.attribute1%TYPE := NULL,
18: p_attribute2 IN cn_sf_repositories.attribute2%TYPE := NULL,

Line 15: P_TRANSACTION_CALENDAR_ID IN cn_sf_repositories.TRANSACTION_CALENDAR_ID%TYPE,

11: P_APPROVER_TITLE IN cn_sf_repositories.APPROVER_TITLE%TYPE,
12: P_APPROVER_ORG_NAME IN cn_sf_repositories.APPROVER_ORG_NAME%TYPE,
13: P_FILE_ID IN cn_sf_repositories.FILE_ID%TYPE,
14: P_FORMU_ACTIVATED_FLAG IN cn_sf_repositories.FORMU_ACTIVATED_FLAG%TYPE,
15: P_TRANSACTION_CALENDAR_ID IN cn_sf_repositories.TRANSACTION_CALENDAR_ID%TYPE,
16: p_attribute_category IN cn_sf_repositories.attribute_category%TYPE := NULL,
17: p_attribute1 IN cn_sf_repositories.attribute1%TYPE := NULL,
18: p_attribute2 IN cn_sf_repositories.attribute2%TYPE := NULL,
19: p_attribute3 IN cn_sf_repositories.attribute3%TYPE := NULL,

Line 16: p_attribute_category IN cn_sf_repositories.attribute_category%TYPE := NULL,

12: P_APPROVER_ORG_NAME IN cn_sf_repositories.APPROVER_ORG_NAME%TYPE,
13: P_FILE_ID IN cn_sf_repositories.FILE_ID%TYPE,
14: P_FORMU_ACTIVATED_FLAG IN cn_sf_repositories.FORMU_ACTIVATED_FLAG%TYPE,
15: P_TRANSACTION_CALENDAR_ID IN cn_sf_repositories.TRANSACTION_CALENDAR_ID%TYPE,
16: p_attribute_category IN cn_sf_repositories.attribute_category%TYPE := NULL,
17: p_attribute1 IN cn_sf_repositories.attribute1%TYPE := NULL,
18: p_attribute2 IN cn_sf_repositories.attribute2%TYPE := NULL,
19: p_attribute3 IN cn_sf_repositories.attribute3%TYPE := NULL,
20: p_attribute4 IN cn_sf_repositories.attribute4%TYPE := NULL,

Line 17: p_attribute1 IN cn_sf_repositories.attribute1%TYPE := NULL,

13: P_FILE_ID IN cn_sf_repositories.FILE_ID%TYPE,
14: P_FORMU_ACTIVATED_FLAG IN cn_sf_repositories.FORMU_ACTIVATED_FLAG%TYPE,
15: P_TRANSACTION_CALENDAR_ID IN cn_sf_repositories.TRANSACTION_CALENDAR_ID%TYPE,
16: p_attribute_category IN cn_sf_repositories.attribute_category%TYPE := NULL,
17: p_attribute1 IN cn_sf_repositories.attribute1%TYPE := NULL,
18: p_attribute2 IN cn_sf_repositories.attribute2%TYPE := NULL,
19: p_attribute3 IN cn_sf_repositories.attribute3%TYPE := NULL,
20: p_attribute4 IN cn_sf_repositories.attribute4%TYPE := NULL,
21: p_attribute5 IN cn_sf_repositories.attribute5%TYPE := NULL,

Line 18: p_attribute2 IN cn_sf_repositories.attribute2%TYPE := NULL,

14: P_FORMU_ACTIVATED_FLAG IN cn_sf_repositories.FORMU_ACTIVATED_FLAG%TYPE,
15: P_TRANSACTION_CALENDAR_ID IN cn_sf_repositories.TRANSACTION_CALENDAR_ID%TYPE,
16: p_attribute_category IN cn_sf_repositories.attribute_category%TYPE := NULL,
17: p_attribute1 IN cn_sf_repositories.attribute1%TYPE := NULL,
18: p_attribute2 IN cn_sf_repositories.attribute2%TYPE := NULL,
19: p_attribute3 IN cn_sf_repositories.attribute3%TYPE := NULL,
20: p_attribute4 IN cn_sf_repositories.attribute4%TYPE := NULL,
21: p_attribute5 IN cn_sf_repositories.attribute5%TYPE := NULL,
22: p_attribute6 IN cn_sf_repositories.attribute6%TYPE := NULL,

Line 19: p_attribute3 IN cn_sf_repositories.attribute3%TYPE := NULL,

15: P_TRANSACTION_CALENDAR_ID IN cn_sf_repositories.TRANSACTION_CALENDAR_ID%TYPE,
16: p_attribute_category IN cn_sf_repositories.attribute_category%TYPE := NULL,
17: p_attribute1 IN cn_sf_repositories.attribute1%TYPE := NULL,
18: p_attribute2 IN cn_sf_repositories.attribute2%TYPE := NULL,
19: p_attribute3 IN cn_sf_repositories.attribute3%TYPE := NULL,
20: p_attribute4 IN cn_sf_repositories.attribute4%TYPE := NULL,
21: p_attribute5 IN cn_sf_repositories.attribute5%TYPE := NULL,
22: p_attribute6 IN cn_sf_repositories.attribute6%TYPE := NULL,
23: p_attribute7 IN cn_sf_repositories.attribute7%TYPE := NULL,

Line 20: p_attribute4 IN cn_sf_repositories.attribute4%TYPE := NULL,

16: p_attribute_category IN cn_sf_repositories.attribute_category%TYPE := NULL,
17: p_attribute1 IN cn_sf_repositories.attribute1%TYPE := NULL,
18: p_attribute2 IN cn_sf_repositories.attribute2%TYPE := NULL,
19: p_attribute3 IN cn_sf_repositories.attribute3%TYPE := NULL,
20: p_attribute4 IN cn_sf_repositories.attribute4%TYPE := NULL,
21: p_attribute5 IN cn_sf_repositories.attribute5%TYPE := NULL,
22: p_attribute6 IN cn_sf_repositories.attribute6%TYPE := NULL,
23: p_attribute7 IN cn_sf_repositories.attribute7%TYPE := NULL,
24: p_attribute8 IN cn_sf_repositories.attribute8%TYPE := NULL,

Line 21: p_attribute5 IN cn_sf_repositories.attribute5%TYPE := NULL,

17: p_attribute1 IN cn_sf_repositories.attribute1%TYPE := NULL,
18: p_attribute2 IN cn_sf_repositories.attribute2%TYPE := NULL,
19: p_attribute3 IN cn_sf_repositories.attribute3%TYPE := NULL,
20: p_attribute4 IN cn_sf_repositories.attribute4%TYPE := NULL,
21: p_attribute5 IN cn_sf_repositories.attribute5%TYPE := NULL,
22: p_attribute6 IN cn_sf_repositories.attribute6%TYPE := NULL,
23: p_attribute7 IN cn_sf_repositories.attribute7%TYPE := NULL,
24: p_attribute8 IN cn_sf_repositories.attribute8%TYPE := NULL,
25: p_attribute9 IN cn_sf_repositories.attribute9%TYPE := NULL,

Line 22: p_attribute6 IN cn_sf_repositories.attribute6%TYPE := NULL,

18: p_attribute2 IN cn_sf_repositories.attribute2%TYPE := NULL,
19: p_attribute3 IN cn_sf_repositories.attribute3%TYPE := NULL,
20: p_attribute4 IN cn_sf_repositories.attribute4%TYPE := NULL,
21: p_attribute5 IN cn_sf_repositories.attribute5%TYPE := NULL,
22: p_attribute6 IN cn_sf_repositories.attribute6%TYPE := NULL,
23: p_attribute7 IN cn_sf_repositories.attribute7%TYPE := NULL,
24: p_attribute8 IN cn_sf_repositories.attribute8%TYPE := NULL,
25: p_attribute9 IN cn_sf_repositories.attribute9%TYPE := NULL,
26: p_attribute10 IN cn_sf_repositories.attribute10%TYPE := NULL,

Line 23: p_attribute7 IN cn_sf_repositories.attribute7%TYPE := NULL,

19: p_attribute3 IN cn_sf_repositories.attribute3%TYPE := NULL,
20: p_attribute4 IN cn_sf_repositories.attribute4%TYPE := NULL,
21: p_attribute5 IN cn_sf_repositories.attribute5%TYPE := NULL,
22: p_attribute6 IN cn_sf_repositories.attribute6%TYPE := NULL,
23: p_attribute7 IN cn_sf_repositories.attribute7%TYPE := NULL,
24: p_attribute8 IN cn_sf_repositories.attribute8%TYPE := NULL,
25: p_attribute9 IN cn_sf_repositories.attribute9%TYPE := NULL,
26: p_attribute10 IN cn_sf_repositories.attribute10%TYPE := NULL,
27: p_attribute11 IN cn_sf_repositories.attribute11%TYPE := NULL,

Line 24: p_attribute8 IN cn_sf_repositories.attribute8%TYPE := NULL,

20: p_attribute4 IN cn_sf_repositories.attribute4%TYPE := NULL,
21: p_attribute5 IN cn_sf_repositories.attribute5%TYPE := NULL,
22: p_attribute6 IN cn_sf_repositories.attribute6%TYPE := NULL,
23: p_attribute7 IN cn_sf_repositories.attribute7%TYPE := NULL,
24: p_attribute8 IN cn_sf_repositories.attribute8%TYPE := NULL,
25: p_attribute9 IN cn_sf_repositories.attribute9%TYPE := NULL,
26: p_attribute10 IN cn_sf_repositories.attribute10%TYPE := NULL,
27: p_attribute11 IN cn_sf_repositories.attribute11%TYPE := NULL,
28: p_attribute12 IN cn_sf_repositories.attribute12%TYPE := NULL,

Line 25: p_attribute9 IN cn_sf_repositories.attribute9%TYPE := NULL,

21: p_attribute5 IN cn_sf_repositories.attribute5%TYPE := NULL,
22: p_attribute6 IN cn_sf_repositories.attribute6%TYPE := NULL,
23: p_attribute7 IN cn_sf_repositories.attribute7%TYPE := NULL,
24: p_attribute8 IN cn_sf_repositories.attribute8%TYPE := NULL,
25: p_attribute9 IN cn_sf_repositories.attribute9%TYPE := NULL,
26: p_attribute10 IN cn_sf_repositories.attribute10%TYPE := NULL,
27: p_attribute11 IN cn_sf_repositories.attribute11%TYPE := NULL,
28: p_attribute12 IN cn_sf_repositories.attribute12%TYPE := NULL,
29: p_attribute13 IN cn_sf_repositories.attribute13%TYPE := NULL,

Line 26: p_attribute10 IN cn_sf_repositories.attribute10%TYPE := NULL,

22: p_attribute6 IN cn_sf_repositories.attribute6%TYPE := NULL,
23: p_attribute7 IN cn_sf_repositories.attribute7%TYPE := NULL,
24: p_attribute8 IN cn_sf_repositories.attribute8%TYPE := NULL,
25: p_attribute9 IN cn_sf_repositories.attribute9%TYPE := NULL,
26: p_attribute10 IN cn_sf_repositories.attribute10%TYPE := NULL,
27: p_attribute11 IN cn_sf_repositories.attribute11%TYPE := NULL,
28: p_attribute12 IN cn_sf_repositories.attribute12%TYPE := NULL,
29: p_attribute13 IN cn_sf_repositories.attribute13%TYPE := NULL,
30: p_attribute14 IN cn_sf_repositories.attribute14%TYPE := NULL,

Line 27: p_attribute11 IN cn_sf_repositories.attribute11%TYPE := NULL,

23: p_attribute7 IN cn_sf_repositories.attribute7%TYPE := NULL,
24: p_attribute8 IN cn_sf_repositories.attribute8%TYPE := NULL,
25: p_attribute9 IN cn_sf_repositories.attribute9%TYPE := NULL,
26: p_attribute10 IN cn_sf_repositories.attribute10%TYPE := NULL,
27: p_attribute11 IN cn_sf_repositories.attribute11%TYPE := NULL,
28: p_attribute12 IN cn_sf_repositories.attribute12%TYPE := NULL,
29: p_attribute13 IN cn_sf_repositories.attribute13%TYPE := NULL,
30: p_attribute14 IN cn_sf_repositories.attribute14%TYPE := NULL,
31: p_attribute15 IN cn_sf_repositories.attribute15%TYPE := NULL,

Line 28: p_attribute12 IN cn_sf_repositories.attribute12%TYPE := NULL,

24: p_attribute8 IN cn_sf_repositories.attribute8%TYPE := NULL,
25: p_attribute9 IN cn_sf_repositories.attribute9%TYPE := NULL,
26: p_attribute10 IN cn_sf_repositories.attribute10%TYPE := NULL,
27: p_attribute11 IN cn_sf_repositories.attribute11%TYPE := NULL,
28: p_attribute12 IN cn_sf_repositories.attribute12%TYPE := NULL,
29: p_attribute13 IN cn_sf_repositories.attribute13%TYPE := NULL,
30: p_attribute14 IN cn_sf_repositories.attribute14%TYPE := NULL,
31: p_attribute15 IN cn_sf_repositories.attribute15%TYPE := NULL,
32: p_created_by IN cn_sf_repositories.created_by%TYPE := NULL,

Line 29: p_attribute13 IN cn_sf_repositories.attribute13%TYPE := NULL,

25: p_attribute9 IN cn_sf_repositories.attribute9%TYPE := NULL,
26: p_attribute10 IN cn_sf_repositories.attribute10%TYPE := NULL,
27: p_attribute11 IN cn_sf_repositories.attribute11%TYPE := NULL,
28: p_attribute12 IN cn_sf_repositories.attribute12%TYPE := NULL,
29: p_attribute13 IN cn_sf_repositories.attribute13%TYPE := NULL,
30: p_attribute14 IN cn_sf_repositories.attribute14%TYPE := NULL,
31: p_attribute15 IN cn_sf_repositories.attribute15%TYPE := NULL,
32: p_created_by IN cn_sf_repositories.created_by%TYPE := NULL,
33: p_creation_date IN cn_sf_repositories.creation_date%TYPE := NULL,

Line 30: p_attribute14 IN cn_sf_repositories.attribute14%TYPE := NULL,

26: p_attribute10 IN cn_sf_repositories.attribute10%TYPE := NULL,
27: p_attribute11 IN cn_sf_repositories.attribute11%TYPE := NULL,
28: p_attribute12 IN cn_sf_repositories.attribute12%TYPE := NULL,
29: p_attribute13 IN cn_sf_repositories.attribute13%TYPE := NULL,
30: p_attribute14 IN cn_sf_repositories.attribute14%TYPE := NULL,
31: p_attribute15 IN cn_sf_repositories.attribute15%TYPE := NULL,
32: p_created_by IN cn_sf_repositories.created_by%TYPE := NULL,
33: p_creation_date IN cn_sf_repositories.creation_date%TYPE := NULL,
34: p_last_update_login IN cn_sf_repositories.last_update_login%TYPE := NULL,

Line 31: p_attribute15 IN cn_sf_repositories.attribute15%TYPE := NULL,

27: p_attribute11 IN cn_sf_repositories.attribute11%TYPE := NULL,
28: p_attribute12 IN cn_sf_repositories.attribute12%TYPE := NULL,
29: p_attribute13 IN cn_sf_repositories.attribute13%TYPE := NULL,
30: p_attribute14 IN cn_sf_repositories.attribute14%TYPE := NULL,
31: p_attribute15 IN cn_sf_repositories.attribute15%TYPE := NULL,
32: p_created_by IN cn_sf_repositories.created_by%TYPE := NULL,
33: p_creation_date IN cn_sf_repositories.creation_date%TYPE := NULL,
34: p_last_update_login IN cn_sf_repositories.last_update_login%TYPE := NULL,
35: p_last_update_date IN cn_sf_repositories.last_update_date%TYPE := NULL,

Line 32: p_created_by IN cn_sf_repositories.created_by%TYPE := NULL,

28: p_attribute12 IN cn_sf_repositories.attribute12%TYPE := NULL,
29: p_attribute13 IN cn_sf_repositories.attribute13%TYPE := NULL,
30: p_attribute14 IN cn_sf_repositories.attribute14%TYPE := NULL,
31: p_attribute15 IN cn_sf_repositories.attribute15%TYPE := NULL,
32: p_created_by IN cn_sf_repositories.created_by%TYPE := NULL,
33: p_creation_date IN cn_sf_repositories.creation_date%TYPE := NULL,
34: p_last_update_login IN cn_sf_repositories.last_update_login%TYPE := NULL,
35: p_last_update_date IN cn_sf_repositories.last_update_date%TYPE := NULL,
36: p_last_updated_by IN cn_sf_repositories.last_updated_by%TYPE := NULL,

Line 33: p_creation_date IN cn_sf_repositories.creation_date%TYPE := NULL,

29: p_attribute13 IN cn_sf_repositories.attribute13%TYPE := NULL,
30: p_attribute14 IN cn_sf_repositories.attribute14%TYPE := NULL,
31: p_attribute15 IN cn_sf_repositories.attribute15%TYPE := NULL,
32: p_created_by IN cn_sf_repositories.created_by%TYPE := NULL,
33: p_creation_date IN cn_sf_repositories.creation_date%TYPE := NULL,
34: p_last_update_login IN cn_sf_repositories.last_update_login%TYPE := NULL,
35: p_last_update_date IN cn_sf_repositories.last_update_date%TYPE := NULL,
36: p_last_updated_by IN cn_sf_repositories.last_updated_by%TYPE := NULL,
37: p_OBJECT_VERSION_NUMBER IN cn_sf_repositories.OBJECT_VERSION_NUMBER%TYPE := NULL)

Line 34: p_last_update_login IN cn_sf_repositories.last_update_login%TYPE := NULL,

30: p_attribute14 IN cn_sf_repositories.attribute14%TYPE := NULL,
31: p_attribute15 IN cn_sf_repositories.attribute15%TYPE := NULL,
32: p_created_by IN cn_sf_repositories.created_by%TYPE := NULL,
33: p_creation_date IN cn_sf_repositories.creation_date%TYPE := NULL,
34: p_last_update_login IN cn_sf_repositories.last_update_login%TYPE := NULL,
35: p_last_update_date IN cn_sf_repositories.last_update_date%TYPE := NULL,
36: p_last_updated_by IN cn_sf_repositories.last_updated_by%TYPE := NULL,
37: p_OBJECT_VERSION_NUMBER IN cn_sf_repositories.OBJECT_VERSION_NUMBER%TYPE := NULL)
38: IS

Line 35: p_last_update_date IN cn_sf_repositories.last_update_date%TYPE := NULL,

31: p_attribute15 IN cn_sf_repositories.attribute15%TYPE := NULL,
32: p_created_by IN cn_sf_repositories.created_by%TYPE := NULL,
33: p_creation_date IN cn_sf_repositories.creation_date%TYPE := NULL,
34: p_last_update_login IN cn_sf_repositories.last_update_login%TYPE := NULL,
35: p_last_update_date IN cn_sf_repositories.last_update_date%TYPE := NULL,
36: p_last_updated_by IN cn_sf_repositories.last_updated_by%TYPE := NULL,
37: p_OBJECT_VERSION_NUMBER IN cn_sf_repositories.OBJECT_VERSION_NUMBER%TYPE := NULL)
38: IS
39: MN NUMBER := FND_API.G_MISS_NUM;

Line 36: p_last_updated_by IN cn_sf_repositories.last_updated_by%TYPE := NULL,

32: p_created_by IN cn_sf_repositories.created_by%TYPE := NULL,
33: p_creation_date IN cn_sf_repositories.creation_date%TYPE := NULL,
34: p_last_update_login IN cn_sf_repositories.last_update_login%TYPE := NULL,
35: p_last_update_date IN cn_sf_repositories.last_update_date%TYPE := NULL,
36: p_last_updated_by IN cn_sf_repositories.last_updated_by%TYPE := NULL,
37: p_OBJECT_VERSION_NUMBER IN cn_sf_repositories.OBJECT_VERSION_NUMBER%TYPE := NULL)
38: IS
39: MN NUMBER := FND_API.G_MISS_NUM;
40: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;

Line 37: p_OBJECT_VERSION_NUMBER IN cn_sf_repositories.OBJECT_VERSION_NUMBER%TYPE := NULL)

33: p_creation_date IN cn_sf_repositories.creation_date%TYPE := NULL,
34: p_last_update_login IN cn_sf_repositories.last_update_login%TYPE := NULL,
35: p_last_update_date IN cn_sf_repositories.last_update_date%TYPE := NULL,
36: p_last_updated_by IN cn_sf_repositories.last_updated_by%TYPE := NULL,
37: p_OBJECT_VERSION_NUMBER IN cn_sf_repositories.OBJECT_VERSION_NUMBER%TYPE := NULL)
38: IS
39: MN NUMBER := FND_API.G_MISS_NUM;
40: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
41: MD DATE := FND_API.G_MISS_DATE;

Line 47: INSERT INTO cn_sf_repositories (

43: BEGIN
44:
45: --DBMS_OUTPUT.PUT_LINE('Begin : I have just ran the insert_row.');
46:
47: INSERT INTO cn_sf_repositories (
48: REPOSITORY_ID,
49: CONTRACT_TITLE,
50: TERMS_AND_CONDITIONS,
51: CLUB_QUAL_TEXT,

Line 82: cn_sf_repositories_s.nextval,

78: LAST_UPDATED_BY,
79: object_version_number
80: )
81: SELECT
82: cn_sf_repositories_s.nextval,
83: P_CONTRACT_TITLE,
84: P_TERMS_AND_CONDITIONS,
85: P_CLUB_QUAL_TEXT,
86: P_APPROVER_NAME ,

Line 122: P_REPOSITORY_ID IN cn_sf_repositories.REPOSITORY_ID%TYPE,

118:
119:
120: PROCEDURE update_row
121: (
122: P_REPOSITORY_ID IN cn_sf_repositories.REPOSITORY_ID%TYPE,
123: P_CONTRACT_TITLE IN cn_sf_repositories.CONTRACT_TITLE%TYPE,
124: P_TERMS_AND_CONDITIONS IN cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE,
125: P_CLUB_QUAL_TEXT IN cn_sf_repositories.CLUB_QUAL_TEXT%TYPE,
126: P_APPROVER_NAME IN cn_sf_repositories.APPROVER_NAME%TYPE,

Line 123: P_CONTRACT_TITLE IN cn_sf_repositories.CONTRACT_TITLE%TYPE,

119:
120: PROCEDURE update_row
121: (
122: P_REPOSITORY_ID IN cn_sf_repositories.REPOSITORY_ID%TYPE,
123: P_CONTRACT_TITLE IN cn_sf_repositories.CONTRACT_TITLE%TYPE,
124: P_TERMS_AND_CONDITIONS IN cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE,
125: P_CLUB_QUAL_TEXT IN cn_sf_repositories.CLUB_QUAL_TEXT%TYPE,
126: P_APPROVER_NAME IN cn_sf_repositories.APPROVER_NAME%TYPE,
127: P_APPROVER_TITLE IN cn_sf_repositories.APPROVER_TITLE%TYPE,

Line 124: P_TERMS_AND_CONDITIONS IN cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE,

120: PROCEDURE update_row
121: (
122: P_REPOSITORY_ID IN cn_sf_repositories.REPOSITORY_ID%TYPE,
123: P_CONTRACT_TITLE IN cn_sf_repositories.CONTRACT_TITLE%TYPE,
124: P_TERMS_AND_CONDITIONS IN cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE,
125: P_CLUB_QUAL_TEXT IN cn_sf_repositories.CLUB_QUAL_TEXT%TYPE,
126: P_APPROVER_NAME IN cn_sf_repositories.APPROVER_NAME%TYPE,
127: P_APPROVER_TITLE IN cn_sf_repositories.APPROVER_TITLE%TYPE,
128: P_APPROVER_ORG_NAME IN cn_sf_repositories.APPROVER_ORG_NAME%TYPE,

Line 125: P_CLUB_QUAL_TEXT IN cn_sf_repositories.CLUB_QUAL_TEXT%TYPE,

121: (
122: P_REPOSITORY_ID IN cn_sf_repositories.REPOSITORY_ID%TYPE,
123: P_CONTRACT_TITLE IN cn_sf_repositories.CONTRACT_TITLE%TYPE,
124: P_TERMS_AND_CONDITIONS IN cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE,
125: P_CLUB_QUAL_TEXT IN cn_sf_repositories.CLUB_QUAL_TEXT%TYPE,
126: P_APPROVER_NAME IN cn_sf_repositories.APPROVER_NAME%TYPE,
127: P_APPROVER_TITLE IN cn_sf_repositories.APPROVER_TITLE%TYPE,
128: P_APPROVER_ORG_NAME IN cn_sf_repositories.APPROVER_ORG_NAME%TYPE,
129: P_FILE_ID IN cn_sf_repositories.FILE_ID%TYPE,

Line 126: P_APPROVER_NAME IN cn_sf_repositories.APPROVER_NAME%TYPE,

122: P_REPOSITORY_ID IN cn_sf_repositories.REPOSITORY_ID%TYPE,
123: P_CONTRACT_TITLE IN cn_sf_repositories.CONTRACT_TITLE%TYPE,
124: P_TERMS_AND_CONDITIONS IN cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE,
125: P_CLUB_QUAL_TEXT IN cn_sf_repositories.CLUB_QUAL_TEXT%TYPE,
126: P_APPROVER_NAME IN cn_sf_repositories.APPROVER_NAME%TYPE,
127: P_APPROVER_TITLE IN cn_sf_repositories.APPROVER_TITLE%TYPE,
128: P_APPROVER_ORG_NAME IN cn_sf_repositories.APPROVER_ORG_NAME%TYPE,
129: P_FILE_ID IN cn_sf_repositories.FILE_ID%TYPE,
130: P_FORMU_ACTIVATED_FLAG IN cn_sf_repositories.FORMU_ACTIVATED_FLAG%TYPE,

Line 127: P_APPROVER_TITLE IN cn_sf_repositories.APPROVER_TITLE%TYPE,

123: P_CONTRACT_TITLE IN cn_sf_repositories.CONTRACT_TITLE%TYPE,
124: P_TERMS_AND_CONDITIONS IN cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE,
125: P_CLUB_QUAL_TEXT IN cn_sf_repositories.CLUB_QUAL_TEXT%TYPE,
126: P_APPROVER_NAME IN cn_sf_repositories.APPROVER_NAME%TYPE,
127: P_APPROVER_TITLE IN cn_sf_repositories.APPROVER_TITLE%TYPE,
128: P_APPROVER_ORG_NAME IN cn_sf_repositories.APPROVER_ORG_NAME%TYPE,
129: P_FILE_ID IN cn_sf_repositories.FILE_ID%TYPE,
130: P_FORMU_ACTIVATED_FLAG IN cn_sf_repositories.FORMU_ACTIVATED_FLAG%TYPE,
131: P_TRANSACTION_CALENDAR_ID IN cn_sf_repositories.TRANSACTION_CALENDAR_ID%TYPE,

Line 128: P_APPROVER_ORG_NAME IN cn_sf_repositories.APPROVER_ORG_NAME%TYPE,

124: P_TERMS_AND_CONDITIONS IN cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE,
125: P_CLUB_QUAL_TEXT IN cn_sf_repositories.CLUB_QUAL_TEXT%TYPE,
126: P_APPROVER_NAME IN cn_sf_repositories.APPROVER_NAME%TYPE,
127: P_APPROVER_TITLE IN cn_sf_repositories.APPROVER_TITLE%TYPE,
128: P_APPROVER_ORG_NAME IN cn_sf_repositories.APPROVER_ORG_NAME%TYPE,
129: P_FILE_ID IN cn_sf_repositories.FILE_ID%TYPE,
130: P_FORMU_ACTIVATED_FLAG IN cn_sf_repositories.FORMU_ACTIVATED_FLAG%TYPE,
131: P_TRANSACTION_CALENDAR_ID IN cn_sf_repositories.TRANSACTION_CALENDAR_ID%TYPE,
132: p_attribute_category IN cn_sf_repositories.attribute_category%TYPE := NULL,

Line 129: P_FILE_ID IN cn_sf_repositories.FILE_ID%TYPE,

125: P_CLUB_QUAL_TEXT IN cn_sf_repositories.CLUB_QUAL_TEXT%TYPE,
126: P_APPROVER_NAME IN cn_sf_repositories.APPROVER_NAME%TYPE,
127: P_APPROVER_TITLE IN cn_sf_repositories.APPROVER_TITLE%TYPE,
128: P_APPROVER_ORG_NAME IN cn_sf_repositories.APPROVER_ORG_NAME%TYPE,
129: P_FILE_ID IN cn_sf_repositories.FILE_ID%TYPE,
130: P_FORMU_ACTIVATED_FLAG IN cn_sf_repositories.FORMU_ACTIVATED_FLAG%TYPE,
131: P_TRANSACTION_CALENDAR_ID IN cn_sf_repositories.TRANSACTION_CALENDAR_ID%TYPE,
132: p_attribute_category IN cn_sf_repositories.attribute_category%TYPE := NULL,
133: p_attribute1 IN cn_sf_repositories.attribute1%TYPE := NULL,

Line 130: P_FORMU_ACTIVATED_FLAG IN cn_sf_repositories.FORMU_ACTIVATED_FLAG%TYPE,

126: P_APPROVER_NAME IN cn_sf_repositories.APPROVER_NAME%TYPE,
127: P_APPROVER_TITLE IN cn_sf_repositories.APPROVER_TITLE%TYPE,
128: P_APPROVER_ORG_NAME IN cn_sf_repositories.APPROVER_ORG_NAME%TYPE,
129: P_FILE_ID IN cn_sf_repositories.FILE_ID%TYPE,
130: P_FORMU_ACTIVATED_FLAG IN cn_sf_repositories.FORMU_ACTIVATED_FLAG%TYPE,
131: P_TRANSACTION_CALENDAR_ID IN cn_sf_repositories.TRANSACTION_CALENDAR_ID%TYPE,
132: p_attribute_category IN cn_sf_repositories.attribute_category%TYPE := NULL,
133: p_attribute1 IN cn_sf_repositories.attribute1%TYPE := NULL,
134: p_attribute2 IN cn_sf_repositories.attribute2%TYPE := NULL,

Line 131: P_TRANSACTION_CALENDAR_ID IN cn_sf_repositories.TRANSACTION_CALENDAR_ID%TYPE,

127: P_APPROVER_TITLE IN cn_sf_repositories.APPROVER_TITLE%TYPE,
128: P_APPROVER_ORG_NAME IN cn_sf_repositories.APPROVER_ORG_NAME%TYPE,
129: P_FILE_ID IN cn_sf_repositories.FILE_ID%TYPE,
130: P_FORMU_ACTIVATED_FLAG IN cn_sf_repositories.FORMU_ACTIVATED_FLAG%TYPE,
131: P_TRANSACTION_CALENDAR_ID IN cn_sf_repositories.TRANSACTION_CALENDAR_ID%TYPE,
132: p_attribute_category IN cn_sf_repositories.attribute_category%TYPE := NULL,
133: p_attribute1 IN cn_sf_repositories.attribute1%TYPE := NULL,
134: p_attribute2 IN cn_sf_repositories.attribute2%TYPE := NULL,
135: p_attribute3 IN cn_sf_repositories.attribute3%TYPE := NULL,

Line 132: p_attribute_category IN cn_sf_repositories.attribute_category%TYPE := NULL,

128: P_APPROVER_ORG_NAME IN cn_sf_repositories.APPROVER_ORG_NAME%TYPE,
129: P_FILE_ID IN cn_sf_repositories.FILE_ID%TYPE,
130: P_FORMU_ACTIVATED_FLAG IN cn_sf_repositories.FORMU_ACTIVATED_FLAG%TYPE,
131: P_TRANSACTION_CALENDAR_ID IN cn_sf_repositories.TRANSACTION_CALENDAR_ID%TYPE,
132: p_attribute_category IN cn_sf_repositories.attribute_category%TYPE := NULL,
133: p_attribute1 IN cn_sf_repositories.attribute1%TYPE := NULL,
134: p_attribute2 IN cn_sf_repositories.attribute2%TYPE := NULL,
135: p_attribute3 IN cn_sf_repositories.attribute3%TYPE := NULL,
136: p_attribute4 IN cn_sf_repositories.attribute4%TYPE := NULL,

Line 133: p_attribute1 IN cn_sf_repositories.attribute1%TYPE := NULL,

129: P_FILE_ID IN cn_sf_repositories.FILE_ID%TYPE,
130: P_FORMU_ACTIVATED_FLAG IN cn_sf_repositories.FORMU_ACTIVATED_FLAG%TYPE,
131: P_TRANSACTION_CALENDAR_ID IN cn_sf_repositories.TRANSACTION_CALENDAR_ID%TYPE,
132: p_attribute_category IN cn_sf_repositories.attribute_category%TYPE := NULL,
133: p_attribute1 IN cn_sf_repositories.attribute1%TYPE := NULL,
134: p_attribute2 IN cn_sf_repositories.attribute2%TYPE := NULL,
135: p_attribute3 IN cn_sf_repositories.attribute3%TYPE := NULL,
136: p_attribute4 IN cn_sf_repositories.attribute4%TYPE := NULL,
137: p_attribute5 IN cn_sf_repositories.attribute5%TYPE := NULL,

Line 134: p_attribute2 IN cn_sf_repositories.attribute2%TYPE := NULL,

130: P_FORMU_ACTIVATED_FLAG IN cn_sf_repositories.FORMU_ACTIVATED_FLAG%TYPE,
131: P_TRANSACTION_CALENDAR_ID IN cn_sf_repositories.TRANSACTION_CALENDAR_ID%TYPE,
132: p_attribute_category IN cn_sf_repositories.attribute_category%TYPE := NULL,
133: p_attribute1 IN cn_sf_repositories.attribute1%TYPE := NULL,
134: p_attribute2 IN cn_sf_repositories.attribute2%TYPE := NULL,
135: p_attribute3 IN cn_sf_repositories.attribute3%TYPE := NULL,
136: p_attribute4 IN cn_sf_repositories.attribute4%TYPE := NULL,
137: p_attribute5 IN cn_sf_repositories.attribute5%TYPE := NULL,
138: p_attribute6 IN cn_sf_repositories.attribute6%TYPE := NULL,

Line 135: p_attribute3 IN cn_sf_repositories.attribute3%TYPE := NULL,

131: P_TRANSACTION_CALENDAR_ID IN cn_sf_repositories.TRANSACTION_CALENDAR_ID%TYPE,
132: p_attribute_category IN cn_sf_repositories.attribute_category%TYPE := NULL,
133: p_attribute1 IN cn_sf_repositories.attribute1%TYPE := NULL,
134: p_attribute2 IN cn_sf_repositories.attribute2%TYPE := NULL,
135: p_attribute3 IN cn_sf_repositories.attribute3%TYPE := NULL,
136: p_attribute4 IN cn_sf_repositories.attribute4%TYPE := NULL,
137: p_attribute5 IN cn_sf_repositories.attribute5%TYPE := NULL,
138: p_attribute6 IN cn_sf_repositories.attribute6%TYPE := NULL,
139: p_attribute7 IN cn_sf_repositories.attribute7%TYPE := NULL,

Line 136: p_attribute4 IN cn_sf_repositories.attribute4%TYPE := NULL,

132: p_attribute_category IN cn_sf_repositories.attribute_category%TYPE := NULL,
133: p_attribute1 IN cn_sf_repositories.attribute1%TYPE := NULL,
134: p_attribute2 IN cn_sf_repositories.attribute2%TYPE := NULL,
135: p_attribute3 IN cn_sf_repositories.attribute3%TYPE := NULL,
136: p_attribute4 IN cn_sf_repositories.attribute4%TYPE := NULL,
137: p_attribute5 IN cn_sf_repositories.attribute5%TYPE := NULL,
138: p_attribute6 IN cn_sf_repositories.attribute6%TYPE := NULL,
139: p_attribute7 IN cn_sf_repositories.attribute7%TYPE := NULL,
140: p_attribute8 IN cn_sf_repositories.attribute8%TYPE := NULL,

Line 137: p_attribute5 IN cn_sf_repositories.attribute5%TYPE := NULL,

133: p_attribute1 IN cn_sf_repositories.attribute1%TYPE := NULL,
134: p_attribute2 IN cn_sf_repositories.attribute2%TYPE := NULL,
135: p_attribute3 IN cn_sf_repositories.attribute3%TYPE := NULL,
136: p_attribute4 IN cn_sf_repositories.attribute4%TYPE := NULL,
137: p_attribute5 IN cn_sf_repositories.attribute5%TYPE := NULL,
138: p_attribute6 IN cn_sf_repositories.attribute6%TYPE := NULL,
139: p_attribute7 IN cn_sf_repositories.attribute7%TYPE := NULL,
140: p_attribute8 IN cn_sf_repositories.attribute8%TYPE := NULL,
141: p_attribute9 IN cn_sf_repositories.attribute9%TYPE := NULL,

Line 138: p_attribute6 IN cn_sf_repositories.attribute6%TYPE := NULL,

134: p_attribute2 IN cn_sf_repositories.attribute2%TYPE := NULL,
135: p_attribute3 IN cn_sf_repositories.attribute3%TYPE := NULL,
136: p_attribute4 IN cn_sf_repositories.attribute4%TYPE := NULL,
137: p_attribute5 IN cn_sf_repositories.attribute5%TYPE := NULL,
138: p_attribute6 IN cn_sf_repositories.attribute6%TYPE := NULL,
139: p_attribute7 IN cn_sf_repositories.attribute7%TYPE := NULL,
140: p_attribute8 IN cn_sf_repositories.attribute8%TYPE := NULL,
141: p_attribute9 IN cn_sf_repositories.attribute9%TYPE := NULL,
142: p_attribute10 IN cn_sf_repositories.attribute10%TYPE := NULL,

Line 139: p_attribute7 IN cn_sf_repositories.attribute7%TYPE := NULL,

135: p_attribute3 IN cn_sf_repositories.attribute3%TYPE := NULL,
136: p_attribute4 IN cn_sf_repositories.attribute4%TYPE := NULL,
137: p_attribute5 IN cn_sf_repositories.attribute5%TYPE := NULL,
138: p_attribute6 IN cn_sf_repositories.attribute6%TYPE := NULL,
139: p_attribute7 IN cn_sf_repositories.attribute7%TYPE := NULL,
140: p_attribute8 IN cn_sf_repositories.attribute8%TYPE := NULL,
141: p_attribute9 IN cn_sf_repositories.attribute9%TYPE := NULL,
142: p_attribute10 IN cn_sf_repositories.attribute10%TYPE := NULL,
143: p_attribute11 IN cn_sf_repositories.attribute11%TYPE := NULL,

Line 140: p_attribute8 IN cn_sf_repositories.attribute8%TYPE := NULL,

136: p_attribute4 IN cn_sf_repositories.attribute4%TYPE := NULL,
137: p_attribute5 IN cn_sf_repositories.attribute5%TYPE := NULL,
138: p_attribute6 IN cn_sf_repositories.attribute6%TYPE := NULL,
139: p_attribute7 IN cn_sf_repositories.attribute7%TYPE := NULL,
140: p_attribute8 IN cn_sf_repositories.attribute8%TYPE := NULL,
141: p_attribute9 IN cn_sf_repositories.attribute9%TYPE := NULL,
142: p_attribute10 IN cn_sf_repositories.attribute10%TYPE := NULL,
143: p_attribute11 IN cn_sf_repositories.attribute11%TYPE := NULL,
144: p_attribute12 IN cn_sf_repositories.attribute12%TYPE := NULL,

Line 141: p_attribute9 IN cn_sf_repositories.attribute9%TYPE := NULL,

137: p_attribute5 IN cn_sf_repositories.attribute5%TYPE := NULL,
138: p_attribute6 IN cn_sf_repositories.attribute6%TYPE := NULL,
139: p_attribute7 IN cn_sf_repositories.attribute7%TYPE := NULL,
140: p_attribute8 IN cn_sf_repositories.attribute8%TYPE := NULL,
141: p_attribute9 IN cn_sf_repositories.attribute9%TYPE := NULL,
142: p_attribute10 IN cn_sf_repositories.attribute10%TYPE := NULL,
143: p_attribute11 IN cn_sf_repositories.attribute11%TYPE := NULL,
144: p_attribute12 IN cn_sf_repositories.attribute12%TYPE := NULL,
145: p_attribute13 IN cn_sf_repositories.attribute13%TYPE := NULL,

Line 142: p_attribute10 IN cn_sf_repositories.attribute10%TYPE := NULL,

138: p_attribute6 IN cn_sf_repositories.attribute6%TYPE := NULL,
139: p_attribute7 IN cn_sf_repositories.attribute7%TYPE := NULL,
140: p_attribute8 IN cn_sf_repositories.attribute8%TYPE := NULL,
141: p_attribute9 IN cn_sf_repositories.attribute9%TYPE := NULL,
142: p_attribute10 IN cn_sf_repositories.attribute10%TYPE := NULL,
143: p_attribute11 IN cn_sf_repositories.attribute11%TYPE := NULL,
144: p_attribute12 IN cn_sf_repositories.attribute12%TYPE := NULL,
145: p_attribute13 IN cn_sf_repositories.attribute13%TYPE := NULL,
146: p_attribute14 IN cn_sf_repositories.attribute14%TYPE := NULL,

Line 143: p_attribute11 IN cn_sf_repositories.attribute11%TYPE := NULL,

139: p_attribute7 IN cn_sf_repositories.attribute7%TYPE := NULL,
140: p_attribute8 IN cn_sf_repositories.attribute8%TYPE := NULL,
141: p_attribute9 IN cn_sf_repositories.attribute9%TYPE := NULL,
142: p_attribute10 IN cn_sf_repositories.attribute10%TYPE := NULL,
143: p_attribute11 IN cn_sf_repositories.attribute11%TYPE := NULL,
144: p_attribute12 IN cn_sf_repositories.attribute12%TYPE := NULL,
145: p_attribute13 IN cn_sf_repositories.attribute13%TYPE := NULL,
146: p_attribute14 IN cn_sf_repositories.attribute14%TYPE := NULL,
147: p_attribute15 IN cn_sf_repositories.attribute15%TYPE := NULL,

Line 144: p_attribute12 IN cn_sf_repositories.attribute12%TYPE := NULL,

140: p_attribute8 IN cn_sf_repositories.attribute8%TYPE := NULL,
141: p_attribute9 IN cn_sf_repositories.attribute9%TYPE := NULL,
142: p_attribute10 IN cn_sf_repositories.attribute10%TYPE := NULL,
143: p_attribute11 IN cn_sf_repositories.attribute11%TYPE := NULL,
144: p_attribute12 IN cn_sf_repositories.attribute12%TYPE := NULL,
145: p_attribute13 IN cn_sf_repositories.attribute13%TYPE := NULL,
146: p_attribute14 IN cn_sf_repositories.attribute14%TYPE := NULL,
147: p_attribute15 IN cn_sf_repositories.attribute15%TYPE := NULL,
148: p_created_by IN cn_sf_repositories.created_by%TYPE := NULL,

Line 145: p_attribute13 IN cn_sf_repositories.attribute13%TYPE := NULL,

141: p_attribute9 IN cn_sf_repositories.attribute9%TYPE := NULL,
142: p_attribute10 IN cn_sf_repositories.attribute10%TYPE := NULL,
143: p_attribute11 IN cn_sf_repositories.attribute11%TYPE := NULL,
144: p_attribute12 IN cn_sf_repositories.attribute12%TYPE := NULL,
145: p_attribute13 IN cn_sf_repositories.attribute13%TYPE := NULL,
146: p_attribute14 IN cn_sf_repositories.attribute14%TYPE := NULL,
147: p_attribute15 IN cn_sf_repositories.attribute15%TYPE := NULL,
148: p_created_by IN cn_sf_repositories.created_by%TYPE := NULL,
149: p_creation_date IN cn_sf_repositories.creation_date%TYPE := NULL,

Line 146: p_attribute14 IN cn_sf_repositories.attribute14%TYPE := NULL,

142: p_attribute10 IN cn_sf_repositories.attribute10%TYPE := NULL,
143: p_attribute11 IN cn_sf_repositories.attribute11%TYPE := NULL,
144: p_attribute12 IN cn_sf_repositories.attribute12%TYPE := NULL,
145: p_attribute13 IN cn_sf_repositories.attribute13%TYPE := NULL,
146: p_attribute14 IN cn_sf_repositories.attribute14%TYPE := NULL,
147: p_attribute15 IN cn_sf_repositories.attribute15%TYPE := NULL,
148: p_created_by IN cn_sf_repositories.created_by%TYPE := NULL,
149: p_creation_date IN cn_sf_repositories.creation_date%TYPE := NULL,
150: p_last_update_login IN cn_sf_repositories.last_update_login%TYPE := NULL,

Line 147: p_attribute15 IN cn_sf_repositories.attribute15%TYPE := NULL,

143: p_attribute11 IN cn_sf_repositories.attribute11%TYPE := NULL,
144: p_attribute12 IN cn_sf_repositories.attribute12%TYPE := NULL,
145: p_attribute13 IN cn_sf_repositories.attribute13%TYPE := NULL,
146: p_attribute14 IN cn_sf_repositories.attribute14%TYPE := NULL,
147: p_attribute15 IN cn_sf_repositories.attribute15%TYPE := NULL,
148: p_created_by IN cn_sf_repositories.created_by%TYPE := NULL,
149: p_creation_date IN cn_sf_repositories.creation_date%TYPE := NULL,
150: p_last_update_login IN cn_sf_repositories.last_update_login%TYPE := NULL,
151: p_last_update_date IN cn_sf_repositories.last_update_date%TYPE := NULL,

Line 148: p_created_by IN cn_sf_repositories.created_by%TYPE := NULL,

144: p_attribute12 IN cn_sf_repositories.attribute12%TYPE := NULL,
145: p_attribute13 IN cn_sf_repositories.attribute13%TYPE := NULL,
146: p_attribute14 IN cn_sf_repositories.attribute14%TYPE := NULL,
147: p_attribute15 IN cn_sf_repositories.attribute15%TYPE := NULL,
148: p_created_by IN cn_sf_repositories.created_by%TYPE := NULL,
149: p_creation_date IN cn_sf_repositories.creation_date%TYPE := NULL,
150: p_last_update_login IN cn_sf_repositories.last_update_login%TYPE := NULL,
151: p_last_update_date IN cn_sf_repositories.last_update_date%TYPE := NULL,
152: p_last_updated_by IN cn_sf_repositories.last_updated_by%TYPE := NULL,

Line 149: p_creation_date IN cn_sf_repositories.creation_date%TYPE := NULL,

145: p_attribute13 IN cn_sf_repositories.attribute13%TYPE := NULL,
146: p_attribute14 IN cn_sf_repositories.attribute14%TYPE := NULL,
147: p_attribute15 IN cn_sf_repositories.attribute15%TYPE := NULL,
148: p_created_by IN cn_sf_repositories.created_by%TYPE := NULL,
149: p_creation_date IN cn_sf_repositories.creation_date%TYPE := NULL,
150: p_last_update_login IN cn_sf_repositories.last_update_login%TYPE := NULL,
151: p_last_update_date IN cn_sf_repositories.last_update_date%TYPE := NULL,
152: p_last_updated_by IN cn_sf_repositories.last_updated_by%TYPE := NULL,
153: p_object_version_number IN cn_sf_repositories.OBJECT_VERSION_NUMBER%TYPE := NULL) IS

Line 150: p_last_update_login IN cn_sf_repositories.last_update_login%TYPE := NULL,

146: p_attribute14 IN cn_sf_repositories.attribute14%TYPE := NULL,
147: p_attribute15 IN cn_sf_repositories.attribute15%TYPE := NULL,
148: p_created_by IN cn_sf_repositories.created_by%TYPE := NULL,
149: p_creation_date IN cn_sf_repositories.creation_date%TYPE := NULL,
150: p_last_update_login IN cn_sf_repositories.last_update_login%TYPE := NULL,
151: p_last_update_date IN cn_sf_repositories.last_update_date%TYPE := NULL,
152: p_last_updated_by IN cn_sf_repositories.last_updated_by%TYPE := NULL,
153: p_object_version_number IN cn_sf_repositories.OBJECT_VERSION_NUMBER%TYPE := NULL) IS
154:

Line 151: p_last_update_date IN cn_sf_repositories.last_update_date%TYPE := NULL,

147: p_attribute15 IN cn_sf_repositories.attribute15%TYPE := NULL,
148: p_created_by IN cn_sf_repositories.created_by%TYPE := NULL,
149: p_creation_date IN cn_sf_repositories.creation_date%TYPE := NULL,
150: p_last_update_login IN cn_sf_repositories.last_update_login%TYPE := NULL,
151: p_last_update_date IN cn_sf_repositories.last_update_date%TYPE := NULL,
152: p_last_updated_by IN cn_sf_repositories.last_updated_by%TYPE := NULL,
153: p_object_version_number IN cn_sf_repositories.OBJECT_VERSION_NUMBER%TYPE := NULL) IS
154:
155: /* CURSOR l_old_csr IS

Line 152: p_last_updated_by IN cn_sf_repositories.last_updated_by%TYPE := NULL,

148: p_created_by IN cn_sf_repositories.created_by%TYPE := NULL,
149: p_creation_date IN cn_sf_repositories.creation_date%TYPE := NULL,
150: p_last_update_login IN cn_sf_repositories.last_update_login%TYPE := NULL,
151: p_last_update_date IN cn_sf_repositories.last_update_date%TYPE := NULL,
152: p_last_updated_by IN cn_sf_repositories.last_updated_by%TYPE := NULL,
153: p_object_version_number IN cn_sf_repositories.OBJECT_VERSION_NUMBER%TYPE := NULL) IS
154:
155: /* CURSOR l_old_csr IS
156: SELECT *

Line 153: p_object_version_number IN cn_sf_repositories.OBJECT_VERSION_NUMBER%TYPE := NULL) IS

149: p_creation_date IN cn_sf_repositories.creation_date%TYPE := NULL,
150: p_last_update_login IN cn_sf_repositories.last_update_login%TYPE := NULL,
151: p_last_update_date IN cn_sf_repositories.last_update_date%TYPE := NULL,
152: p_last_updated_by IN cn_sf_repositories.last_updated_by%TYPE := NULL,
153: p_object_version_number IN cn_sf_repositories.OBJECT_VERSION_NUMBER%TYPE := NULL) IS
154:
155: /* CURSOR l_old_csr IS
156: SELECT *
157: FROM cn_seasonalities

Line 163: FROM cn_sf_repositories

159: */
160:
161: CURSOR l_old_csr IS
162: SELECT *
163: FROM cn_sf_repositories
164: WHERE REPOSITORY_ID = P_REPOSITORY_ID;
165:
166: l_old_rec l_old_csr%ROWTYPE;
167:

Line 199: --update cn_sf_repositories set contract_title = ( select 'wormsss4' from dual ) where repository_id = 10061 ;

195: --DBMS_OUTPUT.PUT_LINE(' Table Handlers update : Started. ID : ');
196: --DBMS_OUTPUT.PUT_LINE('Old Num : ' || l_num || ' ID in procedure : ' || p_repository_id);
197: --DBMS_OUTPUT.PUT_LINE('Parameter version ' || p_object_version_number) ;
198: --DBMS_OUTPUT.PUT_LINE('version Number :' || l_object_version_number || ': OVN :' || l_old_rec.object_version_number) ;
199: --update cn_sf_repositories set contract_title = ( select 'wormsss4' from dual ) where repository_id = 10061 ;
200:
201: UPDATE cn_sf_repositories SET (
202: CONTRACT_TITLE,
203: TERMS_AND_CONDITIONS,

Line 201: UPDATE cn_sf_repositories SET (

197: --DBMS_OUTPUT.PUT_LINE('Parameter version ' || p_object_version_number) ;
198: --DBMS_OUTPUT.PUT_LINE('version Number :' || l_object_version_number || ': OVN :' || l_old_rec.object_version_number) ;
199: --update cn_sf_repositories set contract_title = ( select 'wormsss4' from dual ) where repository_id = 10061 ;
200:
201: UPDATE cn_sf_repositories SET (
202: CONTRACT_TITLE,
203: TERMS_AND_CONDITIONS,
204: CLUB_QUAL_TEXT,
205: APPROVER_NAME,

Line 271: (P_REPOSITORY_ID IN cn_sf_repositories.REPOSITORY_ID%TYPE) IS

267: END update_row;
268:
269: -- delete record
270: PROCEDURE delete_row
271: (P_REPOSITORY_ID IN cn_sf_repositories.REPOSITORY_ID%TYPE) IS
272: BEGIN
273: DELETE FROM cn_sf_repositories
274: WHERE REPOSITORY_ID = P_REPOSITORY_ID;
275: --DBMS_OUTPUT.PUT_LINE('I have just ran the procedure.');

Line 273: DELETE FROM cn_sf_repositories

269: -- delete record
270: PROCEDURE delete_row
271: (P_REPOSITORY_ID IN cn_sf_repositories.REPOSITORY_ID%TYPE) IS
272: BEGIN
273: DELETE FROM cn_sf_repositories
274: WHERE REPOSITORY_ID = P_REPOSITORY_ID;
275: --DBMS_OUTPUT.PUT_LINE('I have just ran the procedure.');
276: END delete_row;
277: