APPS.CN_SF_PARAMS_PVT dependencies on CN_SF_REPOSITORIES

Line 21: -- OUT : p_sf_repositories_rec OUT cn_sf_repositories_rec_type

17: -- p_commit IN VARCHAR2 Optional
18: -- Default = FND_API.G_FALSE
19: -- p_validation_level IN NUMBER Optional
20: -- Default = FND_API.G_VALID_LEVEL_FULL
21: -- OUT : p_sf_repositories_rec OUT cn_sf_repositories_rec_type
22: -- x_return_status OUT VARCHAR2(1)
23: -- x_msg_count OUT NUMBER
24: -- x_msg_data OUT VARCHAR2(2000)
25: --

Line 31: -- to get parameters from CN_SF_REPOSITORIES.

27: --
28: --
29: --
30: -- Notes : This procedure uses the table handler CN_SF_PARAMS_PKG
31: -- to get parameters from CN_SF_REPOSITORIES.
32: --
33: -- End of comments
34:
35: PROCEDURE Get_SF_Parameters

Line 41: p_sf_param_rec OUT NOCOPY cn_sf_repositories_rec_type,

37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
39: p_commit IN VARCHAR2 := FND_API.G_FALSE,
40: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41: p_sf_param_rec OUT NOCOPY cn_sf_repositories_rec_type,
42: x_return_status OUT NOCOPY VARCHAR2,
43: x_msg_count OUT NOCOPY NUMBER,
44: x_msg_data OUT NOCOPY VARCHAR2
45: ) IS

Line 94: FROM CN_SF_REPOSITORIES;

90: p_sf_param_rec.APPROVER_NAME , p_sf_param_rec.APPROVER_TITLE ,
91: p_sf_param_rec.APPROVER_ORG_NAME , p_sf_param_rec.FILE_ID,
92: p_sf_param_rec.FORMU_ACTIVATED_FLAG, p_sf_param_rec.TRANSACTION_CALENDAR_ID,
93: p_sf_param_rec.OBJECT_VERSION_NUMBER
94: FROM CN_SF_REPOSITORIES;
95:
96: --DBMS_OUTPUT.PUT_LINE('Getting complete.');
97: -- END OF API BODY ---
98: << end_Get_SF_Parameters >>

Line 197: p_sf_repositories_rec IN cn_sf_repositories_rec_type,

193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
195: p_commit IN VARCHAR2 := FND_API.G_FALSE,
196: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
197: p_sf_repositories_rec IN cn_sf_repositories_rec_type,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,
200: x_msg_data OUT NOCOPY VARCHAR2
201: ) IS

Line 207: l_rec cn_sf_repositories_rec_type ;

203: -- local variables
204: l_api_name CONSTANT VARCHAR2(30) := 'Update_Repository' ;
205: l_api_version CONSTANT NUMBER := 1.0 ;
206: l_error_code NUMBER ;
207: l_rec cn_sf_repositories_rec_type ;
208: l_validation_status VARCHAR2(30) ;
209: l_return_status VARCHAR2(1);
210: l_count NUMBER ;
211:

Line 237: FROM CN_SF_REPOSITORIES ;

233: l_validation_status := 'INVALID';
234: /*
235: SELECT Count(*)
236: INTO l_count
237: FROM CN_SF_REPOSITORIES ;
238:
239: IF l_count > 0 THEN
240: FND_MESSAGE.SET_NAME ('CN' , 'CN_RECORD_CHANGED');
241: FND_MSG_PUB.Add;

Line 355: -- p_sf_repositories_rec IN cn_sf_repositories_rec_type

351: -- p_commit IN VARCHAR2 Optional
352: -- Default = FND_API.G_FALSE
353: -- p_validation_level IN NUMBER Optional
354: -- Default = FND_API.G_VALID_LEVEL_FULL
355: -- p_sf_repositories_rec IN cn_sf_repositories_rec_type
356: -- OUT : x_return_status OUT VARCHAR2(1)
357: -- x_msg_count OUT NUMBER
358: -- x_msg_data OUT VARCHAR2(2000)
359: --

Line 365: -- to insert a row into CN_SF_REPOSITORIES after some validations.

361: --
362: --
363: --
364: -- Notes : This procedure uses the table handler CN_SF_PARAMS_PKG
365: -- to insert a row into CN_SF_REPOSITORIES after some validations.
366: --
367: -- End of comments
368:
369: PROCEDURE Insert_SF_Parameters

Line 375: p_sf_repositories_rec IN cn_sf_repositories_rec_type,

371: p_api_version IN NUMBER,
372: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
373: p_commit IN VARCHAR2 := FND_API.G_FALSE,
374: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
375: p_sf_repositories_rec IN cn_sf_repositories_rec_type,
376: x_return_status OUT NOCOPY VARCHAR2,
377: x_msg_count OUT NOCOPY NUMBER,
378: x_msg_data OUT NOCOPY VARCHAR2
379: ) IS

Line 417: FROM CN_SF_REPOSITORIES ;

413:
414: -- Beginning of validation code -----
415: SELECT Count(*)
416: INTO l_count
417: FROM CN_SF_REPOSITORIES ;
418:
419: IF l_count > 0 THEN
420: FND_MESSAGE.SET_NAME ('CN' , 'CN_SF_RECORD_EXISTS');
421: FND_MSG_PUB.Add;