DBA Data[Home] [Help]

APPS.OKL_ACC_GEN_RULE_PVT dependencies on OKC_API

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

8: SUBTYPE aulv_tbl_type IS okl_aul_pvt.aulv_tbl_type;
9: ------------------------------------------------------------------------------
10: -- Global Variables
11: G_PKG_NAME CONSTANT VARCHAR2(200) := 'okl_acc_gen_rule_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_acc_gen_rule(
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_agrv_rec IN agrv_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_acc_gen_rule(
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_agrv_rec IN agrv_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_acc_gen_rule(
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_agrv_rec IN agrv_rec_type

Line 62: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

58:
59:
60: PROCEDURE create_acc_gen_rule(
61: p_api_version IN NUMBER,
62: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
63: x_return_status OUT NOCOPY VARCHAR2,
64: x_msg_count OUT NOCOPY NUMBER,
65: x_msg_data OUT NOCOPY VARCHAR2,
66: p_agrv_tbl IN agrv_tbl_type,

Line 71: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

67: x_agrv_tbl OUT NOCOPY agrv_tbl_type);
68:
69: PROCEDURE create_acc_gen_rule(
70: p_api_version IN NUMBER,
71: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
72: x_return_status OUT NOCOPY VARCHAR2,
73: x_msg_count OUT NOCOPY NUMBER,
74: x_msg_data OUT NOCOPY VARCHAR2,
75: p_agrv_rec IN agrv_rec_type,

Line 80: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

76: x_agrv_rec OUT NOCOPY agrv_rec_type);
77:
78: PROCEDURE lock_acc_gen_rule(
79: p_api_version IN NUMBER,
80: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
81: x_return_status OUT NOCOPY VARCHAR2,
82: x_msg_count OUT NOCOPY NUMBER,
83: x_msg_data OUT NOCOPY VARCHAR2,
84: p_agrv_tbl IN agrv_tbl_type);

Line 88: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

84: p_agrv_tbl IN agrv_tbl_type);
85:
86: PROCEDURE lock_acc_gen_rule(
87: p_api_version IN NUMBER,
88: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
89: x_return_status OUT NOCOPY VARCHAR2,
90: x_msg_count OUT NOCOPY NUMBER,
91: x_msg_data OUT NOCOPY VARCHAR2,
92: p_agrv_rec IN agrv_rec_type);

Line 96: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

92: p_agrv_rec IN agrv_rec_type);
93:
94: PROCEDURE update_acc_gen_rule(
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_agrv_tbl IN agrv_tbl_type,

Line 105: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

101: x_agrv_tbl OUT NOCOPY agrv_tbl_type);
102:
103: PROCEDURE update_acc_gen_rule(
104: p_api_version IN NUMBER,
105: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
106: x_return_status OUT NOCOPY VARCHAR2,
107: x_msg_count OUT NOCOPY NUMBER,
108: x_msg_data OUT NOCOPY VARCHAR2,
109: p_agrv_rec IN agrv_rec_type,

Line 114: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

110: x_agrv_rec OUT NOCOPY agrv_rec_type);
111:
112: PROCEDURE delete_acc_gen_rule(
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,
118: p_agrv_tbl IN agrv_tbl_type);

Line 122: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

118: p_agrv_tbl IN agrv_tbl_type);
119:
120: PROCEDURE delete_acc_gen_rule(
121: p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
123: x_return_status OUT NOCOPY VARCHAR2,
124: x_msg_count OUT NOCOPY NUMBER,
125: x_msg_data OUT NOCOPY VARCHAR2,
126: p_agrv_rec IN agrv_rec_type);

Line 130: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

126: p_agrv_rec IN agrv_rec_type);
127:
128: PROCEDURE validate_acc_gen_rule(
129: p_api_version IN NUMBER,
130: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
131: x_return_status OUT NOCOPY VARCHAR2,
132: x_msg_count OUT NOCOPY NUMBER,
133: x_msg_data OUT NOCOPY VARCHAR2,
134: p_agrv_tbl IN agrv_tbl_type);

Line 138: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

