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_PROCESS_STREAMS_PVT dependencies on OKC_K_HEADERS_B

Line 127: okc_k_headers_b chr,

123: IS
124: cursor k_line_id_csr(p_khr_id NUMBER) is
125: select cle.id kle_id
126: from
127: okc_k_headers_b chr,
128: okc_k_lines_b cle,
129: okc_line_styles_b lse,
130: okc_k_items cim,
131: okl_strm_type_b sty

Line 150: OKC_K_HEADERS_B KHRB,

146: CRLB.OBJECT1_ID1 STY_ID,
147: CRGB.ID RULE_GROUP_ID,
148: CRLB.ID SLH_ID
149: FROM
150: OKC_K_HEADERS_B KHRB,
151: OKC_RULE_GROUPS_B CRGB,
152: OKC_RULES_B CRLB,
153: OKC_K_LINES_V KLIN,
154: OKL_STRM_TYPE_B STYB

Line 381: OKC_K_HEADERS_B KHRB,

377: CRLB.OBJECT1_ID1 STY_ID,
378: CRGB.ID RULE_GROUP_ID,
379: CRLB.ID SLH_ID
380: FROM
381: OKC_K_HEADERS_B KHRB,
382: OKC_RULE_GROUPS_B CRGB,
383: OKC_RULES_B CRLB,
384: OKC_K_LINES_V KLIN,
385: OKC_LINE_STYLES_V LSTL

Line 1028: CURSOR get_org_id(p_chr_id okc_k_headers_b.id%TYPE)

1024: exception_data exception_data_csr%ROWTYPE;
1025:
1026: l_msg_index_out NUMBER;
1027: -- Bug 4196515: Start
1028: CURSOR get_org_id(p_chr_id okc_k_headers_b.id%TYPE)
1029: IS
1030: SELECT authoring_org_id,
1031: currency_code
1032: FROM okc_k_headers_b

Line 1032: FROM okc_k_headers_b

1028: CURSOR get_org_id(p_chr_id okc_k_headers_b.id%TYPE)
1029: IS
1030: SELECT authoring_org_id,
1031: currency_code
1032: FROM okc_k_headers_b
1033: WHERE id = p_chr_id;
1034:
1035: CURSOR get_precision(p_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE)
1036: IS

Line 1035: CURSOR get_precision(p_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE)

1031: currency_code
1032: FROM okc_k_headers_b
1033: WHERE id = p_chr_id;
1034:
1035: CURSOR get_precision(p_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE)
1036: IS
1037: SELECT PRECISION
1038: FROM fnd_currencies_vl
1039: WHERE currency_code = p_currency_code

Line 1059: CURSOR SERVICE_LINES_EXIST(P_KHR_ID OKC_K_HEADERS_B.ID%TYPE)

1055: AND a.lookup_code = b.stm_apply_rounding_difference;
1056:
1057: --Added by KTHIRUVA for ESG Performance Imporvement on 03-May-2005
1058: --Bug 4346646 - Start of Changes
1059: CURSOR SERVICE_LINES_EXIST(P_KHR_ID OKC_K_HEADERS_B.ID%TYPE)
1060: IS
1061: SELECT 1
1062: FROM OKC_K_HEADERS_B KHR,
1063: OKC_K_LINES_B CLE,

Line 1062: FROM OKC_K_HEADERS_B KHR,

1058: --Bug 4346646 - Start of Changes
1059: CURSOR SERVICE_LINES_EXIST(P_KHR_ID OKC_K_HEADERS_B.ID%TYPE)
1060: IS
1061: SELECT 1
1062: FROM OKC_K_HEADERS_B KHR,
1063: OKC_K_LINES_B CLE,
1064: OKC_LINE_STYLES_B LSE
1065: WHERE CLE.CHR_ID = KHR.ID
1066: AND KHR.ID = p_khr_id

Line 1073: l_org_id okc_k_headers_b.authoring_org_id%TYPE;

1069:
1070: l_service_line_found NUMBER;
1071: --Bug 4346646 - End of Changes
1072:
1073: l_org_id okc_k_headers_b.authoring_org_id%TYPE;
1074: l_currency_code okc_k_headers_b.currency_code%TYPE;
1075: l_diff_lookup_code fnd_lookups.lookup_code%TYPE;
1076: l_precision NUMBER;
1077: l_rounding_rule okl_sys_acct_opts.ael_rounding_rule%TYPE;

Line 1074: l_currency_code okc_k_headers_b.currency_code%TYPE;

1070: l_service_line_found NUMBER;
1071: --Bug 4346646 - End of Changes
1072:
1073: l_org_id okc_k_headers_b.authoring_org_id%TYPE;
1074: l_currency_code okc_k_headers_b.currency_code%TYPE;
1075: l_diff_lookup_code fnd_lookups.lookup_code%TYPE;
1076: l_precision NUMBER;
1077: l_rounding_rule okl_sys_acct_opts.ael_rounding_rule%TYPE;
1078: l_first_rec CHAR := 'T';