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_CPY_PDT_RULS_PVT dependencies on OKC_RULE_PUB

Line 9: ) RETURN OKC_RULE_PUB.rulv_rec_type IS

5: --------------------------------------------------------------------------------
6: FUNCTION get_rulv_rec (
7: p_rul_id IN NUMBER,
8: x_no_data_found OUT NOCOPY BOOLEAN
9: ) RETURN OKC_RULE_PUB.rulv_rec_type IS
10: CURSOR okc_rulv_csr (p_id IN NUMBER) IS
11: SELECT
12: ID,
13: OBJECT_VERSION_NUMBER,

Line 76: l_rulv_rec OKC_RULE_PUB.rulv_rec_type;

72: DISPLAY_SEQUENCE
73: FROM Okc_Rules_V
74: WHERE okc_rules_v.id = p_id;
75:
76: l_rulv_rec OKC_RULE_PUB.rulv_rec_type;
77: --
78: l_proc varchar2(72) := g_pkg_name||'get_rec';
79: --
80: BEGIN

Line 258: p_rulv_rec IN OKC_RULE_PUB.rulv_rec_type,

254: x_return_status OUT NOCOPY VARCHAR2,
255: x_msg_count OUT NOCOPY NUMBER,
256: x_msg_data OUT NOCOPY VARCHAR2,
257: p_khr_id IN NUMBER,
258: p_rulv_rec IN OKC_RULE_PUB.rulv_rec_type,
259: p_rgd_code IN OKL_OPT_RULES.rgr_rgd_code%TYPE,
260: p_rdf_code IN OKL_OPT_RULES.rgr_rdf_code%TYPE,
261: p_copy_or_enter_flag IN OKL_OPV_RULES.copy_or_enter_flag%TYPE) IS
262:

Line 289: l_rgpv_rec OKC_RULE_PUB.rgpv_rec_type;

285: and rul.rule_information_category = p_rdf_code;
286:
287: l_rul_id OKC_RULES_B.ID%TYPE default Null;
288:
289: l_rgpv_rec OKC_RULE_PUB.rgpv_rec_type;
290: l_rgpv_rec_out OKC_RULE_PUB.rgpv_rec_type;
291: l_rulv_rec OKC_RULE_PUB.rulv_rec_type;
292: l_rulv_rec_out OKC_RULE_PUB.rulv_rec_type;
293:

Line 290: l_rgpv_rec_out OKC_RULE_PUB.rgpv_rec_type;

286:
287: l_rul_id OKC_RULES_B.ID%TYPE default Null;
288:
289: l_rgpv_rec OKC_RULE_PUB.rgpv_rec_type;
290: l_rgpv_rec_out OKC_RULE_PUB.rgpv_rec_type;
291: l_rulv_rec OKC_RULE_PUB.rulv_rec_type;
292: l_rulv_rec_out OKC_RULE_PUB.rulv_rec_type;
293:
294: Begin

Line 291: l_rulv_rec OKC_RULE_PUB.rulv_rec_type;

287: l_rul_id OKC_RULES_B.ID%TYPE default Null;
288:
289: l_rgpv_rec OKC_RULE_PUB.rgpv_rec_type;
290: l_rgpv_rec_out OKC_RULE_PUB.rgpv_rec_type;
291: l_rulv_rec OKC_RULE_PUB.rulv_rec_type;
292: l_rulv_rec_out OKC_RULE_PUB.rulv_rec_type;
293:
294: Begin
295: --call start activity to set savepoint

Line 292: l_rulv_rec_out OKC_RULE_PUB.rulv_rec_type;

288:
289: l_rgpv_rec OKC_RULE_PUB.rgpv_rec_type;
290: l_rgpv_rec_out OKC_RULE_PUB.rgpv_rec_type;
291: l_rulv_rec OKC_RULE_PUB.rulv_rec_type;
292: l_rulv_rec_out OKC_RULE_PUB.rulv_rec_type;
293:
294: Begin
295: --call start activity to set savepoint
296: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),

