DBA Data[Home] [Help]

APPS.OKL_CREATE_ADJST_PVT dependencies on OKL_TRX_AR_ADJSTS_B

Line 12: ( APPLY_DATE okl_trx_ar_adjsts_b.APPLY_DATE%type,

8: IS_DEBUG_STATEMENT_ON BOOLEAN;
9: IS_DEBUG_EXCEPTION_ON BOOLEAN;
10:
11: TYPE l_adj_lines_rec_type IS RECORD
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,

Line 13: GL_DATE okl_trx_ar_adjsts_b.GL_DATE%type,

9: IS_DEBUG_EXCEPTION_ON BOOLEAN;
10:
11: TYPE l_adj_lines_rec_type IS RECORD
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,

Line 14: ADJUSTMENT_REASON_CODE okl_trx_ar_adjsts_b.ADJUSTMENT_REASON_CODE%type,

10:
11: TYPE l_adj_lines_rec_type IS RECORD
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,

Line 928: -- Create adjusment header record in okl_trx_ar_adjsts_b

924: CLOSE c_pmnt_schedule_summary;
925:
926: IF l_total_amt_due_remaining IS NOT NULL AND l_total_amt_due_remaining <> 0 THEN
927:
928: -- Create adjusment header record in okl_trx_ar_adjsts_b
929: l_adjv_rec.adjustment_reason_code:= 'WRITE OFF';
930: l_adjv_rec.apply_date := SYSDATE;
931: l_adjv_rec.gl_date := SYSDATE;
932: l_adjv_rec.trx_status_code := 'WORKING';

Line 1159: p_trx_header_table =>'OKL_TRX_AR_ADJSTS_B');

1155: p_acc_gen_primary_key_tbl => l_acc_gen_tbl,
1156: x_template_tbl => l_template_out_tbl,
1157: x_amount_tbl => l_amount_out_tbl,
1158: p_trx_header_id => x_adjv_rec.id,
1159: p_trx_header_table =>'OKL_TRX_AR_ADJSTS_B');
1160:
1161: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1162: OKL_API.set_message( p_app_name => G_APP_NAME,
1163: p_msg_name => 'OKL_AM_ERR_ACC_ENT_MSG',