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_TRANSACTION_PVT dependencies on OKC_K_HEADERS_V

Line 144: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

140: PROCEDURE populate_transaction_rec(
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
145: p_new_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
146: p_reason_code IN VARCHAR2,
147: p_description IN VARCHAR2,
148: p_trx_date IN DATE,

Line 145: p_new_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
145: p_new_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
146: p_reason_code IN VARCHAR2,
147: p_description IN VARCHAR2,
148: p_trx_date IN DATE,
149: p_trx_type IN VARCHAR2,

Line 158: CURSOR con_header_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

154: l_id NUMBER;
155: l_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
156: l_org_id OKL_K_HEADERS_FULL_V.AUTHORING_ORG_ID%TYPE;
157:
158: CURSOR con_header_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
159: SELECT currency_code,
160: authoring_org_id
161: FROM okl_k_headers_full_v
162: WHERE id = p_chr_id;

Line 300: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

296: p_init_msg_list IN VARCHAR2,
297: x_return_status OUT NOCOPY VARCHAR2,
298: x_msg_count OUT NOCOPY NUMBER,
299: x_msg_data OUT NOCOPY VARCHAR2,
300: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
301: p_status IN VARCHAR2,
302: x_tcnv_rec OUT NOCOPY tcnv_rec_type
303: ) IS
304:

Line 309: CURSOR trx_csr(p_chr_id_new OKC_K_HEADERS_V.ID%TYPE) IS

305: l_api_name VARCHAR2(35) := 'update_trx_status';
306: l_proc_name VARCHAR2(35) := 'UPDATE_TRX_STATUS';
307: l_api_version CONSTANT NUMBER := 1;
308:
309: CURSOR trx_csr(p_chr_id_new OKC_K_HEADERS_V.ID%TYPE) IS
310: SELECT id
311: FROM OKL_TRX_CONTRACTS
312: WHERE khr_id_new = p_chr_id_new
313: --rkuttiya added for 12.1.1 Multi GAAP

Line 415: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

411: p_init_msg_list IN VARCHAR2,
412: x_return_status OUT NOCOPY VARCHAR2,
413: x_msg_count OUT NOCOPY NUMBER,
414: x_msg_data OUT NOCOPY VARCHAR2,
415: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
416: p_trx_date IN DATE
417: ) IS
418:
419: l_api_name VARCHAR2(35) := 'check_contract_securitized';

Line 488: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

484: p_init_msg_list IN VARCHAR2,
485: x_return_status OUT NOCOPY VARCHAR2,
486: x_msg_count OUT NOCOPY NUMBER,
487: x_msg_data OUT NOCOPY VARCHAR2,
488: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
489: p_cle_id IN OKC_K_LINES_V.ID%TYPE,
490: p_stream_type_class IN okl_strm_type_b.stream_type_subclass%TYPE,
491: p_trx_date IN DATE
492: ) IS

Line 562: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

558: p_init_msg_list IN VARCHAR2,
559: x_return_status OUT NOCOPY VARCHAR2,
560: x_msg_count OUT NOCOPY NUMBER,
561: x_msg_data OUT NOCOPY VARCHAR2,
562: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
563: p_new_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
564: p_reason_code IN VARCHAR2,
565: p_description IN VARCHAR2,
566: p_trx_date IN DATE,

Line 563: p_new_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

559: x_return_status OUT NOCOPY VARCHAR2,
560: x_msg_count OUT NOCOPY NUMBER,
561: x_msg_data OUT NOCOPY VARCHAR2,
562: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
563: p_new_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
564: p_reason_code IN VARCHAR2,
565: p_description IN VARCHAR2,
566: p_trx_date IN DATE,
567: p_trx_type IN VARCHAR2, -- 'REBOOK' or 'SPLIT'

Line 1156: p_lease_id IN OKC_K_HEADERS_V.ID%TYPE,

1152: p_init_msg_list IN VARCHAR2,
1153: x_return_status OUT NOCOPY VARCHAR2,
1154: x_msg_count OUT NOCOPY NUMBER,
1155: x_msg_data OUT NOCOPY VARCHAR2,
1156: p_lease_id IN OKC_K_HEADERS_V.ID%TYPE,
1157: p_service_id IN OKC_K_HEADERS_V.ID%TYPE,
1158: p_description IN VARCHAR2,
1159: p_trx_date IN DATE,
1160: p_status IN VARCHAR2,

Line 1157: p_service_id IN OKC_K_HEADERS_V.ID%TYPE,

1153: x_return_status OUT NOCOPY VARCHAR2,
1154: x_msg_count OUT NOCOPY NUMBER,
1155: x_msg_data OUT NOCOPY VARCHAR2,
1156: p_lease_id IN OKC_K_HEADERS_V.ID%TYPE,
1157: p_service_id IN OKC_K_HEADERS_V.ID%TYPE,
1158: p_description IN VARCHAR2,
1159: p_trx_date IN DATE,
1160: p_status IN VARCHAR2,
1161: x_tcnv_rec OUT NOCOPY tcnv_rec_type

Line 1177: CURSOR con_header_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

1173: FROM okl_trx_types_tl
1174: WHERE LANGUAGE = 'US'
1175: AND name = 'Service Integration';
1176:
1177: CURSOR con_header_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1178: SELECT currency_code,
1179: authoring_org_id
1180: FROM okl_k_headers_full_v
1181: WHERE id = p_chr_id;

Line 1362: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

1358: p_init_msg_list IN VARCHAR2,
1359: x_return_status OUT NOCOPY VARCHAR2,
1360: x_msg_count OUT NOCOPY NUMBER,
1361: x_msg_data OUT NOCOPY VARCHAR2,
1362: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1363: p_trx_date IN DATE,
1364: p_trx_type IN VARCHAR2,
1365: p_reason_code IN VARCHAR2,
1366: x_tcnv_rec OUT NOCOPY tcnv_rec_type

Line 1382: CURSOR con_header_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

1378: FROM okl_trx_types_tl
1379: WHERE LANGUAGE = 'US'
1380: AND name = 'Principal Paydown';
1381:
1382: CURSOR con_header_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1383: SELECT currency_code,
1384: authoring_org_id
1385: FROM okl_k_headers_full_v
1386: WHERE id = p_chr_id;