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_CREATE_ADJST_PVT dependencies on OKL_TXL_ADJSTS_LNS_B

Line 16: adjsts_lns_id okl_txl_adjsts_lns_b.ID%type,

12: ( APPLY_DATE okl_trx_ar_adjsts_b.APPLY_DATE%type,
13: GL_DATE okl_trx_ar_adjsts_b.GL_DATE%type,
14: ADJUSTMENT_REASON_CODE okl_trx_ar_adjsts_b.ADJUSTMENT_REASON_CODE%type,
15: COMMENTS okl_trx_ar_adjsts_tl.COMMENTS%type,
16: adjsts_lns_id okl_txl_adjsts_lns_b.ID%type,
17: payment_schedule_id okl_txl_adjsts_lns_b.PSL_ID%type,
18: AMOUNT okl_txl_adjsts_lns_b.AMOUNT%type,
19: CODE_COMBINATION_ID okl_txl_adjsts_lns_b.CODE_COMBINATION_ID%type,
20: customer_trx_id ra_customer_trx_all.customer_trx_id%type,

Line 17: payment_schedule_id okl_txl_adjsts_lns_b.PSL_ID%type,

13: GL_DATE okl_trx_ar_adjsts_b.GL_DATE%type,
14: ADJUSTMENT_REASON_CODE okl_trx_ar_adjsts_b.ADJUSTMENT_REASON_CODE%type,
15: COMMENTS okl_trx_ar_adjsts_tl.COMMENTS%type,
16: adjsts_lns_id okl_txl_adjsts_lns_b.ID%type,
17: payment_schedule_id okl_txl_adjsts_lns_b.PSL_ID%type,
18: AMOUNT okl_txl_adjsts_lns_b.AMOUNT%type,
19: CODE_COMBINATION_ID okl_txl_adjsts_lns_b.CODE_COMBINATION_ID%type,
20: customer_trx_id ra_customer_trx_all.customer_trx_id%type,
21: customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type

Line 18: AMOUNT okl_txl_adjsts_lns_b.AMOUNT%type,

14: ADJUSTMENT_REASON_CODE okl_trx_ar_adjsts_b.ADJUSTMENT_REASON_CODE%type,
15: COMMENTS okl_trx_ar_adjsts_tl.COMMENTS%type,
16: adjsts_lns_id okl_txl_adjsts_lns_b.ID%type,
17: payment_schedule_id okl_txl_adjsts_lns_b.PSL_ID%type,
18: AMOUNT okl_txl_adjsts_lns_b.AMOUNT%type,
19: CODE_COMBINATION_ID okl_txl_adjsts_lns_b.CODE_COMBINATION_ID%type,
20: customer_trx_id ra_customer_trx_all.customer_trx_id%type,
21: customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type
22: );

Line 19: CODE_COMBINATION_ID okl_txl_adjsts_lns_b.CODE_COMBINATION_ID%type,

15: COMMENTS okl_trx_ar_adjsts_tl.COMMENTS%type,
16: adjsts_lns_id okl_txl_adjsts_lns_b.ID%type,
17: payment_schedule_id okl_txl_adjsts_lns_b.PSL_ID%type,
18: AMOUNT okl_txl_adjsts_lns_b.AMOUNT%type,
19: CODE_COMBINATION_ID okl_txl_adjsts_lns_b.CODE_COMBINATION_ID%type,
20: customer_trx_id ra_customer_trx_all.customer_trx_id%type,
21: customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type
22: );
23: TYPE l_adj_lines_tbl_type IS TABLE OF l_adj_lines_rec_type INDEX BY BINARY_INTEGER;

Line 65: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;

61: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
62: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;
63: l_adjustment_reason_code AR_ADJUSTMENTS.REASON_CODE%TYPE;
64: l_comments AR_ADJUSTMENTS.COMMENTS%TYPE;
65: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;
66: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;
67: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
68: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;
69:

Line 298: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;

294:
295: l_type CONSTANT AR_ADJUSTMENTS.TYPE%TYPE := 'INVOICE';
296: l_created_from CONSTANT AR_ADJUSTMENTS.CREATED_FROM%TYPE := 'ADJ-API';
297:
298: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;
299: l_new_adj_id OKL_TXL_ADJSTS_LNS_B.RECEIVABLES_ADJUSTMENT_ID%TYPE;
300:
301: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;
302: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;

