DBA Data[Home] [Help]

APPS.OKL_PROCESS_TMPT_SET_PVT dependencies on OKC_API

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

18: G_EXC_NAME_RET_STS_ERR CONSTANT VARCHAR(25) := 'OKL_API.G_RET_STS_ERROR';
19: G_EXC_NAME_RET_STS_UNEXP_ERR CONSTANT VARCHAR(30) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
20: G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
21: G_API_TYPE CONSTANT VARCHAR(4) := '_PVT';
22: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
23: G_START_DATE CONSTANT VARCHAR2(200) := 'OKL_START_DATE';
24: G_END_DATE CONSTANT VARCHAR2(200) := 'OKL_END_DATE';
25: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
26: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;

Line 46: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

42:
43:
44: PROCEDURE create_tmpt_set(
45: p_api_version IN NUMBER
46: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
47: ,x_return_status OUT NOCOPY VARCHAR2
48: ,x_msg_count OUT NOCOPY NUMBER
49: ,x_msg_data OUT NOCOPY VARCHAR2
50: ,p_aesv_rec IN aesv_rec_type

Line 60: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

56:
57: --Object type procedure for update
58: PROCEDURE update_tmpt_set(
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_aesv_rec IN aesv_rec_type

Line 73: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

69: ,x_atlv_tbl OUT NOCOPY atlv_tbl_type );
70:
71: PROCEDURE create_tmpt_set(
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
74: x_return_status OUT NOCOPY VARCHAR2,
75: x_msg_count OUT NOCOPY NUMBER,
76: x_msg_data OUT NOCOPY VARCHAR2,
77: p_aesv_tbl IN aesv_tbl_type,

Line 82: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

78: x_aesv_tbl OUT NOCOPY aesv_tbl_type);
79:
80: PROCEDURE create_tmpt_set(
81: p_api_version IN NUMBER,
82: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
83: x_return_status OUT NOCOPY VARCHAR2,
84: x_msg_count OUT NOCOPY NUMBER,
85: x_msg_data OUT NOCOPY VARCHAR2,
86: p_aesv_rec IN aesv_rec_type,

Line 92: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

88: p_aes_source_id IN OKL_AE_TMPT_SETS.id%TYPE DEFAULT NULL);
89:
90: PROCEDURE update_tmpt_set(
91: p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
93: x_return_status OUT NOCOPY VARCHAR2,
94: x_msg_count OUT NOCOPY NUMBER,
95: x_msg_data OUT NOCOPY VARCHAR2,
96: p_aesv_tbl IN aesv_tbl_type,

Line 101: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

97: x_aesv_tbl OUT NOCOPY aesv_tbl_type);
98:
99: PROCEDURE update_tmpt_set(
100: p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
102: x_return_status OUT NOCOPY VARCHAR2,
103: x_msg_count OUT NOCOPY NUMBER,
104: x_msg_data OUT NOCOPY VARCHAR2,
105: p_aesv_rec IN aesv_rec_type,

Line 110: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

106: x_aesv_rec OUT NOCOPY aesv_rec_type);
107:
108: PROCEDURE delete_tmpt_set(
109: p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
111: x_return_status OUT NOCOPY VARCHAR2,
112: x_msg_count OUT NOCOPY NUMBER,
113: x_msg_data OUT NOCOPY VARCHAR2,
114: p_aesv_tbl IN aesv_tbl_type);

Line 118: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

114: p_aesv_tbl IN aesv_tbl_type);
115:
116: PROCEDURE delete_tmpt_set(
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
119: x_return_status OUT NOCOPY VARCHAR2,
120: x_msg_count OUT NOCOPY NUMBER,
121: x_msg_data OUT NOCOPY VARCHAR2,
122: p_aesv_rec IN aesv_rec_type);

Line 126: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

122: p_aesv_rec IN aesv_rec_type);
123:
124: PROCEDURE create_template(
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2,
130: p_avlv_tbl IN avlv_tbl_type,

Line 135: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

131: x_avlv_tbl OUT NOCOPY avlv_tbl_type);
132:
133: PROCEDURE create_template(
134: p_api_version IN NUMBER,
135: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
136: x_return_status OUT NOCOPY VARCHAR2,
137: x_msg_count OUT NOCOPY NUMBER,
138: x_msg_data OUT NOCOPY VARCHAR2,
139: p_avlv_rec IN avlv_rec_type,

Line 144: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

140: x_avlv_rec OUT NOCOPY avlv_rec_type);
141:
142: PROCEDURE update_template(
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_avlv_tbl IN avlv_tbl_type,

Line 153: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

149: x_avlv_tbl OUT NOCOPY avlv_tbl_type);
150:
151: PROCEDURE update_template(
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_avlv_rec IN avlv_rec_type,

Line 162: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

158: x_avlv_rec OUT NOCOPY avlv_rec_type);
159:
160: PROCEDURE delete_template(
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_avlv_tbl IN avlv_tbl_type);

Line 170: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

166: p_avlv_tbl IN avlv_tbl_type);
167:
168: PROCEDURE delete_template(
169: p_api_version IN NUMBER,
170: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
171: x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,
173: x_msg_data OUT NOCOPY VARCHAR2,
174: p_avlv_rec IN avlv_rec_type);

Line 178: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

174: p_avlv_rec IN avlv_rec_type);
175:
176: PROCEDURE create_tmpt_lines(
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2,
182: p_atlv_tbl IN atlv_tbl_type,

Line 187: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

183: x_atlv_tbl OUT NOCOPY atlv_tbl_type);
184:
185: PROCEDURE create_tmpt_lines(
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_atlv_rec IN atlv_rec_type,

Line 196: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

192: x_atlv_rec OUT NOCOPY atlv_rec_type);
193:
194: PROCEDURE update_tmpt_lines(
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_atlv_tbl IN atlv_tbl_type,

Line 205: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

201: x_atlv_tbl OUT NOCOPY atlv_tbl_type);
202:
203: PROCEDURE update_tmpt_lines(
204: p_api_version IN NUMBER,
205: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
206: x_return_status OUT NOCOPY VARCHAR2,
207: x_msg_count OUT NOCOPY NUMBER,
208: x_msg_data OUT NOCOPY VARCHAR2,
209: p_atlv_rec IN atlv_rec_type,

Line 214: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

210: x_atlv_rec OUT NOCOPY atlv_rec_type);
211:
212: PROCEDURE delete_tmpt_lines(
213: p_api_version IN NUMBER,
214: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
215: x_return_status OUT NOCOPY VARCHAR2,
216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2,
218: p_atlv_tbl IN atlv_tbl_type);

Line 222: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

218: p_atlv_tbl IN atlv_tbl_type);
219:
220: PROCEDURE delete_tmpt_lines(
221: p_api_version IN NUMBER,
222: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
223: x_return_status OUT NOCOPY VARCHAR2,
224: x_msg_count OUT NOCOPY NUMBER,
225: x_msg_data OUT NOCOPY VARCHAR2,
226: p_atlv_rec IN atlv_rec_type);