[Home] [Help]
2706: p_msg_data OUT NOCOPY VARCHAR2
2707: ) IS
2708:
2709: cursor gt_lines_cur (p_cust_trx_id in number) is
2710: select * from ar_llca_trx_lines_gt
2711: where customer_trx_id = p_cust_trx_id;
2712:
2713: l_gt_count NUMBER;
2714: l_line_amount_remaining NUMBER;
2829: END IF;
2830: END IF;
2831:
2832: select count(*) into l_gt_count
2833: from ar_llca_trx_lines_gt
2834: where customer_trx_id = p_customer_trx_id
2835: and rownum = 1;
2836:
2837: -- For All Lines, Amount due remaining / line remaining will be defaulted later.
3105:
3106:
3107: -- Update the GT table with calculated values
3108:
3109: Update ar_llca_trx_lines_gt
3110: set amount_applied = Nvl(l_calc_tot_amount_app,0),
3111: line_amount = Nvl(l_calc_line_amount,0),
3112: tax_amount = Nvl(l_calc_tax_amount,0)
3113: where customer_trx_id = p_customer_trx_id
4494: p_llca_type IN VARCHAR2,
4495: p_return_status OUT NOCOPY VARCHAR2
4496: ) IS
4497: cursor c1 (p_cust_trx_id in number) is
4498: select * from ar_llca_trx_lines_gt
4499: where customer_trx_id = p_cust_trx_id;
4500: l_cust_trx_line_id Number;
4501: BEGIN
4502: IF PG_DEBUG in ('Y', 'C') THEN
4576: WHERE customer_trx_id = p_customer_trx_id
4577: AND line_number = i.line_number
4578: AND line_type = 'LINE';
4579:
4580: Update ar_llca_trx_lines_gt
4581: set customer_trx_line_id = l_cust_trx_line_id
4582: where customer_trx_id = p_customer_trx_id
4583: and line_number = i.line_number;
4584: EXCEPTION
8389:
8390: p_return_status := FND_API.G_RET_STS_SUCCESS;
8391:
8392: -- Clean the GT Table first.
8393: delete from ar_llca_trx_lines_gt
8394: where customer_trx_id = p_customer_trx_id;
8395:
8396: delete from ar_llca_trx_errors_gt
8397: where customer_trx_id = p_customer_trx_id;
8424:
8425: --bug7311231, Populating the GT table with flexfield information of each line.
8426: For i in p_llca_trx_lines_tbl.FIRST..p_llca_trx_lines_tbl.LAST
8427: Loop
8428: Insert into ar_llca_trx_lines_gt
8429: ( customer_trx_id,
8430: customer_trx_line_id,
8431: line_number,
8432: line_amount,