APPS.OKL_CREATE_ADJST_PVT dependencies on OKL_TXL_ADJSTS_LNS_B

Line 48: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;

44:
45: l_type CONSTANT AR_ADJUSTMENTS.TYPE%TYPE := 'INVOICE';
46: l_created_from CONSTANT AR_ADJUSTMENTS.CREATED_FROM%TYPE := 'ADJ-API';
47:
48: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;
49: l_new_adj_id OKL_TXL_ADJSTS_LNS_B.RECEIVABLES_ADJUSTMENT_ID%TYPE;
50:
51: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;
52: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;

Line 49: l_new_adj_id OKL_TXL_ADJSTS_LNS_B.RECEIVABLES_ADJUSTMENT_ID%TYPE;

45: l_type CONSTANT AR_ADJUSTMENTS.TYPE%TYPE := 'INVOICE';
46: l_created_from CONSTANT AR_ADJUSTMENTS.CREATED_FROM%TYPE := 'ADJ-API';
47:
48: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;
49: l_new_adj_id OKL_TXL_ADJSTS_LNS_B.RECEIVABLES_ADJUSTMENT_ID%TYPE;
50:
51: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;
52: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
53: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;

Line 362: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;

358:
359: l_type CONSTANT AR_ADJUSTMENTS.TYPE%TYPE := 'INVOICE';
360: l_created_from CONSTANT AR_ADJUSTMENTS.CREATED_FROM%TYPE := 'ADJ-API';
361:
362: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;
363: l_new_adj_id OKL_TXL_ADJSTS_LNS_B.RECEIVABLES_ADJUSTMENT_ID%TYPE;
364:
365: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;
366: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;

Line 363: l_new_adj_id OKL_TXL_ADJSTS_LNS_B.RECEIVABLES_ADJUSTMENT_ID%TYPE;

359: l_type CONSTANT AR_ADJUSTMENTS.TYPE%TYPE := 'INVOICE';
360: l_created_from CONSTANT AR_ADJUSTMENTS.CREATED_FROM%TYPE := 'ADJ-API';
361:
362: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;
363: l_new_adj_id OKL_TXL_ADJSTS_LNS_B.RECEIVABLES_ADJUSTMENT_ID%TYPE;
364:
365: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;
366: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
367: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;

Line 655: -- Create adjusment line record in okl_txl_adjsts_lns_b

651: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
652: RAISE OKL_API.G_EXCEPTION_ERROR;
653: END IF;
654:
655: -- Create adjusment line record in okl_txl_adjsts_lns_b
656: l_ajlv_rec.adj_id := x_adjv_rec.id;
657: l_ajlv_rec.psl_id := p_psl_id;
658: l_ajlv_rec.amount := c_pmnt_schedule_dtls_rec.amount_due_remaining;
659: l_ajlv_rec.til_id := c_pmnt_schedule_dtls_rec.til_id;

Line 774: l_dist_info_tbl(1).source_table := 'OKL_TXL_ADJSTS_LNS_B';

770: l_tmpl_identify_tbl(1).stream_type_id := c_pmnt_schedule_dtls_rec.stream_type_id;
771:
772: -- Set the dist_info_rec in parameter
773: l_dist_info_tbl(1).source_id := x_ajlv_rec.id;
774: l_dist_info_tbl(1).source_table := 'OKL_TXL_ADJSTS_LNS_B';
775: l_dist_info_tbl(1).accounting_date := SYSDATE;
776: l_dist_info_tbl(1).gl_reversal_flag := G_NO;
777: l_dist_info_tbl(1).post_to_gl := G_NO;
778: l_dist_info_tbl(1).contract_id := c_pmnt_schedule_dtls_rec.contract_id;

Line 863: OPEN c_code_combination_id(x_ajlv_rec.id, 'OKL_TXL_ADJSTS_LNS_B');

859: CLOSE get_account_derivation_meth;
860:
861: IF l_account_derivation = 'ATS' THEN
862: -- Get the code_combination_id for the transaction
863: OPEN c_code_combination_id(x_ajlv_rec.id, 'OKL_TXL_ADJSTS_LNS_B');
864: FETCH c_code_combination_id INTO l_code_combination_id;
865: CLOSE c_code_combination_id;
866:
867: IF l_code_combination_id = -1 OR l_code_combination_id IS NULL THEN

Line 875: -- Update adjusment line record in okl_txl_adjsts_lns_b with CCID

871: p_token1_value => l_contract_number);
872: RAISE OKL_API.G_EXCEPTION_ERROR;
873: END IF;
874:
875: -- Update adjusment line record in okl_txl_adjsts_lns_b with CCID
876: l_ajlv_rec := l_ajlv_new_rec; -- Empty the rec
877:
878: -- Set the rec with CCID got from accounting distibutions
879: l_ajlv_rec.id := x_ajlv_rec.id;