eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_RGRP_RULES_PROCESS_PVT dependencies on OKC_RULE_GROUPS_B

Line 232: RETURN OKC_RULE_GROUPS_B.ID%TYPE IS

228: x_msg_count OUT NOCOPY NUMBER,
229: x_msg_data OUT NOCOPY VARCHAR2,
230: p_chr_id IN NUMBER,
231: p_rgr_rec IN rgr_rec_type)
232: RETURN OKC_RULE_GROUPS_B.ID%TYPE IS
233: i NUMBER := 0;
234: j NUMBER;
235: rule_group_id NUMBER := null;
236: l_rgr_rec rgr_rec_type := p_rgr_rec;

Line 238: SELECT ID FROM OKC_RULE_GROUPS_B

234: j NUMBER;
235: rule_group_id NUMBER := null;
236: l_rgr_rec rgr_rec_type := p_rgr_rec;
237: cursor RULE_GROUP_CSR(P_CHR_ID IN NUMBER, P_RGD_CODE IN VARCHAR2) is
238: SELECT ID FROM OKC_RULE_GROUPS_B
239: WHERE CHR_ID = P_CHR_ID AND
240: DNZ_CHR_ID = P_CHR_ID AND
241: CLE_ID IS NULL AND
242: RGD_CODE = P_RGD_CODE;

Line 263: RETURN OKC_RULE_GROUPS_B.ID%TYPE IS

259: x_msg_count OUT NOCOPY NUMBER,
260: x_msg_data OUT NOCOPY VARCHAR2,
261: p_chr_id IN NUMBER,
262: p_rgd_code IN VARCHAR2)
263: RETURN OKC_RULE_GROUPS_B.ID%TYPE IS
264: rule_group_id NUMBER := null;
265: cursor RULE_GROUP_CSR(P_CHR_ID IN NUMBER, P_RGD_CODE IN VARCHAR2) is
266: SELECT ID FROM OKC_RULE_GROUPS_B
267: WHERE CHR_ID = P_CHR_ID AND

Line 266: SELECT ID FROM OKC_RULE_GROUPS_B

262: p_rgd_code IN VARCHAR2)
263: RETURN OKC_RULE_GROUPS_B.ID%TYPE IS
264: rule_group_id NUMBER := null;
265: cursor RULE_GROUP_CSR(P_CHR_ID IN NUMBER, P_RGD_CODE IN VARCHAR2) is
266: SELECT ID FROM OKC_RULE_GROUPS_B
267: WHERE CHR_ID = P_CHR_ID AND
268: DNZ_CHR_ID = P_CHR_ID AND
269: CLE_ID IS NULL AND
270: RGD_CODE = P_RGD_CODE;

Line 293: RETURN OKC_RULE_GROUPS_B.ID%TYPE IS

289: x_msg_data OUT NOCOPY VARCHAR2,
290: p_chr_id IN NUMBER,
291: p_line_id IN NUMBER,
292: p_rgr_rec IN rgr_rec_type)
293: RETURN OKC_RULE_GROUPS_B.ID%TYPE IS
294: i NUMBER := 0;
295: j NUMBER;
296: rule_group_id NUMBER := null;
297: l_rgr_rec rgr_rec_type := p_rgr_rec;

Line 300: SELECT ID FROM OKC_RULE_GROUPS_B

296: rule_group_id NUMBER := null;
297: l_rgr_rec rgr_rec_type := p_rgr_rec;
298: cursor RULE_GROUP_CSR(P_CHR_ID IN NUMBER, P_LINE_ID IN NUMBER,
299: P_RGD_CODE IN VARCHAR2) is
300: SELECT ID FROM OKC_RULE_GROUPS_B
301: WHERE CHR_ID IS NULL AND
302: DNZ_CHR_ID = P_CHR_ID AND
303: CLE_ID = P_LINE_ID AND
304: RGD_CODE = P_RGD_CODE;

Line 1271: l_terms_id okc_rule_groups_b.id%TYPE;

1267: -- sjalasut: aug 30, 04 added variables to support business events. BEGIN
1268:
1269: l_raise_business_event VARCHAR2(1);
1270: l_business_event_name wf_events.name%TYPE;
1271: l_terms_id okc_rule_groups_b.id%TYPE;
1272: l_parameter_list WF_PARAMETER_LIST_T;
1273: -- cursor to get the rule group id from the header.
1274: -- if the Lien Terms and Conditions are updated at the contract level, then the cle_id is null
1275: CURSOR get_header_terms_id (p_chr_id okc_k_headers_b.id%TYPE, p_rgd_code VARCHAR2) IS

Line 1277: FROM okc_rule_groups_b

1273: -- cursor to get the rule group id from the header.
1274: -- if the Lien Terms and Conditions are updated at the contract level, then the cle_id is null
1275: CURSOR get_header_terms_id (p_chr_id okc_k_headers_b.id%TYPE, p_rgd_code VARCHAR2) IS
1276: SELECT id
1277: FROM okc_rule_groups_b
1278: WHERE dnz_chr_id = p_chr_id AND
1279: rgd_code = p_rgd_code AND
1280: cle_id IS NULL ;
1281: