APPS.OKL_LCKBX_CSH_APP_PVT dependencies on AR_PMTS_INTERFACE_LINE_DETAILS

Line 892: FROM ar_pmts_interface_line_details

888: cp_transmission_record_id IN VARCHAR2,
889: cp_invoice_number IN VARCHAR2
890: ) IS
891: SELECT 'Y'
892: FROM ar_pmts_interface_line_details
893: WHERE transmission_request_id = cp_transmission_request_id
894: AND transmission_record_id = cp_transmission_record_id
895: AND invoice_number = cp_invoice_number;
896:

Line 2089: DELETE AR_PMTS_INTERFACE_LINE_DETAILS

2085: );
2086:
2087: IF l_linelevel_app = 'Y' THEN
2088: /* -- first, delete any existing line level application data
2089: DELETE AR_PMTS_INTERFACE_LINE_DETAILS
2090: WHERE transmission_req_id = l_trans_req_id
2091: AND transmission_record_id = l_transmission_record_id
2092: AND invoice_number = l_okl_rcpt_tbl(l_inv_indx).inv_hdr_rec.invoice_number;*/-- now create line level application data
2093: IF l_okl_rcpt_tbl (l_inv_indx).inv_lines_tbl.COUNT >

Line 2114: INSERT INTO ar_pmts_interface_line_details

2110: l_amount_in_inv_curr := null;
2111: l_amount_in_rct_curr := l_okl_rcpt_tbl(l_inv_indx).inv_lines_tbl(l_line_indx).amount_applied;
2112: end if;
2113:
2114: INSERT INTO ar_pmts_interface_line_details
2115: (status,
2116: transmission_request_id,
2117: transmission_record_id,
2118: invoice_number,

Line 3325: DELETE AR_PMTS_INTERFACE_LINE_DETAILS

3321: );
3322:
3323: IF l_linelevel_app = 'Y' THEN
3324: /* -- first, delete any existing line level application data
3325: DELETE AR_PMTS_INTERFACE_LINE_DETAILS
3326: WHERE transmission_req_id = l_trans_req_id
3327: AND transmission_record_id = l_transmission_record_id
3328: AND invoice_number = l_okl_rcpt_tbl(l_inv_indx).inv_hdr_rec.invoice_number;*/-- now create line level application data
3329: IF l_okl_rcpt_tbl (l_inv_indx).inv_lines_tbl.COUNT >

Line 3351: INSERT INTO ar_pmts_interface_line_details

3347: l_amount_in_inv_curr := null;
3348: l_amount_in_rct_curr := l_okl_rcpt_tbl (l_inv_indx).inv_lines_tbl
3349: (l_line_indx).amount_applied;
3350: end if;
3351: INSERT INTO ar_pmts_interface_line_details
3352: (status,
3353: transmission_request_id,
3354: transmission_record_id,
3355: invoice_number,