APPS.OKL_TRANSACTION_PVT dependencies on OKC_K_HEADERS_B

Line 42: FROM OKC_K_HEADERS_B

38: ------------------------------------------------------------------------------
39: --Added by dpsingh for LE uptake
40: CURSOR contract_num_csr (p_ctr_id1 NUMBER) IS
41: SELECT contract_number
42: FROM OKC_K_HEADERS_B
43: WHERE id = p_ctr_id1;
44:
45: PROCEDURE Report_Error(
46: x_msg_count OUT NOCOPY NUMBER,

Line 174: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

170: 'Error');
171: populate_failed EXCEPTION;
172:
173: --Added by dpsingh for LE uptake
174: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
175: l_legal_entity_id NUMBER;
176:
177: BEGIN
178: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 578: CURSOR con_eff_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

574:
575: l_tcnv_rec tcnv_rec_type;
576: l_out_tcnv_rec tcnv_rec_type;
577:
578: CURSOR con_eff_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
579: SELECT start_date,
580: end_date
581: FROM okc_k_headers_b
582: WHERE id = p_chr_id;

Line 581: FROM okc_k_headers_b

577:
578: CURSOR con_eff_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
579: SELECT start_date,
580: end_date
581: FROM okc_k_headers_b
582: WHERE id = p_chr_id;
583:
584: CURSOR check_date_csr (p_start_date DATE,
585: p_end_date DATE,

Line 614: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

610: AND trx.tas_type = 'ALG'
611: AND trx.id = itm.tas_id ;
612:
613: l_rebook_allowed VARCHAR2(1) := 'Y';
614: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
615: --akrangan end
616: /*
617: -- mvasudev, 08/30/2004
618: -- Added PROCEDURE to enable Business Event

Line 1186: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

1182:
1183: l_try_id NUMBER;
1184: service_txn_failed EXCEPTION;
1185: --Added by dpsingh for LE Uptake
1186: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1187: l_legal_entity_id NUMBER;
1188:
1189: BEGIN -- main process begins here
1190: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 1391: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

1387:
1388: l_try_id NUMBER;
1389: ppd_txn_failed EXCEPTION;
1390: --Added by dpsingh for LE Uptake
1391: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1392: l_legal_entity_id NUMBER;
1393:
1394: BEGIN -- main process begins here
1395: IF (G_DEBUG_ENABLED = 'Y') THEN