DBA Data[Home] [Help]

APPS.FUN_TRX_PUB dependencies on FUN_INTERFACE_HEADERS

Line 521: UPDATE fun_interface_headers set import_status_code = 'R' Where trx_id = p_trx_tbl(l_head_count).trx_id;

517:
518: If (l_return_status = FND_API.G_RET_STS_ERROR) then
519: If (p_calling_sequence = 'Intercompany Import Program') then
520: Print('Val and Insert >>>>'||'Inserting Trx Header Reject Reasons');
521: UPDATE fun_interface_headers set import_status_code = 'R' Where trx_id = p_trx_tbl(l_head_count).trx_id;
522: -- Insert into Rejections Table
523: IF l_msg_count >= 1 THEN
524: FOR i IN 1..l_msg_count
525: LOOP

Line 543: UPDATE fun_interface_headers set import_status_code = 'A'

539: End if; -- Calling Sequence
540:
541: ELSE
542: If (P_calling_sequence = 'Intercompany Import Program') then
543: UPDATE fun_interface_headers set import_status_code = 'A'
544: Where trx_id = p_trx_tbl(l_head_count).trx_id;
545: End if; -- Calling Sequence
546:
547: END IF; -- return_status

Line 663: from fun_interface_headers trxH,

659: End Loop;
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: