DBA Data[Home] [Help]

APPS.ITA_SETUP_REC_VALUES_PKG dependencies on ITA_SETUP_REC_INTF

Line 552: ITA_SETUP_REC_INTF

548: SECURITY_GROUP_ID ,
549: OBJECT_VERSION_NUMBER,
550: REC_INTERFACE_ID
551: FROM
552: ITA_SETUP_REC_INTF
553: WHERE
554: BATCH_ID = X_BATCH_ID and
555: CREATED_BY = X_CREATED_BY and
556: IMPORTED_FLAG <> 'Y';

Line 661: --update ITA_SETUP_REC_INTF

657: END;
658: end if;
659:
660:
661: --update ITA_SETUP_REC_INTF
662: --set IMPORTED_FLAG = 'Y'
663: --where REC_INTERFACE_ID = interface_row.REC_INTERFACE_ID;
664:
665: if m_error_msg is null then

Line 666: delete from ITA_SETUP_REC_INTF

662: --set IMPORTED_FLAG = 'Y'
663: --where REC_INTERFACE_ID = interface_row.REC_INTERFACE_ID;
664:
665: if m_error_msg is null then
666: delete from ITA_SETUP_REC_INTF
667: where REC_INTERFACE_ID = interface_row.REC_INTERFACE_ID;
668: end if;
669:
670: end if;

Line 679: update ITA_SETUP_REC_INTF

675:
676: EXCEPTION
677: WHEN OTHERS THEN
678: m_error_msg := substr(SQLERRM, 1, 3000);
679: update ITA_SETUP_REC_INTF
680: set STATUS_TXT = m_error_msg
681: where REC_INTERFACE_ID = m_rec_interface_id;
682:
683: