[Home] [Help]
2611: p_msg_data OUT NOCOPY VARCHAR2
2612: ) IS
2613:
2614: cursor gt_lines_cur (p_cust_trx_id in number) is
2615: select * from ar_llca_trx_lines_gt
2616: where customer_trx_id = p_cust_trx_id;
2617:
2618: l_gt_count NUMBER;
2619: l_line_amount_remaining NUMBER;
2726: END IF;
2727: END IF;
2728:
2729: select count(*) into l_gt_count
2730: from ar_llca_trx_lines_gt
2731: where customer_trx_id = p_customer_trx_id
2732: and rownum = 1;
2733:
2734: -- For All Lines, Amount due remaining / line remaining will be defaulted later.
2939: END IF;
2940:
2941: -- Update the GT table with calculated values
2942:
2943: Update ar_llca_trx_lines_gt
2944: set amount_applied = Nvl(l_calc_tot_amount_app,0),
2945: line_amount = Nvl(l_calc_line_amount,0),
2946: tax_amount = Nvl(l_calc_tax_amount,0)
2947: where customer_trx_id = p_customer_trx_id
4265: p_llca_type IN VARCHAR2,
4266: p_return_status OUT NOCOPY VARCHAR2
4267: ) IS
4268: cursor c1 (p_cust_trx_id in number) is
4269: select * from ar_llca_trx_lines_gt
4270: where customer_trx_id = p_cust_trx_id;
4271: l_cust_trx_line_id Number;
4272: BEGIN
4273: IF PG_DEBUG in ('Y', 'C') THEN
4347: WHERE customer_trx_id = p_customer_trx_id
4348: AND line_number = i.line_number
4349: AND line_type = 'LINE';
4350:
4351: Update ar_llca_trx_lines_gt
4352: set customer_trx_line_id = l_cust_trx_line_id
4353: where customer_trx_id = p_customer_trx_id
4354: and line_number = i.line_number;
4355: EXCEPTION
8090:
8091: p_return_status := FND_API.G_RET_STS_SUCCESS;
8092:
8093: -- Clean the GT Table first.
8094: delete from ar_llca_trx_lines_gt
8095: where customer_trx_id = p_customer_trx_id;
8096:
8097: delete from ar_llca_trx_errors_gt
8098: where customer_trx_id = p_customer_trx_id;
8125:
8126: --bug7311231, Populating the GT table with flexfield information of each line.
8127: For i in p_llca_trx_lines_tbl.FIRST..p_llca_trx_lines_tbl.LAST
8128: Loop
8129: Insert into ar_llca_trx_lines_gt
8130: ( customer_trx_id,
8131: customer_trx_line_id,
8132: line_number,
8133: line_amount,