DBA Data[Home] [Help]

APPS.FUN_TRX_PUB dependencies on FUN_INTERFACE_DIST_LINES

Line 663: fun_interface_dist_lines dist

659: -- Bug: 7695801
660: select trxh.to_ledger_id
661: into l_to_ledger_id
662: from fun_interface_headers trxH,
663: fun_interface_dist_lines dist
664: where dist.trx_id = trxH.trx_id
665: and dist.dist_id = l_dist_lines_rec_type.dist_id;
666:
667: -- Pass Recipient Legal entity Id

Line 726: UPDATE fun_interface_dist_lines set import_status_code = 'R'

722: If (l_return_status = FND_API.G_RET_STS_ERROR) then
723:
724: If (P_calling_sequence = 'Intercompany Import Program') then
725: Print('Val and Insert >>>>'||'Inserting Dist Lines Reject Reasons');
726: UPDATE fun_interface_dist_lines set import_status_code = 'R'
727: Where dist_id = p_dist_lines_tbl(l_line_count).dist_id;
728:
729: IF l_msg_count >= 1 THEN
730: FOR i IN 1..l_msg_count

Line 750: UPDATE fun_interface_dist_lines set import_status_code = 'A'

746: End if; -- p_calling_sequence
747: ELSE
748: If (P_calling_sequence = 'Intercompany Import Program') then
749:
750: UPDATE fun_interface_dist_lines set import_status_code = 'A'
751: Where dist_id = p_dist_lines_tbl(l_line_count).dist_id;
752: End If;
753:
754: End if; -- l_return_status