[Home] [Help]
PACKAGE: APPS.CN_SF_PARAMS_PVT
Source
1 PACKAGE CN_SF_PARAMS_PVT AUTHID CURRENT_USER AS
2 -- $Header: cnvprmss.pls 115.3 2002/11/21 21:15:46 hlchen ship $
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,
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
21
22 -- Start of comments
23 -- API name : Get_SF_Parameters
24 -- Type : Private.
25 -- Function :
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
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)
39 --
40 -- Version : Current version 1.0
41 --
42 --
43 --
44 -- Notes : This procedure uses the table handler CN_SF_PARAMS_PKG
45 -- to get parameters from CN_SF_REPOSITORIES.
46 --
47 -- End of comments
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,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2
59 ) ;
60
61 -- Start of comments
62 -- API name : Update_Repositories
63 -- Type : Private.
64 -- Function :
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
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)
78 --
79 -- Version : Current version 1.0
80 --
81 --
82 --
83 -- Notes : This procedure uses the table handler CN_SF_PARAMS_PKG
84 -- to update rows into CN_SF_REPOSITORIES after some validations.
85 --
86 -- End of comments
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 ,
96 x_msg_count OUT NOCOPY NUMBER ,
97 x_msg_data OUT NOCOPY VARCHAR2
98 );
99
100 -- Start of comments
101 -- API name : Insert_SF_Parameters
102 -- Type : Private.
103 -- Function :
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
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)
117 --
118 -- Version : Current version 1.0
119 --
120 --
121 --
122 -- Notes : This procedure uses the table handler CN_SF_PARAMS_PKG
123 -- to update rows into CN_SF_REPOSITORIES after some validations.
124 --
125 -- End of comments
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 ,
135 x_msg_count OUT NOCOPY NUMBER ,
136 x_msg_data OUT NOCOPY VARCHAR2
137 ) ;
138
139
140 END CN_SF_PARAMS_PVT;