DBA Data[Home] [Help]

APPS.OKC_CONTRACT_GROUP_PVT dependencies on OKC_API

Line 15: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

11: g_cgcv_rec cgcv_rec_type;
12: g_cgcv_tbl cgcv_tbl_type;
13:
14: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
15: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
16: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
17: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
19: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';

Line 16: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

12: g_cgcv_tbl cgcv_tbl_type;
13:
14: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
15: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
16: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
17: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
19: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
20: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';

Line 17: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

13:
14: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
15: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
16: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
17: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
19: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
20: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
21: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';

Line 18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

14: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
15: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
16: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
17: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
19: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
20: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
21: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
22: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_GROUP_PVT';

Line 23: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

19: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
20: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
21: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
22: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_GROUP_PVT';
23: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
24:
25: PROCEDURE add_language;
26:
27: PROCEDURE create_ctr_group(

Line 29: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

25: PROCEDURE add_language;
26:
27: PROCEDURE create_ctr_group(
28: p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
30: x_return_status OUT NOCOPY VARCHAR2,
31: x_msg_count OUT NOCOPY NUMBER,
32: x_msg_data OUT NOCOPY VARCHAR2,
33: p_cgpv_rec IN cgpv_rec_type,

Line 40: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

36: x_cgcv_tbl OUT NOCOPY cgcv_tbl_type);
37:
38: PROCEDURE update_ctr_group(
39: p_api_version IN NUMBER,
40: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
41: x_return_status OUT NOCOPY VARCHAR2,
42: x_msg_count OUT NOCOPY NUMBER,
43: x_msg_data OUT NOCOPY VARCHAR2,
44: p_cgpv_rec IN cgpv_rec_type,

Line 51: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

47: x_cgcv_tbl OUT NOCOPY cgcv_tbl_type);
48:
49: PROCEDURE validate_ctr_group(
50: p_api_version IN NUMBER,
51: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
52: x_return_status OUT NOCOPY VARCHAR2,
53: x_msg_count OUT NOCOPY NUMBER,
54: x_msg_data OUT NOCOPY VARCHAR2,
55: p_cgpv_rec IN cgpv_rec_type,

Line 60: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

56: p_cgcv_tbl IN cgcv_tbl_type);
57:
58: PROCEDURE create_contract_group(
59: p_api_version IN NUMBER,
60: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
61: x_return_status OUT NOCOPY VARCHAR2,
62: x_msg_count OUT NOCOPY NUMBER,
63: x_msg_data OUT NOCOPY VARCHAR2,
64: p_cgpv_rec IN cgpv_rec_type,

Line 69: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

65: x_cgpv_rec OUT NOCOPY cgpv_rec_type);
66:
67: PROCEDURE create_contract_group(
68: p_api_version IN NUMBER,
69: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
70: x_return_status OUT NOCOPY VARCHAR2,
71: x_msg_count OUT NOCOPY NUMBER,
72: x_msg_data OUT NOCOPY VARCHAR2,
73: p_cgpv_tbl IN cgpv_tbl_type,

Line 78: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

74: x_cgpv_tbl OUT NOCOPY cgpv_tbl_type);
75:
76: PROCEDURE update_contract_group(
77: p_api_version IN NUMBER,
78: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
79: x_return_status OUT NOCOPY VARCHAR2,
80: x_msg_count OUT NOCOPY NUMBER,
81: x_msg_data OUT NOCOPY VARCHAR2,
82: p_cgpv_rec IN cgpv_rec_type,

Line 87: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

83: x_cgpv_rec OUT NOCOPY cgpv_rec_type);
84:
85: PROCEDURE update_contract_group(
86: p_api_version IN NUMBER,
87: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
88: x_return_status OUT NOCOPY VARCHAR2,
89: x_msg_count OUT NOCOPY NUMBER,
90: x_msg_data OUT NOCOPY VARCHAR2,
91: p_cgpv_tbl IN cgpv_tbl_type,

Line 96: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

92: x_cgpv_tbl OUT NOCOPY cgpv_tbl_type);
93:
94: PROCEDURE delete_contract_group(
95: p_api_version IN NUMBER,
96: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
97: x_return_status OUT NOCOPY VARCHAR2,
98: x_msg_count OUT NOCOPY NUMBER,
99: x_msg_data OUT NOCOPY VARCHAR2,
100: p_cgpv_rec IN cgpv_rec_type);

Line 104: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

100: p_cgpv_rec IN cgpv_rec_type);
101:
102: PROCEDURE delete_contract_group(
103: p_api_version IN NUMBER,
104: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_msg_count OUT NOCOPY NUMBER,
107: x_msg_data OUT NOCOPY VARCHAR2,
108: p_cgpv_tbl IN cgpv_tbl_type);

