APPS.IEC_STATUS_PVT dependencies on IEC_G_RETURN_ENTRIES

Line 576: '(SELECT RETURNS_ID FROM IEC_G_RETURN_ENTRIES WHERE LIST_HEADER_ID = :1)'

572:
573: -- REMOVE ENTRIES FROM THE CALL HISTORIES TABLE FOR THIS TARGET GROUP.
574: BEGIN
575: EXECUTE IMMEDIATE 'DELETE FROM IEC_O_RCY_CALL_HISTORIES WHERE RETURNS_ID IN ' ||
576: '(SELECT RETURNS_ID FROM IEC_G_RETURN_ENTRIES WHERE LIST_HEADER_ID = :1)'
577: USING p_list_id;
578: EXCEPTION
579: WHEN OTHERS THEN
580: LOG ( l_method_name

Line 684: EXECUTE IMMEDIATE 'DELETE FROM IEC_G_RETURN_ENTRIES WHERE LIST_HEADER_ID = :1'

680: END;
681:
682: -- REMOVE ENTRIES FROM THE AO ENTRIES TABLE FOR THIS TARGET GROUP.
683: BEGIN
684: EXECUTE IMMEDIATE 'DELETE FROM IEC_G_RETURN_ENTRIES WHERE LIST_HEADER_ID = :1'
685: USING p_list_id;
686: EXCEPTION
687: WHEN OTHERS THEN
688: LOG ( l_method_name

Line 782: FROM IEC_G_RETURN_ENTRIES A, IEO_SVR_RT_INFO B

778:
779: -- Get list of STOPPED servers that have records checked out
780: SELECT DISTINCT B.SERVER_ID
781: BULK COLLECT INTO l_stopped_server_id_col
782: FROM IEC_G_RETURN_ENTRIES A, IEO_SVR_RT_INFO B
783: WHERE A.CHECKOUT_ACTION_ID = B.SERVER_ID
784: AND A.LIST_HEADER_ID = p_list_id
785: AND A.RECORD_OUT_FLAG = 'Y'
786: AND B.STATUS = 1;

Line 791: UPDATE IEC_G_RETURN_ENTRIES

787:
788: -- Recover any records that are checked out to STOPPED servers
789: IF l_stopped_server_id_col IS NOT NULL AND l_stopped_server_id_col.COUNT > 0 THEN
790: FORALL i IN l_stopped_server_id_col.FIRST..l_stopped_server_id_col.LAST
791: UPDATE IEC_G_RETURN_ENTRIES
792: SET RECORD_OUT_FLAG = 'N'
793: , CHECKOUT_ACTION_ID = NULL
794: , LAST_UPDATE_DATE = SYSDATE
795: WHERE LIST_HEADER_ID = p_list_id

Line 802: FROM IEC_G_RETURN_ENTRIES

798:
799: -- Check if all records have been checked back in
800: SELECT COUNT(*)
801: INTO l_records_out
802: FROM IEC_G_RETURN_ENTRIES
803: WHERE LIST_HEADER_ID = p_list_id
804: AND RECORD_OUT_FLAG = 'Y';
805:
806: IF l_records_out = 0 THEN

Line 876: FROM IEC_G_RETURN_ENTRIES A, IEO_SVR_RT_INFO B

872:
873: -- Get list of STOPPED servers that have records checked out
874: SELECT DISTINCT B.SERVER_ID
875: BULK COLLECT INTO l_stopped_server_id_col
876: FROM IEC_G_RETURN_ENTRIES A, IEO_SVR_RT_INFO B
877: WHERE A.CHECKOUT_ACTION_ID = B.SERVER_ID
878: AND A.LIST_HEADER_ID = l_list_id
879: AND A.RECORD_OUT_FLAG = 'Y'
880: AND B.STATUS = 1;

Line 885: UPDATE IEC_G_RETURN_ENTRIES

881:
882: -- Recover any records that are checked out to STOPPED servers
883: IF l_stopped_server_id_col IS NOT NULL AND l_stopped_server_id_col.COUNT > 0 THEN
884: FORALL i IN l_stopped_server_id_col.FIRST..l_stopped_server_id_col.LAST
885: UPDATE IEC_G_RETURN_ENTRIES
886: SET RECORD_OUT_FLAG = 'N'
887: , CHECKOUT_ACTION_ID = NULL
888: , LAST_UPDATE_DATE = SYSDATE
889: WHERE LIST_HEADER_ID = l_list_id

Line 896: FROM IEC_G_RETURN_ENTRIES

892:
893: -- Check if all records have been checked back in
894: SELECT COUNT(*)
895: INTO l_records_out
896: FROM IEC_G_RETURN_ENTRIES
897: WHERE LIST_HEADER_ID = l_list_id
898: AND RECORD_OUT_FLAG = 'Y';
899:
900: IF l_records_out = 0 THEN