Line 317: okc_rule_pub.create_rule_group(

313: l_rgpv_rec.rgd_code := p_rgd_code;
314: l_rgpv_rec.chr_id := p_khr_id;
315: l_rgpv_rec.dnz_chr_id := p_khr_id;
316: l_rgpv_rec.rgp_type := 'KRG';
317: okc_rule_pub.create_rule_group(
318: p_api_version => p_api_version,
319: p_init_msg_list => p_init_msg_list,
320: x_return_status => x_return_status,
321: x_msg_count => x_msg_count,

Line 340: okc_rule_pub.create_rule(

336: l_rulv_rec.rgp_id := l_rgpv_rec_out.id;
337: l_rulv_rec.template_yn := Null; --this rule will no longer be template
338: l_rulv_rec.dnz_chr_id := p_khr_id;
339: l_rulv_rec.std_template_yn := 'N';
340: okc_rule_pub.create_rule(
341: p_api_version => p_api_version,
342: p_init_msg_list => p_init_msg_list,
343: x_return_status => x_return_status,
344: x_msg_count => x_msg_count,

Line 376: okc_rule_pub.create_rule(

372: l_rulv_rec.template_yn := Null; --this rule will no longer be template
373: l_rulv_rec.dnz_chr_id := p_khr_id;
374: l_rulv_rec.std_template_yn := 'N';
375:
376: okc_rule_pub.create_rule(
377: p_api_version => p_api_version,
378: p_init_msg_list => p_init_msg_list,
379: x_return_status => x_return_status,
380: x_msg_count => x_msg_count,

Line 444: p_rulv_rec IN OKC_RULE_PUB.rulv_rec_type,

440: x_return_status OUT NOCOPY VARCHAR2,
441: x_msg_count OUT NOCOPY NUMBER,
442: x_msg_data OUT NOCOPY VARCHAR2,
443: p_khr_id IN NUMBER,
444: p_rulv_rec IN OKC_RULE_PUB.rulv_rec_type,
445: p_rgd_code IN OKL_OPT_RULES.rgr_rgd_code%TYPE,
446: p_rdf_code IN OKL_OPT_RULES.rgr_rdf_code%TYPE,
447: p_lse_id IN OKL_OPT_RULES.lrg_lse_id%TYPE,
448: p_copy_or_enter_flag IN OKL_OPV_RULES.copy_or_enter_flag%TYPE) IS

Line 492: l_rgpv_rec OKC_RULE_PUB.rgpv_rec_type;

488: and rul.rule_information_category = p_rdf_code;
489:
490: l_rul_id OKC_RULES_B.ID%TYPE default Null;
491:
492: l_rgpv_rec OKC_RULE_PUB.rgpv_rec_type;
493: l_rgpv_rec_out OKC_RULE_PUB.rgpv_rec_type;
494:
495: l_rulv_rec OKC_RULE_PUB.rulv_rec_type;
496: l_rulv_rec_out OKC_RULE_PUB.rulv_rec_type;

Line 493: l_rgpv_rec_out OKC_RULE_PUB.rgpv_rec_type;

489:
490: l_rul_id OKC_RULES_B.ID%TYPE default Null;
491:
492: l_rgpv_rec OKC_RULE_PUB.rgpv_rec_type;
493: l_rgpv_rec_out OKC_RULE_PUB.rgpv_rec_type;
494:
495: l_rulv_rec OKC_RULE_PUB.rulv_rec_type;
496: l_rulv_rec_out OKC_RULE_PUB.rulv_rec_type;
497:

Line 495: l_rulv_rec OKC_RULE_PUB.rulv_rec_type;

491:
492: l_rgpv_rec OKC_RULE_PUB.rgpv_rec_type;
493: l_rgpv_rec_out OKC_RULE_PUB.rgpv_rec_type;
494:
495: l_rulv_rec OKC_RULE_PUB.rulv_rec_type;
496: l_rulv_rec_out OKC_RULE_PUB.rulv_rec_type;
497:
498: Begin
499: --call start activity to set savepoint

Line 496: l_rulv_rec_out OKC_RULE_PUB.rulv_rec_type;

492: l_rgpv_rec OKC_RULE_PUB.rgpv_rec_type;
493: l_rgpv_rec_out OKC_RULE_PUB.rgpv_rec_type;
494:
495: l_rulv_rec OKC_RULE_PUB.rulv_rec_type;
496: l_rulv_rec_out OKC_RULE_PUB.rulv_rec_type;
497:
498: Begin
499: --call start activity to set savepoint
500: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),

Line 532: okc_rule_pub.create_rule_group(

528: l_rgpv_rec.cle_id := l_kle_id;
529: l_rgpv_rec.dnz_chr_id := p_khr_id;
530: l_rgpv_rec.rgp_type := 'KRG';
531:
532: okc_rule_pub.create_rule_group(
533: p_api_version => p_api_version,
534: p_init_msg_list => p_init_msg_list,
535: x_return_status => x_return_status,
536: x_msg_count => x_msg_count,

Line 556: okc_rule_pub.create_rule(

552: l_rulv_rec.template_yn := Null; --this rule will no longer be template
553: l_rulv_rec.dnz_chr_id := p_khr_id;
554: l_rulv_rec.std_template_yn := 'N';
555:
556: okc_rule_pub.create_rule(
557: p_api_version => p_api_version,
558: p_init_msg_list => p_init_msg_list,
559: x_return_status => x_return_status,
560: x_msg_count => x_msg_count,

Line 590: okc_rule_pub.create_rule(

586: l_rulv_rec.template_yn := Null; --this rule will no longer be template
587: l_rulv_rec.dnz_chr_id := p_khr_id;
588: l_rulv_rec.std_template_yn := 'N';
589:
590: okc_rule_pub.create_rule(
591: p_api_version => p_api_version,
592: p_init_msg_list => p_init_msg_list,
593: x_return_status => x_return_status,
594: x_msg_count => x_msg_count,

Line 792: l_rulv_rec OKC_RULE_PUB.rulv_rec_type;

788:
789:
790: l_opt_ruls_kle_rec l_opt_ruls_kle_csr%ROWTYPE;
791:
792: l_rulv_rec OKC_RULE_PUB.rulv_rec_type;
793: l_no_data_found Boolean Default TRUE;
794:
795: BEGIN
796: --call start activity to set savepoint