Line 112: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

108: p_cgpv_tbl IN cgpv_tbl_type);
109:
110: PROCEDURE lock_contract_group(
111: p_api_version IN NUMBER,
112: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
113: x_return_status OUT NOCOPY VARCHAR2,
114: x_msg_count OUT NOCOPY NUMBER,
115: x_msg_data OUT NOCOPY VARCHAR2,
116: p_cgpv_rec IN cgpv_rec_type);

Line 120: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

116: p_cgpv_rec IN cgpv_rec_type);
117:
118: PROCEDURE lock_contract_group(
119: p_api_version IN NUMBER,
120: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,
123: x_msg_data OUT NOCOPY VARCHAR2,
124: p_cgpv_tbl IN cgpv_tbl_type);

Line 128: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

124: p_cgpv_tbl IN cgpv_tbl_type);
125:
126: PROCEDURE validate_contract_group(
127: p_api_version IN NUMBER,
128: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
129: x_return_status OUT NOCOPY VARCHAR2,
130: x_msg_count OUT NOCOPY NUMBER,
131: x_msg_data OUT NOCOPY VARCHAR2,
132: p_cgpv_rec IN cgpv_rec_type);

Line 136: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

132: p_cgpv_rec IN cgpv_rec_type);
133:
134: PROCEDURE validate_contract_group(
135: p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,
139: x_msg_data OUT NOCOPY VARCHAR2,
140: p_cgpv_tbl IN cgpv_tbl_type);

Line 144: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

140: p_cgpv_tbl IN cgpv_tbl_type);
141:
142: PROCEDURE create_contract_grpngs(
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_cgcv_rec IN cgcv_rec_type,

Line 153: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

149: x_cgcv_rec OUT NOCOPY cgcv_rec_type);
150:
151: PROCEDURE create_contract_grpngs(
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_cgcv_tbl IN cgcv_tbl_type,

Line 162: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

158: x_cgcv_tbl OUT NOCOPY cgcv_tbl_type);
159:
160: PROCEDURE update_contract_grpngs(
161: p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: p_cgcv_rec IN cgcv_rec_type,

Line 171: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

167: x_cgcv_rec OUT NOCOPY cgcv_rec_type);
168:
169: PROCEDURE update_contract_grpngs(
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_cgcv_tbl IN cgcv_tbl_type,

Line 180: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

176: x_cgcv_tbl OUT NOCOPY cgcv_tbl_type);
177:
178: PROCEDURE delete_contract_grpngs(
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2,
184: p_cgcv_rec IN cgcv_rec_type);

Line 188: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

184: p_cgcv_rec IN cgcv_rec_type);
185:
186: PROCEDURE delete_contract_grpngs(
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
189: x_return_status OUT NOCOPY VARCHAR2,
190: x_msg_count OUT NOCOPY NUMBER,
191: x_msg_data OUT NOCOPY VARCHAR2,
192: p_cgcv_tbl IN cgcv_tbl_type);

Line 196: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

192: p_cgcv_tbl IN cgcv_tbl_type);
193:
194: PROCEDURE lock_contract_grpngs(
195: p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,
199: x_msg_data OUT NOCOPY VARCHAR2,
200: p_cgcv_rec IN cgcv_rec_type);

Line 204: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

200: p_cgcv_rec IN cgcv_rec_type);
201:
202: PROCEDURE lock_contract_grpngs(
203: p_api_version IN NUMBER,
204: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
205: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,
207: x_msg_data OUT NOCOPY VARCHAR2,
208: p_cgcv_tbl IN cgcv_tbl_type);

Line 212: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

208: p_cgcv_tbl IN cgcv_tbl_type);
209:
210: PROCEDURE validate_contract_grpngs(
211: p_api_version IN NUMBER,
212: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
213: x_return_status OUT NOCOPY VARCHAR2,
214: x_msg_count OUT NOCOPY NUMBER,
215: x_msg_data OUT NOCOPY VARCHAR2,
216: p_cgcv_rec IN cgcv_rec_type);

Line 220: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

216: p_cgcv_rec IN cgcv_rec_type);
217:
218: PROCEDURE validate_contract_grpngs(
219: p_api_version IN NUMBER,
220: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
221: x_return_status OUT NOCOPY VARCHAR2,
222: x_msg_count OUT NOCOPY NUMBER,
223: x_msg_data OUT NOCOPY VARCHAR2,
224: p_cgcv_tbl IN cgcv_tbl_type);