DBA Data[Home] [Help]

APPS.CN_SF_PARAMS_PVT dependencies on FND_API

Line 7: CONTRACT_TITLE cn_sf_repositories.CONTRACT_TITLE%TYPE := FND_API.G_MISS_CHAR,

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,

Line 8: TERMS_AND_CONDITIONS cn_sf_repositories.TERMS_AND_CONDITIONS%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,

Line 9: CLUB_QUAL_TEXT cn_sf_repositories.CLUB_QUAL_TEXT%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,

Line 10: APPROVER_NAME cn_sf_repositories.APPROVER_NAME%TYPE := FND_API.G_MISS_CHAR,

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,

Line 11: APPROVER_TITLE cn_sf_repositories.APPROVER_TITLE%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,

Line 12: APPROVER_ORG_NAME cn_sf_repositories.APPROVER_ORG_NAME%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

Line 14: FORMU_ACTIVATED_FLAG cn_sf_repositories.FORMU_ACTIVATED_FLAG%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:

Line 16: OBJECT_VERSION_NUMBER cn_sf_repositories.OBJECT_VERSION_NUMBER%TYPE:= FND_API.G_MISS_NUM

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:

Line 30: -- Default = FND_API.G_FALSE

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

Line 32: -- Default = FND_API.G_FALSE

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)

Line 34: -- Default = FND_API.G_VALID_LEVEL_FULL

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)

Line 52: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 53: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 54: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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

Line 69: -- Default = FND_API.G_FALSE

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

Line 71: -- Default = FND_API.G_FALSE

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)

Line 73: -- Default = FND_API.G_VALID_LEVEL_FULL

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)

Line 91: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 92: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 93: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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

Line 108: -- Default = FND_API.G_FALSE

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

Line 110: -- Default = FND_API.G_FALSE

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)

Line 112: -- Default = FND_API.G_VALID_LEVEL_FULL

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)

Line 130: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 131: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 132: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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