DBA Data[Home] [Help]

APPS.FUN_TRX_PUB dependencies on FUN_INTERFACE_DIST_LINES

Line 664: fun_interface_dist_lines dist

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

Line 727: UPDATE fun_interface_dist_lines set import_status_code = 'R'

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

Line 751: UPDATE fun_interface_dist_lines set import_status_code = 'A'

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