3:
4: TYPE cn_sf_repositories_rec_type IS RECORD
5: (
6: REPOSITORY_ID cn_sf_repositories.REPOSITORY_ID%TYPE := NULL,
7: CONTRACT_TITLE cn_sf_repositories.CONTRACT_TITLE%TYPE := FND_API.G_MISS_CHAR,
8: TERMS_AND_CONDITIONS cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE := FND_API.G_MISS_CHAR,
9: CLUB_QUAL_TEXT cn_sf_repositories.CLUB_QUAL_TEXT%TYPE := FND_API.G_MISS_CHAR,
10: APPROVER_NAME cn_sf_repositories.APPROVER_NAME%TYPE := FND_API.G_MISS_CHAR,
11: APPROVER_TITLE cn_sf_repositories.APPROVER_TITLE%TYPE := FND_API.G_MISS_CHAR,
4: TYPE cn_sf_repositories_rec_type IS RECORD
5: (
6: REPOSITORY_ID cn_sf_repositories.REPOSITORY_ID%TYPE := NULL,
7: CONTRACT_TITLE cn_sf_repositories.CONTRACT_TITLE%TYPE := FND_API.G_MISS_CHAR,
8: TERMS_AND_CONDITIONS cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE := FND_API.G_MISS_CHAR,
9: CLUB_QUAL_TEXT cn_sf_repositories.CLUB_QUAL_TEXT%TYPE := FND_API.G_MISS_CHAR,
10: APPROVER_NAME cn_sf_repositories.APPROVER_NAME%TYPE := FND_API.G_MISS_CHAR,
11: APPROVER_TITLE cn_sf_repositories.APPROVER_TITLE%TYPE := FND_API.G_MISS_CHAR,
12: APPROVER_ORG_NAME cn_sf_repositories.APPROVER_ORG_NAME%TYPE := FND_API.G_MISS_CHAR,
5: (
6: REPOSITORY_ID cn_sf_repositories.REPOSITORY_ID%TYPE := NULL,
7: CONTRACT_TITLE cn_sf_repositories.CONTRACT_TITLE%TYPE := FND_API.G_MISS_CHAR,
8: TERMS_AND_CONDITIONS cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE := FND_API.G_MISS_CHAR,
9: CLUB_QUAL_TEXT cn_sf_repositories.CLUB_QUAL_TEXT%TYPE := FND_API.G_MISS_CHAR,
10: APPROVER_NAME cn_sf_repositories.APPROVER_NAME%TYPE := FND_API.G_MISS_CHAR,
11: APPROVER_TITLE cn_sf_repositories.APPROVER_TITLE%TYPE := FND_API.G_MISS_CHAR,
12: APPROVER_ORG_NAME cn_sf_repositories.APPROVER_ORG_NAME%TYPE := FND_API.G_MISS_CHAR,
13: FILE_ID cn_sf_repositories.FILE_ID%TYPE := NULL,
6: REPOSITORY_ID cn_sf_repositories.REPOSITORY_ID%TYPE := NULL,
7: CONTRACT_TITLE cn_sf_repositories.CONTRACT_TITLE%TYPE := FND_API.G_MISS_CHAR,
8: TERMS_AND_CONDITIONS cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE := FND_API.G_MISS_CHAR,
9: CLUB_QUAL_TEXT cn_sf_repositories.CLUB_QUAL_TEXT%TYPE := FND_API.G_MISS_CHAR,
10: APPROVER_NAME cn_sf_repositories.APPROVER_NAME%TYPE := FND_API.G_MISS_CHAR,
11: APPROVER_TITLE cn_sf_repositories.APPROVER_TITLE%TYPE := FND_API.G_MISS_CHAR,
12: APPROVER_ORG_NAME cn_sf_repositories.APPROVER_ORG_NAME%TYPE := FND_API.G_MISS_CHAR,
13: FILE_ID cn_sf_repositories.FILE_ID%TYPE := NULL,
14: FORMU_ACTIVATED_FLAG cn_sf_repositories.FORMU_ACTIVATED_FLAG%TYPE := FND_API.G_MISS_CHAR,
7: CONTRACT_TITLE cn_sf_repositories.CONTRACT_TITLE%TYPE := FND_API.G_MISS_CHAR,
8: TERMS_AND_CONDITIONS cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE := FND_API.G_MISS_CHAR,
9: CLUB_QUAL_TEXT cn_sf_repositories.CLUB_QUAL_TEXT%TYPE := FND_API.G_MISS_CHAR,
10: APPROVER_NAME cn_sf_repositories.APPROVER_NAME%TYPE := FND_API.G_MISS_CHAR,
11: APPROVER_TITLE cn_sf_repositories.APPROVER_TITLE%TYPE := FND_API.G_MISS_CHAR,
12: APPROVER_ORG_NAME cn_sf_repositories.APPROVER_ORG_NAME%TYPE := FND_API.G_MISS_CHAR,
13: FILE_ID cn_sf_repositories.FILE_ID%TYPE := NULL,
14: FORMU_ACTIVATED_FLAG cn_sf_repositories.FORMU_ACTIVATED_FLAG%TYPE := FND_API.G_MISS_CHAR,
15: TRANSACTION_CALENDAR_ID cn_sf_repositories.TRANSACTION_CALENDAR_ID%TYPE := NULL,
8: TERMS_AND_CONDITIONS cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE := FND_API.G_MISS_CHAR,
9: CLUB_QUAL_TEXT cn_sf_repositories.CLUB_QUAL_TEXT%TYPE := FND_API.G_MISS_CHAR,
10: APPROVER_NAME cn_sf_repositories.APPROVER_NAME%TYPE := FND_API.G_MISS_CHAR,
11: APPROVER_TITLE cn_sf_repositories.APPROVER_TITLE%TYPE := FND_API.G_MISS_CHAR,
12: APPROVER_ORG_NAME cn_sf_repositories.APPROVER_ORG_NAME%TYPE := FND_API.G_MISS_CHAR,
13: FILE_ID cn_sf_repositories.FILE_ID%TYPE := NULL,
14: FORMU_ACTIVATED_FLAG cn_sf_repositories.FORMU_ACTIVATED_FLAG%TYPE := FND_API.G_MISS_CHAR,
15: TRANSACTION_CALENDAR_ID cn_sf_repositories.TRANSACTION_CALENDAR_ID%TYPE := NULL,
16: OBJECT_VERSION_NUMBER cn_sf_repositories.OBJECT_VERSION_NUMBER%TYPE:= FND_API.G_MISS_NUM
10: APPROVER_NAME cn_sf_repositories.APPROVER_NAME%TYPE := FND_API.G_MISS_CHAR,
11: APPROVER_TITLE cn_sf_repositories.APPROVER_TITLE%TYPE := FND_API.G_MISS_CHAR,
12: APPROVER_ORG_NAME cn_sf_repositories.APPROVER_ORG_NAME%TYPE := FND_API.G_MISS_CHAR,
13: FILE_ID cn_sf_repositories.FILE_ID%TYPE := NULL,
14: FORMU_ACTIVATED_FLAG cn_sf_repositories.FORMU_ACTIVATED_FLAG%TYPE := FND_API.G_MISS_CHAR,
15: TRANSACTION_CALENDAR_ID cn_sf_repositories.TRANSACTION_CALENDAR_ID%TYPE := NULL,
16: OBJECT_VERSION_NUMBER cn_sf_repositories.OBJECT_VERSION_NUMBER%TYPE:= FND_API.G_MISS_NUM
17: ) ;
18:
12: APPROVER_ORG_NAME cn_sf_repositories.APPROVER_ORG_NAME%TYPE := FND_API.G_MISS_CHAR,
13: FILE_ID cn_sf_repositories.FILE_ID%TYPE := NULL,
14: FORMU_ACTIVATED_FLAG cn_sf_repositories.FORMU_ACTIVATED_FLAG%TYPE := FND_API.G_MISS_CHAR,
15: TRANSACTION_CALENDAR_ID cn_sf_repositories.TRANSACTION_CALENDAR_ID%TYPE := NULL,
16: OBJECT_VERSION_NUMBER cn_sf_repositories.OBJECT_VERSION_NUMBER%TYPE:= FND_API.G_MISS_NUM
17: ) ;
18:
19: TYPE sf_repositories_tbl_type IS TABLE OF cn_sf_repositories_rec_type INDEX BY BINARY_INTEGER;
20:
26: -- Pre-reqs : None.
27: -- Parameters :
28: -- IN : p_api_version IN NUMBER Required
29: -- p_init_msg_list IN VARCHAR2 Optional
30: -- Default = FND_API.G_FALSE
31: -- p_commit IN VARCHAR2 Optional
32: -- Default = FND_API.G_FALSE
33: -- p_validation_level IN NUMBER Optional
34: -- Default = FND_API.G_VALID_LEVEL_FULL
28: -- IN : p_api_version IN NUMBER Required
29: -- p_init_msg_list IN VARCHAR2 Optional
30: -- Default = FND_API.G_FALSE
31: -- p_commit IN VARCHAR2 Optional
32: -- Default = FND_API.G_FALSE
33: -- p_validation_level IN NUMBER Optional
34: -- Default = FND_API.G_VALID_LEVEL_FULL
35: -- OUT : p_sf_repositories_rec OUT cn_sf_repositories_rec_type
36: -- x_return_status OUT VARCHAR2(1)
30: -- Default = FND_API.G_FALSE
31: -- p_commit IN VARCHAR2 Optional
32: -- Default = FND_API.G_FALSE
33: -- p_validation_level IN NUMBER Optional
34: -- Default = FND_API.G_VALID_LEVEL_FULL
35: -- OUT : p_sf_repositories_rec OUT cn_sf_repositories_rec_type
36: -- x_return_status OUT VARCHAR2(1)
37: -- x_msg_count OUT NUMBER
38: -- x_msg_data OUT VARCHAR2(2000)
48:
49: PROCEDURE Get_SF_Parameters
50: (
51: p_api_version IN NUMBER,
52: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
53: p_commit IN VARCHAR2 := FND_API.G_FALSE,
54: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
55: p_sf_param_rec OUT NOCOPY cn_sf_repositories_rec_type,
56: x_return_status OUT NOCOPY VARCHAR2,
49: PROCEDURE Get_SF_Parameters
50: (
51: p_api_version IN NUMBER,
52: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
53: p_commit IN VARCHAR2 := FND_API.G_FALSE,
54: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
55: p_sf_param_rec OUT NOCOPY cn_sf_repositories_rec_type,
56: x_return_status OUT NOCOPY VARCHAR2,
57: x_msg_count OUT NOCOPY NUMBER,
50: (
51: p_api_version IN NUMBER,
52: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
53: p_commit IN VARCHAR2 := FND_API.G_FALSE,
54: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
55: p_sf_param_rec OUT NOCOPY cn_sf_repositories_rec_type,
56: x_return_status OUT NOCOPY VARCHAR2,
57: x_msg_count OUT NOCOPY NUMBER,
58: x_msg_data OUT NOCOPY VARCHAR2
65: -- Pre-reqs : None.
66: -- Parameters :
67: -- IN : p_api_version IN NUMBER Required
68: -- p_init_msg_list IN VARCHAR2 Optional
69: -- Default = FND_API.G_FALSE
70: -- p_commit IN VARCHAR2 Optional
71: -- Default = FND_API.G_FALSE
72: -- p_validation_level IN NUMBER Optional
73: -- Default = FND_API.G_VALID_LEVEL_FULL
67: -- IN : p_api_version IN NUMBER Required
68: -- p_init_msg_list IN VARCHAR2 Optional
69: -- Default = FND_API.G_FALSE
70: -- p_commit IN VARCHAR2 Optional
71: -- Default = FND_API.G_FALSE
72: -- p_validation_level IN NUMBER Optional
73: -- Default = FND_API.G_VALID_LEVEL_FULL
74: -- p_sf_repositories_rec IN cn_sf_repositories_rec_type
75: -- OUT : x_return_status OUT VARCHAR2(1)
69: -- Default = FND_API.G_FALSE
70: -- p_commit IN VARCHAR2 Optional
71: -- Default = FND_API.G_FALSE
72: -- p_validation_level IN NUMBER Optional
73: -- Default = FND_API.G_VALID_LEVEL_FULL
74: -- p_sf_repositories_rec IN cn_sf_repositories_rec_type
75: -- OUT : x_return_status OUT VARCHAR2(1)
76: -- x_msg_count OUT NUMBER
77: -- x_msg_data OUT VARCHAR2(2000)
87:
88: PROCEDURE Update_SF_Parameters
89: (
90: p_api_version IN NUMBER ,
91: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
92: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
93: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
94: p_sf_repositories_rec IN cn_sf_repositories_rec_type,
95: x_return_status OUT NOCOPY VARCHAR2 ,
88: PROCEDURE Update_SF_Parameters
89: (
90: p_api_version IN NUMBER ,
91: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
92: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
93: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
94: p_sf_repositories_rec IN cn_sf_repositories_rec_type,
95: x_return_status OUT NOCOPY VARCHAR2 ,
96: x_msg_count OUT NOCOPY NUMBER ,
89: (
90: p_api_version IN NUMBER ,
91: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
92: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
93: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
94: p_sf_repositories_rec IN cn_sf_repositories_rec_type,
95: x_return_status OUT NOCOPY VARCHAR2 ,
96: x_msg_count OUT NOCOPY NUMBER ,
97: x_msg_data OUT NOCOPY VARCHAR2
104: -- Pre-reqs : None.
105: -- Parameters :
106: -- IN : p_api_version IN NUMBER Required
107: -- p_init_msg_list IN VARCHAR2 Optional
108: -- Default = FND_API.G_FALSE
109: -- p_commit IN VARCHAR2 Optional
110: -- Default = FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Optional
112: -- Default = FND_API.G_VALID_LEVEL_FULL
106: -- IN : p_api_version IN NUMBER Required
107: -- p_init_msg_list IN VARCHAR2 Optional
108: -- Default = FND_API.G_FALSE
109: -- p_commit IN VARCHAR2 Optional
110: -- Default = FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Optional
112: -- Default = FND_API.G_VALID_LEVEL_FULL
113: -- p_sf_repositories_rec IN cn_sf_repositories_rec_type
114: -- OUT : x_return_status OUT VARCHAR2(1)
108: -- Default = FND_API.G_FALSE
109: -- p_commit IN VARCHAR2 Optional
110: -- Default = FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Optional
112: -- Default = FND_API.G_VALID_LEVEL_FULL
113: -- p_sf_repositories_rec IN cn_sf_repositories_rec_type
114: -- OUT : x_return_status OUT VARCHAR2(1)
115: -- x_msg_count OUT NUMBER
116: -- x_msg_data OUT VARCHAR2(2000)
126:
127: PROCEDURE Insert_SF_Parameters
128: (
129: p_api_version IN NUMBER ,
130: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
131: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
132: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
133: p_sf_repositories_rec IN cn_sf_repositories_rec_type,
134: x_return_status OUT NOCOPY VARCHAR2 ,
127: PROCEDURE Insert_SF_Parameters
128: (
129: p_api_version IN NUMBER ,
130: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
131: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
132: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
133: p_sf_repositories_rec IN cn_sf_repositories_rec_type,
134: x_return_status OUT NOCOPY VARCHAR2 ,
135: x_msg_count OUT NOCOPY NUMBER ,
128: (
129: p_api_version IN NUMBER ,
130: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
131: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
132: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
133: p_sf_repositories_rec IN cn_sf_repositories_rec_type,
134: x_return_status OUT NOCOPY VARCHAR2 ,
135: x_msg_count OUT NOCOPY NUMBER ,
136: x_msg_data OUT NOCOPY VARCHAR2