DBA Data[Home] [Help]

APPS.OKL_OPTION_RULES_PVT dependencies on OKC_API

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

8: SUBTYPE ovdv_tbl_type IS okl_ovd_pvt.ovdv_tbl_type;
9: ------------------------------------------------------------------------------
10: -- Global Variables
11: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_OPTION_RULES_PVT';
12: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
13: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
14: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
15: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
16: ------------------------------------------------------------------------------

Line 25: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

21:
22: --Object type procedure for insert
23: PROCEDURE create_option_rules(
24: p_api_version IN NUMBER
25: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
26: ,x_return_status OUT NOCOPY VARCHAR2
27: ,x_msg_count OUT NOCOPY NUMBER
28: ,x_msg_data OUT NOCOPY VARCHAR2
29: ,p_orlv_rec IN orlv_rec_type

Line 38: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

34:
35: --Object type procedure for update
36: PROCEDURE update_option_rules(
37: p_api_version IN NUMBER
38: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
39: ,x_return_status OUT NOCOPY VARCHAR2
40: ,x_msg_count OUT NOCOPY NUMBER
41: ,x_msg_data OUT NOCOPY VARCHAR2
42: ,p_orlv_rec IN orlv_rec_type

Line 51: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

47:
48: --Object type procedure for validate
49: PROCEDURE validate_option_rules(
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_orlv_rec IN orlv_rec_type

Line 63: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

59:
60:
61: PROCEDURE create_option_rules(
62: p_api_version IN NUMBER,
63: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
64: x_return_status OUT NOCOPY VARCHAR2,
65: x_msg_count OUT NOCOPY NUMBER,
66: x_msg_data OUT NOCOPY VARCHAR2,
67: p_orlv_tbl IN orlv_tbl_type,

Line 72: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

68: x_orlv_tbl OUT NOCOPY orlv_tbl_type);
69:
70: PROCEDURE create_option_rules(
71: p_api_version IN NUMBER,
72: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
73: x_return_status OUT NOCOPY VARCHAR2,
74: x_msg_count OUT NOCOPY NUMBER,
75: x_msg_data OUT NOCOPY VARCHAR2,
76: p_orlv_rec IN orlv_rec_type,

Line 81: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

77: x_orlv_rec OUT NOCOPY orlv_rec_type);
78:
79: PROCEDURE lock_option_rules(
80: p_api_version IN NUMBER,
81: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
82: x_return_status OUT NOCOPY VARCHAR2,
83: x_msg_count OUT NOCOPY NUMBER,
84: x_msg_data OUT NOCOPY VARCHAR2,
85: p_orlv_tbl IN orlv_tbl_type);

Line 89: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

85: p_orlv_tbl IN orlv_tbl_type);
86:
87: PROCEDURE lock_option_rules(
88: p_api_version IN NUMBER,
89: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
90: x_return_status OUT NOCOPY VARCHAR2,
91: x_msg_count OUT NOCOPY NUMBER,
92: x_msg_data OUT NOCOPY VARCHAR2,
93: p_orlv_rec IN orlv_rec_type);

Line 97: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

93: p_orlv_rec IN orlv_rec_type);
94:
95: PROCEDURE update_option_rules(
96: p_api_version IN NUMBER,
97: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
100: x_msg_data OUT NOCOPY VARCHAR2,
101: p_orlv_tbl IN orlv_tbl_type,

Line 106: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

102: x_orlv_tbl OUT NOCOPY orlv_tbl_type);
103:
104: PROCEDURE update_option_rules(
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
107: x_return_status OUT NOCOPY VARCHAR2,
108: x_msg_count OUT NOCOPY NUMBER,
109: x_msg_data OUT NOCOPY VARCHAR2,
110: p_orlv_rec IN orlv_rec_type,

Line 115: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

111: x_orlv_rec OUT NOCOPY orlv_rec_type);
112:
113: PROCEDURE delete_option_rules(
114: p_api_version IN NUMBER,
115: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
116: x_return_status OUT NOCOPY VARCHAR2,
117: x_msg_count OUT NOCOPY NUMBER,
118: x_msg_data OUT NOCOPY VARCHAR2,
119: p_orlv_tbl IN orlv_tbl_type);

Line 123: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

119: p_orlv_tbl IN orlv_tbl_type);
120:
121: PROCEDURE delete_option_rules(
122: p_api_version IN NUMBER,
123: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
124: x_return_status OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,
126: x_msg_data OUT NOCOPY VARCHAR2,
127: p_orlv_rec IN orlv_rec_type);