134: p_agrv_tbl IN agrv_tbl_type);
135:
136: PROCEDURE validate_acc_gen_rule(
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
139: x_return_status OUT NOCOPY VARCHAR2,
140: x_msg_count OUT NOCOPY NUMBER,
141: x_msg_data OUT NOCOPY VARCHAR2,
142: p_agrv_rec IN agrv_rec_type);

Line 147: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

143:
144:
145: PROCEDURE create_acc_gen_rule_lns(
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
148: x_return_status OUT NOCOPY VARCHAR2,
149: x_msg_count OUT NOCOPY NUMBER,
150: x_msg_data OUT NOCOPY VARCHAR2,
151: p_aulv_tbl IN aulv_tbl_type,

Line 156: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

152: x_aulv_tbl OUT NOCOPY aulv_tbl_type);
153:
154: PROCEDURE create_acc_gen_rule_lns(
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2,
160: p_aulv_rec IN aulv_rec_type,

Line 165: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

161: x_aulv_rec OUT NOCOPY aulv_rec_type);
162:
163: PROCEDURE lock_acc_gen_rule_lns(
164: p_api_version IN NUMBER,
165: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
166: x_return_status OUT NOCOPY VARCHAR2,
167: x_msg_count OUT NOCOPY NUMBER,
168: x_msg_data OUT NOCOPY VARCHAR2,
169: p_aulv_tbl IN aulv_tbl_type);

Line 173: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

169: p_aulv_tbl IN aulv_tbl_type);
170:
171: PROCEDURE lock_acc_gen_rule_lns(
172: p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2,
177: p_aulv_rec IN aulv_rec_type);

Line 181: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

177: p_aulv_rec IN aulv_rec_type);
178:
179: PROCEDURE update_acc_gen_rule_lns(
180: p_api_version IN NUMBER,
181: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
182: x_return_status OUT NOCOPY VARCHAR2,
183: x_msg_count OUT NOCOPY NUMBER,
184: x_msg_data OUT NOCOPY VARCHAR2,
185: p_aulv_tbl IN aulv_tbl_type,

Line 190: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

186: x_aulv_tbl OUT NOCOPY aulv_tbl_type);
187:
188: PROCEDURE update_acc_gen_rule_lns(
189: p_api_version IN NUMBER,
190: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
191: x_return_status OUT NOCOPY VARCHAR2,
192: x_msg_count OUT NOCOPY NUMBER,
193: x_msg_data OUT NOCOPY VARCHAR2,
194: p_aulv_rec IN aulv_rec_type,

Line 199: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

195: x_aulv_rec OUT NOCOPY aulv_rec_type);
196:
197: PROCEDURE delete_acc_gen_rule_lns(
198: p_api_version IN NUMBER,
199: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
200: x_return_status OUT NOCOPY VARCHAR2,
201: x_msg_count OUT NOCOPY NUMBER,
202: x_msg_data OUT NOCOPY VARCHAR2,
203: p_aulv_tbl IN aulv_tbl_type);

Line 207: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

203: p_aulv_tbl IN aulv_tbl_type);
204:
205: PROCEDURE delete_acc_gen_rule_lns(
206: p_api_version IN NUMBER,
207: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
208: x_return_status OUT NOCOPY VARCHAR2,
209: x_msg_count OUT NOCOPY NUMBER,
210: x_msg_data OUT NOCOPY VARCHAR2,
211: p_aulv_rec IN aulv_rec_type);

Line 215: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

211: p_aulv_rec IN aulv_rec_type);
212:
213: PROCEDURE validate_acc_gen_rule_lns(
214: p_api_version IN NUMBER,
215: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
216: x_return_status OUT NOCOPY VARCHAR2,
217: x_msg_count OUT NOCOPY NUMBER,
218: x_msg_data OUT NOCOPY VARCHAR2,
219: p_aulv_tbl IN aulv_tbl_type);

Line 223: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

219: p_aulv_tbl IN aulv_tbl_type);
220:
221: PROCEDURE validate_acc_gen_rule_lns(
222: p_api_version IN NUMBER,
223: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
224: x_return_status OUT NOCOPY VARCHAR2,
225: x_msg_count OUT NOCOPY NUMBER,
226: x_msg_data OUT NOCOPY VARCHAR2,
227: p_aulv_rec IN aulv_rec_type);