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 311: CURSOR trx_csr(p_chr_id_new OKC_K_HEADERS_V.ID%TYPE) IS

307: l_api_version CONSTANT NUMBER := 1;
308:
309: -- Bug# 9851889
310: -- Modified cursor to pick up Rebook and Re-lease Contract transactions
311: CURSOR trx_csr(p_chr_id_new OKC_K_HEADERS_V.ID%TYPE) IS
312: SELECT trx.id, trx.representation_type --sechawla 01-oct-09 8967918 : added representation type
313: FROM okl_trx_contracts trx,
314: okl_trx_types_tl try
315: WHERE trx.khr_id_new = p_chr_id_new

Line 440: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

436: p_init_msg_list IN VARCHAR2,
437: x_return_status OUT NOCOPY VARCHAR2,
438: x_msg_count OUT NOCOPY NUMBER,
439: x_msg_data OUT NOCOPY VARCHAR2,
440: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
441: p_trx_date IN DATE
442: ) IS
443:
444: l_api_name VARCHAR2(35) := 'check_contract_securitized';

Line 513: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

509: p_init_msg_list IN VARCHAR2,
510: x_return_status OUT NOCOPY VARCHAR2,
511: x_msg_count OUT NOCOPY NUMBER,
512: x_msg_data OUT NOCOPY VARCHAR2,
513: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
514: p_cle_id IN OKC_K_LINES_V.ID%TYPE,
515: p_stream_type_class IN okl_strm_type_b.stream_type_subclass%TYPE,
516: p_trx_date IN DATE
517: ) IS

Line 587: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

583: p_init_msg_list IN VARCHAR2,
584: x_return_status OUT NOCOPY VARCHAR2,
585: x_msg_count OUT NOCOPY NUMBER,
586: x_msg_data OUT NOCOPY VARCHAR2,
587: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
588: p_new_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
589: p_reason_code IN VARCHAR2,
590: p_description IN VARCHAR2,
591: p_trx_date IN DATE,

Line 588: p_new_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

584: x_return_status OUT NOCOPY VARCHAR2,
585: x_msg_count OUT NOCOPY NUMBER,
586: x_msg_data OUT NOCOPY VARCHAR2,
587: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
588: p_new_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
589: p_reason_code IN VARCHAR2,
590: p_description IN VARCHAR2,
591: p_trx_date IN DATE,
592: p_trx_type IN VARCHAR2, -- 'REBOOK' or 'SPLIT'

Line 1195: p_lease_id IN OKC_K_HEADERS_V.ID%TYPE,

1191: p_init_msg_list IN VARCHAR2,
1192: x_return_status OUT NOCOPY VARCHAR2,
1193: x_msg_count OUT NOCOPY NUMBER,
1194: x_msg_data OUT NOCOPY VARCHAR2,
1195: p_lease_id IN OKC_K_HEADERS_V.ID%TYPE,
1196: p_service_id IN OKC_K_HEADERS_V.ID%TYPE,
1197: p_description IN VARCHAR2,
1198: p_trx_date IN DATE,
1199: p_status IN VARCHAR2,

Line 1196: p_service_id IN OKC_K_HEADERS_V.ID%TYPE,

1192: x_return_status OUT NOCOPY VARCHAR2,
1193: x_msg_count OUT NOCOPY NUMBER,
1194: x_msg_data OUT NOCOPY VARCHAR2,
1195: p_lease_id IN OKC_K_HEADERS_V.ID%TYPE,
1196: p_service_id IN OKC_K_HEADERS_V.ID%TYPE,
1197: p_description IN VARCHAR2,
1198: p_trx_date IN DATE,
1199: p_status IN VARCHAR2,
1200: x_tcnv_rec OUT NOCOPY tcnv_rec_type

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

1212: FROM okl_trx_types_tl
1213: WHERE LANGUAGE = 'US'
1214: AND name = 'Service Integration';
1215:
1216: CURSOR con_header_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1217: SELECT currency_code,
1218: authoring_org_id
1219: FROM okl_k_headers_full_v
1220: WHERE id = p_chr_id;

Line 1401: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

1397: p_init_msg_list IN VARCHAR2,
1398: x_return_status OUT NOCOPY VARCHAR2,
1399: x_msg_count OUT NOCOPY NUMBER,
1400: x_msg_data OUT NOCOPY VARCHAR2,
1401: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1402: p_trx_date IN DATE,
1403: p_trx_type IN VARCHAR2,
1404: p_reason_code IN VARCHAR2,
1405: x_tcnv_rec OUT NOCOPY tcnv_rec_type

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

1417: FROM okl_trx_types_tl
1418: WHERE LANGUAGE = 'US'
1419: AND name = 'Principal Paydown';
1420:
1421: CURSOR con_header_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1422: SELECT currency_code,
1423: authoring_org_id
1424: FROM okl_k_headers_full_v
1425: WHERE id = p_chr_id;