Line 131: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

127: p_orlv_rec IN orlv_rec_type);
128:
129: PROCEDURE validate_option_rules(
130: p_api_version IN NUMBER,
131: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
132: x_return_status OUT NOCOPY VARCHAR2,
133: x_msg_count OUT NOCOPY NUMBER,
134: x_msg_data OUT NOCOPY VARCHAR2,
135: p_orlv_tbl IN orlv_tbl_type);

Line 139: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

135: p_orlv_tbl IN orlv_tbl_type);
136:
137: PROCEDURE validate_option_rules(
138: p_api_version IN NUMBER,
139: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_orlv_rec IN orlv_rec_type);

Line 148: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

144:
145:
146: PROCEDURE create_option_val_rules(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2,
152: p_ovdv_tbl IN ovdv_tbl_type,

Line 157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

153: x_ovdv_tbl OUT NOCOPY ovdv_tbl_type);
154:
155: PROCEDURE create_option_val_rules(
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158: x_return_status OUT NOCOPY VARCHAR2,
159: x_msg_count OUT NOCOPY NUMBER,
160: x_msg_data OUT NOCOPY VARCHAR2,
161: p_ovdv_rec IN ovdv_rec_type,

Line 166: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

162: x_ovdv_rec OUT NOCOPY ovdv_rec_type);
163:
164: PROCEDURE lock_option_val_rules(
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_ovdv_tbl IN ovdv_tbl_type);

Line 174: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

170: p_ovdv_tbl IN ovdv_tbl_type);
171:
172: PROCEDURE lock_option_val_rules(
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2,
178: p_ovdv_rec IN ovdv_rec_type);

Line 182: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

178: p_ovdv_rec IN ovdv_rec_type);
179:
180: PROCEDURE update_option_val_rules(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_ovdv_tbl IN ovdv_tbl_type,

Line 191: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

187: x_ovdv_tbl OUT NOCOPY ovdv_tbl_type);
188:
189: PROCEDURE update_option_val_rules(
190: p_api_version IN NUMBER,
191: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,
194: x_msg_data OUT NOCOPY VARCHAR2,
195: p_ovdv_rec IN ovdv_rec_type,

Line 200: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

196: x_ovdv_rec OUT NOCOPY ovdv_rec_type);
197:
198: PROCEDURE delete_option_val_rules(
199: p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
201: x_return_status OUT NOCOPY VARCHAR2,
202: x_msg_count OUT NOCOPY NUMBER,
203: x_msg_data OUT NOCOPY VARCHAR2,
204: p_ovdv_tbl IN ovdv_tbl_type);

Line 208: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

204: p_ovdv_tbl IN ovdv_tbl_type);
205:
206: PROCEDURE delete_option_val_rules(
207: p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2,
212: p_ovdv_rec IN ovdv_rec_type);

Line 216: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

212: p_ovdv_rec IN ovdv_rec_type);
213:
214: PROCEDURE validate_option_val_rules(
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,
219: x_msg_data OUT NOCOPY VARCHAR2,
220: p_ovdv_tbl IN ovdv_tbl_type);

Line 224: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

220: p_ovdv_tbl IN ovdv_tbl_type);
221:
222: PROCEDURE validate_option_val_rules(
223: p_api_version IN NUMBER,
224: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,
227: x_msg_data OUT NOCOPY VARCHAR2,
228: p_ovdv_rec IN ovdv_rec_type);