Line 299: l_new_adj_id OKL_TXL_ADJSTS_LNS_B.RECEIVABLES_ADJUSTMENT_ID%TYPE;

295: l_type CONSTANT AR_ADJUSTMENTS.TYPE%TYPE := 'INVOICE';
296: l_created_from CONSTANT AR_ADJUSTMENTS.CREATED_FROM%TYPE := 'ADJ-API';
297:
298: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;
299: l_new_adj_id OKL_TXL_ADJSTS_LNS_B.RECEIVABLES_ADJUSTMENT_ID%TYPE;
300:
301: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;
302: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
303: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;

Line 685: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;

681:
682: l_type CONSTANT AR_ADJUSTMENTS.TYPE%TYPE := 'INVOICE';
683: l_created_from CONSTANT AR_ADJUSTMENTS.CREATED_FROM%TYPE := 'ADJ-API';
684:
685: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;
686: l_new_adj_id OKL_TXL_ADJSTS_LNS_B.RECEIVABLES_ADJUSTMENT_ID%TYPE;
687:
688: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;
689: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;

Line 686: l_new_adj_id OKL_TXL_ADJSTS_LNS_B.RECEIVABLES_ADJUSTMENT_ID%TYPE;

682: l_type CONSTANT AR_ADJUSTMENTS.TYPE%TYPE := 'INVOICE';
683: l_created_from CONSTANT AR_ADJUSTMENTS.CREATED_FROM%TYPE := 'ADJ-API';
684:
685: l_adjsts_lns_id OKL_TXL_ADJSTS_LNS_B.ID%TYPE;
686: l_new_adj_id OKL_TXL_ADJSTS_LNS_B.RECEIVABLES_ADJUSTMENT_ID%TYPE;
687:
688: l_payment_schedule_id AR_ADJUSTMENTS.PAYMENT_SCHEDULE_ID%TYPE;
689: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
690: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;

Line 974: -- Create adjusment line record in okl_txl_adjsts_lns_b

970: LOOP
971: FETCH c_pmnt_schedule_dtls INTO c_pmnt_schedule_dtls_rec;
972: EXIT WHEN c_pmnt_schedule_dtls%NOTFOUND;
973:
974: -- Create adjusment line record in okl_txl_adjsts_lns_b
975: l_ajlv_rec.adj_id := x_adjv_rec.id;
976: l_ajlv_rec.psl_id := p_psl_id;
977: l_ajlv_rec.amount := c_pmnt_schedule_dtls_rec.amount_due_remaining;
978: l_ajlv_rec.til_id := c_pmnt_schedule_dtls_rec.til_id;

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

1089: l_tmpl_identify_tbl(1).stream_type_id := c_pmnt_schedule_dtls_rec.stream_type_id;
1090:
1091: -- Set the dist_info_rec in parameter
1092: l_dist_info_tbl(1).source_id := x_ajlv_rec.id;
1093: l_dist_info_tbl(1).source_table := 'OKL_TXL_ADJSTS_LNS_B';
1094: l_dist_info_tbl(1).accounting_date := SYSDATE;
1095: l_dist_info_tbl(1).gl_reversal_flag := G_NO;
1096: l_dist_info_tbl(1).post_to_gl := G_NO;
1097: l_dist_info_tbl(1).contract_id := c_pmnt_schedule_dtls_rec.contract_id;

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

1178: CLOSE get_account_derivation_meth;
1179:
1180: IF l_account_derivation = 'ATS' THEN
1181: -- Get the code_combination_id for the transaction
1182: OPEN c_code_combination_id(x_ajlv_rec.id, 'OKL_TXL_ADJSTS_LNS_B');
1183: FETCH c_code_combination_id INTO l_code_combination_id;
1184: CLOSE c_code_combination_id;
1185:
1186: IF l_code_combination_id = -1 OR l_code_combination_id IS NULL THEN

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

1190: p_token1_value => l_contract_number);
1191: RAISE OKL_API.G_EXCEPTION_ERROR;
1192: END IF;
1193:
1194: -- Update adjusment line record in okl_txl_adjsts_lns_b with CCID
1195: l_ajlv_rec := l_ajlv_new_rec; -- Empty the rec
1196:
1197: -- Set the rec with CCID got from accounting distibutions
1198: l_ajlv_rec.id := x_ajlv_rec.id;