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_RULE_EXTRACT_PVT dependencies on OKC_API

Line 382: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

378:
379: l_value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE Default Null;
380: l_additional_columns FND_FLEX_VALIDATION_TABLES.ADDITIONAL_QUICKPICK_COLUMNS%TYPE Default Null;
381:
382: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
383: l_api_name CONSTANT VARCHAR2(30) := 'GET_RULE_DEF';
384: l_api_version CONSTANT NUMBER := 1.0;
385: -- udhenuko Added the variable to capture the enabled flag for the rule
386: l_rule_enabled_flag FND_DESCR_FLEX_COLUMN_USAGES.SECURITY_ENABLED_FLAG%TYPE Default 'N';

Line 476: RAISE OKC_API.G_EXCEPTION_ERROR;

472:
473: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
474: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
475: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
476: RAISE OKC_API.G_EXCEPTION_ERROR;
477: END IF;
478:
479: Elsif l_segments_r.application_column_name(i) like 'RULE%' Then
480: --Get Query from Flex Values

Line 503: RAISE OKC_API.G_EXCEPTION_ERROR;

499:
500: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
501: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
502: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
503: RAISE OKC_API.G_EXCEPTION_ERROR;
504: END IF;
505: End If;
506: End If;
507: l_rule_segment_tbl(i).rgd_code := p_rgd_code;

Line 625: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

621: jtot_ref_curs jtot_ref_curs_type;
622: Type rule_ref_curs_type is REF CURSOR;
623: rule_ref_curs jtot_ref_curs_type;
624:
625: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
626: l_api_name CONSTANT VARCHAR2(30) := 'GET_NAME_VALUES';
627: l_api_version CONSTANT NUMBER := 1.0;
628:
629: Begin

Line 781: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

777: l_rulv_rec HEADER_RULE_CSR%ROWTYPE;
778:
779: i number := 0;
780:
781: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
782: l_api_name CONSTANT VARCHAR2(30) := 'GET_RULE_DEF';
783: l_api_version CONSTANT NUMBER := 1.0;
784:
785: Begin

Line 802: if(l_chr_id is null or l_chr_id = OKC_API.G_MISS_NUM) then

798: RAISE OKL_API.G_EXCEPTION_ERROR;
799: END IF;
800:
801:
802: if(l_chr_id is null or l_chr_id = OKC_API.G_MISS_NUM) then
803: l_chr_id := -1;
804: end if;
805: if(l_line_id is null or l_line_id = OKC_API.G_MISS_NUM) then
806: l_line_id := -1;

Line 805: if(l_line_id is null or l_line_id = OKC_API.G_MISS_NUM) then

801:
802: if(l_chr_id is null or l_chr_id = OKC_API.G_MISS_NUM) then
803: l_chr_id := -1;
804: end if;
805: if(l_line_id is null or l_line_id = OKC_API.G_MISS_NUM) then
806: l_line_id := -1;
807: end if;
808: if(l_cpl_id is null or l_cpl_id = OKC_API.G_MISS_NUM) then
809: l_cpl_id := -1;

Line 808: if(l_cpl_id is null or l_cpl_id = OKC_API.G_MISS_NUM) then

804: end if;
805: if(l_line_id is null or l_line_id = OKC_API.G_MISS_NUM) then
806: l_line_id := -1;
807: end if;
808: if(l_cpl_id is null or l_cpl_id = OKC_API.G_MISS_NUM) then
809: l_cpl_id := -1;
810: end if;
811: if(l_chr_id = -1 and l_cpl_id = -1 and l_line_id = -1) then
812: process_type := 'TEMPLATE';

Line 847: RAISE OKC_API.G_EXCEPTION_ERROR;

843:
844: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
845: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
846: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
847: RAISE OKC_API.G_EXCEPTION_ERROR;
848: END IF;
849:
850:
851:

Line 953: RAISE OKC_API.G_EXCEPTION_ERROR;

949:
950: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
951: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
952: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
953: RAISE OKC_API.G_EXCEPTION_ERROR;
954: END IF;
955: end if;
956: else
957: if(l_rule_segment_tbl2(i).value_set_name = 'FND_STANDARD_DATE' and

Line 1039: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1035: and chrv.id = p_chr_id;
1036: l_scs_rgd_rec scs_rgd_curs%rowtype;
1037: i NUMBER;
1038:
1039: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1040: l_api_name CONSTANT VARCHAR2(30) := 'GET_SUBCLASS_RGS';
1041: l_api_version CONSTANT NUMBER := 1.0;
1042:
1043: begin

Line 1199: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1195: l_rg_rules_tbl rg_rules_tbl_type;
1196: l_segment_count Number;
1197: i Number;
1198:
1199: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1200: l_api_name CONSTANT VARCHAR2(30) := 'GET_RG_RULES';
1201: l_api_version CONSTANT NUMBER := 1.0;
1202:
1203: begin

Line 1232: RAISE OKC_API.G_EXCEPTION_ERROR;

1228:
1229: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1230: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1231: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1232: RAISE OKC_API.G_EXCEPTION_ERROR;
1233: END IF;
1234:
1235: For i in 1..l_segment_count
1236: Loop